Access Shared Database Front End Increases in size

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
 
D

Douglas J. Steele

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.
 
J

Jason

Doug,

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

Jason
 
Top