Performance Issue with an Access File Updated through an .accde file with Linked Tables

10 pts.
Tags:
Access Database
Microsoft Access
Microsoft Access 2007
I have an Access 2007 Database for tracking daily time for 90+/- employees located on a shared network folder. To enter tasks and time, users click a batch file, which copies a separate .accde file to their C: drive and then opens the file. This .accde file contains a Form for data entry, linked tables to the main database and some queries to filter the various pick lists. All the data tables are in the main database, so really users are just “pushing” data from the form back to the main database. My problem is the main database file gets bigger each day, not because of the data being stored, but it seems to grow each time a user runs the batch file and ‘connects’ to the main database. Not only does the file size increase 200-300 KB each day, the .accde file on the user’s C: drive becomes less responsive – sometimes requiring several minutes to open. When I manually backup the main database from Access, the file size of the backup is only 2300 KB. I then replace the file with the backup and it works fast again, but only temporarily. Any ideas or suggestions for improving this process would be appreciated.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following