Hi, Akilah.
[Quoted Text] > 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.
"Akilah" <Akilah[ at ]discussions.microsoft.com> wrote in message
news:1BEB5F42-2EFC-4113-B4B7-6E30D3F3CEB5[ at ]microsoft.com...
>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
|