Multiple users accessing the same table in a db

  • Thread starter Thread starter Lisa-Marie
  • Start date Start date
L

Lisa-Marie

Hello. I want to know how to arrange for two (multiple)
users to use the same mbd table at the same time without
any error messages. According to one of the users, it was
set up this way when we used Access 97, but we've updated
to 2000. I'm new to this software and need some
assistance. I hope I've posted to the correct newsgroup.
 
What are the two users going to be doing? are they
accessing reports? or inputing new data?
 
By "two users", do you actually mean "two PCs"?

If so, the application must be split into a so-called "front end/back end"
structure. The front end database has all of the queries, forms, reports,
macros & modules in the application. There is a seperate copy of the FE, on
each PC. The back end database has all of the tables. There is a single copy
of the BE, somewhere suitable (eg. a server, or the largest of the two PCs).
Each FE links to the tables in the BE.

By that means, everyone using the two PCs is actually using a single copy of
the database tables. This is no different in A2k, to A97. Upgrading from A97
to A2k would not, in and of itself, cause a FE/BE application to stop
working.

You refer to "error messages". Are you actually getting some? (Hint: it
might be useful if we knew what they were...)

HTH,
TC
 
Sorry, this is my first time using the newsgroups. Yes,
two PCs. The error messages I'm referring to are actually
messages that state the other user is accessing the file.
 
Back
Top