Access Shared Database Front End Increases in size

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

Platform: Microsoft Access 2003

Senario: I have a Front End and Back End on a shared drive.

Problem: When a user accesses the Front End, the size of the file increases.

Question: Is this normal or is there something I can do to prevent this
 
It's common. Front-ends often require temporary objects be created, and that
will cause the size to increase.

BTW, my recommendation would be not to have a shared front-end. Each user
should have his/her own copy of the front-end, preferably on their hard
drive (as opposed to on the server). This will significantly decrease the
chance of corruption, and should lead to reduced network traffic.
 
Doug,

Thanks for the help. Once we finalize the front-end I plan to move it to
the desktop.

Jason
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

suddently my front-end had a strange increase size 2
Access front end to Oracle table user load 3
Split Database vs. Access Project 3
Split Database 9
Runtime error -file sharing lock count exceeded 5
can't open the front-end database file of a split db 1
compatibility in MS Access 2007 3
Access front-end / back-end DB Network Bandwidth 7

Back
Top