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

Hi, Akilah.

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.

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.

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.


Show quoteHide quote

Adv/disadv of using Access built-in security tools vs build in db
Network Security multiple users, Getting rid of the warning messag
corrupt files
Installed updates, now macros don't work!
Creating security for MS Access application
log in problems
workgroup information file (WIF) problem
Missing User data on some macros stops conversion of Access97 to Access2003
logon
security applied to all my DBs