Question Access 93 : Queries & Reports

[grinder332518]

Can someone advise on the following please ?

I developed a system for remote offices which do not have access to network drives.
I visited all these offices, and installed the mdb on their C drives.

Each month, they all export 5 tables, and email them to their boss here in Head Office, who then imports them into his own mdb.
He will then be able to run various queries and reports against all this data.

This works fine.

Eventually the remote offices will also be required to run queries and reports.

I have my own copy of the mdb, and have developed the necessary queries and reports, which will shortly be ready for installation.

My question is this :
How can I transfer any queries and reports from my mdb to those of others ?

I would have thought I could do this by exporting and importing, but this does not seem to work.

If I try to export a Report, what I get is the output from the Report, not the Source, which is what I need.

Or is this the wrong approach entirely ?

I have tried Googling the problem, and have seen something about Application.SaveAsText, which is an addon, but I don't have the necessary privileges to install this, and it would contravene corporate policy anyway should I attempt to.

Surely there has to be a simple way in MS Access to transfer Queries and Reports to and from mdbs !

 

[jdraw]

Can someone advise on the following please ?

I developed a system for remote offices which do not have access to network drives.
I visited all these offices, and installed the mdb on their C drives.

Each month, they all export 5 tables, and email them to their boss here in Head Office, who then imports them into his own mdb.
He will then be able to run various queries and reports against all this data.

This works fine.

Eventually the remote offices will also be required to run queries and reports.

I have my own copy of the mdb, and have developed the necessary queries and reports, which will shortly be ready for installation.

My question is this :
How can I transfer any queries and reports from my mdb to those of others ?

I would have thought I could do this by exporting and importing, but this does not seem to work.

If I try to export a Report, what I get is the output from the Report, not the Source, which is what I need.

Or is this the wrong approach entirely ?

I have tried Googling the problem, and have seen something about Application.SaveAsText, which is an addon, but I don't have the necessary privileges to install this, and it would contravene corporate policy anyway should I attempt to.

Surely there has to be a simple way in MS Access to transfer Queries and Reports to and from mdbs !

You are in a very manual, procedural environment. You may want to look at other alternatives for the future. However, for your immediate question :
How can I transfer any queries and reports from my mdb to those of others ?

This is a general approach that I would try - If your remote colleagues are Access savvy- .

At your end:
1.Create an empty Access mdb
2.Open this new mdb
3.Go to Get External Data - Import
4.Identify your database with the appropriate Queries and Reports as the source of the external data
5.Select each of the queries and reports etc that you want to distribute.
6.These will be imported to your new mdb.
7.Make a backup of your new mdb (now populated)
8.Send an email to each of your remote colleagues with your new mdb attached (could be a zip file)


At each remote end:
1. Save the attached mdb to a known location.
2. Open their current datadase.
3. Go to Get external data - Import
4. Identify the new database as the Source of the external data
5. Select each of the queries, reports etc that are to be used
6. These will be imported into the remote database.

Note: Your email and other communications with the remote sites has to be extremely clear and specific. I have used this process on occasion, but as I said earlier - the remote user/admin has to be Access/Computer savvy.

But then again, you could visit each site and do the process locally. u

 

[grinder332518]

Hi JDraw
Many thanks for your response, and I can see how this solution will indeed work for me.
Unfortunately my users are not very Access/Computer savvy, but that is my problem.
Thanks again !

 

[Rabbie]

Just curious. What do you mean by Access 93?. The oldest version I have seen being used is Access 97. I know there was Access 95 but that seems to be completely obsolete

 

[SOS]

Yeah, there was Access 1, Access 2, Access 95, Access 97, Access 2000, Access XP (2002), Access 2003, Access 2007 and soon Access 2010.

 

[grinder332518]

Sorry guys : It was a typo' : I meant to write 2003. Too old !

 

[Simon_MT]

Depending on the importance of the dtabase to your company I would suggest using a Terminal Server with the remote users logging into the one server with one database and local printers, the database being on a file server everyone has access to.

In the end it is a lot easy and centrally available to all you users.

Simon

 

[grinder332518]

Hi Simon
Our IT people are looking at these offices as we speak, with a view to implementing a solution similar to what you have suggested. Unfortunately, this isn't likely to be implemented until the summer. So the existing setup was agreed, to allow the project to proceed, and to give the users there some time to familiarise themselves with the application and its funcionality.
Many thanks for all contributions !