Speed Up Access 2007 and export to Excel

[Bigmix]

Please help!



I have two databases.

The first database contains all the ODBC links, queries, and creates local tables to be used in the first database.

The second Database uses a form imports the tables from the backend, queries those tables to a specific customer, creates new tables and exports those tables to excel for field use.

The reason for the import into the second table is that sometimes the users are in the field and our VPN security is so tight that it would be too slow to query off the system.

I am dealing with several customers, and now I am getting occasional calls about the database erroring or timing out. I am needing help to correct this action.

Steps I have taken so far:
I have run the analyzer and made the changes except for relationships.
I have set the frontend to compact and repair on close. (Very slow also)
I have convert make table queries to Delete + Append.

The database is about 813,500 KB in size. It is very frustrating.

Also, occasionally, the tables in excel will not be replaced. It will be data from the old customer. I am exporting to a template xlsm file.

It is frustrating trying to field these questions constantly. Any help on either topic would be greatly appreciated.

[tanvi]

Here are the all tips to improve your access database speed: http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx
Here are all steps to export Access database to Excel :http://databases.about.com/cs/tutorials/a/aa033003a.htm