How do I set up a an Access DB so users can open simultaneously

P

Pat Hartman\(MVP\)

Access databases can be shared. The preferred method is to split the
application into two databases. One database, called the back end, will
contain ONLY tables. The other database, called the front end, will contain
all other objects plus links to the tables in the back end. The back end
database is placed on a network share and the front end is distributed to
each user although it is possible to share the front end also. It just
makes for a less stable setup.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top