Shared .mde (2002)

[allenjasonbrown@gmail.com]

I have an 2002 Access DB (MDE) which is on a shared network so multiple users can open it at the same time.

Most of the tables are linked to a SQL server. The DB just runs reports, but in creating the report it inserts records into a 'local' table and then runs report and then deletes the records in temporary table.

Does anyone know if the users will encounter any issues with the 'local' tables? Or when the users open the DB, do they get their own "copy" of the DB?

Thanks.

[pbaldy]

do they get their own "copy" of the DB?

No, they don't. The application should be split:

http://www.granite.ab.ca/access/splitapp/index.htm

[boblarson]

Just for emphasis, I'll post with Paul -

Split the application and give the users their OWN copy of the frontend.

Here's another link which tells why you should split:
http://www.kallal.ca/Articles/split/index.htm