[AccessD] Importing remote reports to client frontend

Hi Doug

Thanks. Working for 10 years must be a proof of concept.

Another method I was thinking of, is to store the reports as blobs in SQL Server, then extract these somehow - it is not something I have tried. Or store the SaveAsText version of the report as a memo in a table field; then it is easy to read this, save as a temp file, and then use LoadFromText.

I'll have to do some testing.

/gustav

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Doug Murphy
Sendt: 30. september 2014 20:02
Til: 'Access Developers discussion and problem solving'
Emne: Re: [AccessD] Importing remote reports to client frontend

Gustav,

Since there are no other takers, I'll offer an idea. You could have the client app either download a text file from your server, import as report, then delete the file. Or you could have the client app stream the file off the server, save it to the client, import into a new report then delete the temp text file. I did something like this long ago when the web tools weren't that good, I'd stream a web page, which was a big table, into Access then parse it to get the data I wanted. Not elegant, but it still works as we have not changed that part of the application in 10 years.

Doug

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Monday, September 29, 2014 9:49 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Importing remote reports to client frontend

Hi all

A frontend A2013 application is distributed to clients.
It connects to tables and views at a remote SQL Server. No problem.

However, each client may have one or more reports with a custom layout.
These should be imported to the frontend.
This is quite easy if you have a local accdb containing the reports. But would there be another method where you wouldn't need to distribute a local accdb with the reports?

You could download a file, text or accdb, and import the reports from this, but I would prefer a method where a local file is not needed. Any ideas?

/gustav