mde file

[Akilah]

I created a mde in a folder and copied it to other folder for other users.
Sometimes the forms and queried don't function properly. Does the mde and
mdb need to be in the same folder or can I make a mde in one folder and copy
it to other folders and make shortcuts? Also, how can I keep the size of the
mde file from growing?

Thanks

 

['69 Camaro]

Hi, Akilah.

Sometimes the forms and queried don't function properly.

You'll need to be a little more specific before we can help you determine
what the problem is and then provide guidance on how to fix it.

Does the mde and
mdb need to be in the same folder

No. The MDE file can be placed in any directory where you have Windows
security permissions to read and modify this file, and create, read, modify,
and delete the LDB file. As a matter of fact, it's usually a bad idea to
run the MDB file and MDE file from the same directory, because you could get
error messages when both files are open and the database needs to be in
exclusive mode. Both files will create or modify the same LDB file when
they're open, so the illusion that there is more than one user connecting to
the database will prevent certain operations.

Also, how can I keep the size of the
mde file from growing?

Compact it periodically.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.