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
 
Back
Top