A
Andrew
Is there a way that multi users are able to update infromation at the same time
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
George Hepworth
There is more than one answer to that question, but they involve additional
questions.
The short answer is "No," if by that you mean can two or more people update
the same RECORD at the same time.
The short answer is "Yes", if by that you mean can two or more people update
DIFFERENT records in the same database, or even within the same table at the
same time.
The questions come next. Do you have a (properly designed) database in which
the data is separate from the interface? I.e., are the tables in one mdb (or
accdb) file and the forms, reports, queries and code in another? If not
that is the very first thing you should do in any case: Split the database
into a Front End (FE) and a Back End (BE) with tables only in the BE.
Does each user have their own, separate, copy of the FE? If not, they
should.
Is there a single copy of the BE located on a shared folder so that each FE
can be linked to it? If not it should be moved to such a location.
And, does each of your users have full read-write permissions on the shared
folder where the BE resides? They'll need that.
Also, have you turned of Compact & Repair on Close? That needs to be turned
off to avoid issues with multiple users.
questions.
The short answer is "No," if by that you mean can two or more people update
the same RECORD at the same time.
The short answer is "Yes", if by that you mean can two or more people update
DIFFERENT records in the same database, or even within the same table at the
same time.
The questions come next. Do you have a (properly designed) database in which
the data is separate from the interface? I.e., are the tables in one mdb (or
accdb) file and the forms, reports, queries and code in another? If not
that is the very first thing you should do in any case: Split the database
into a Front End (FE) and a Back End (BE) with tables only in the BE.
Does each user have their own, separate, copy of the FE? If not, they
should.
Is there a single copy of the BE located on a shared folder so that each FE
can be linked to it? If not it should be moved to such a location.
And, does each of your users have full read-write permissions on the shared
folder where the BE resides? They'll need that.
Also, have you turned of Compact & Repair on Close? That needs to be turned
off to avoid issues with multiple users.
J
John W. Vinson
Is there a way that multi users are able to update infromation at the same time
Access is multiuser, out of the box. As noted elsethread you should "split"
the database for safety and efficiency, but (so long as neither user is
actively making changes to the STRUCTURE of the database) multiple users can
update data in the tables simultaneously. The official limit is 255 users, but
I'd be cautious about getting above fifty or so.
T
Tom Wickerath
Hi Andrew,
Here is an article that you should find helpful:
Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
Here is an article that you should find helpful:
Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
G
George
I made a slight mistake in not wording part of my statement.
If your users are sharing a single file, having compact & repair on close
set to "yes" will be a source of problems. If each user has their own copy
of the FE, having it set in their copy, of course, won't interfere with
other users.
If your users are sharing a single file, having compact & repair on close
set to "yes" will be a source of problems. If each user has their own copy
of the FE, having it set in their copy, of course, won't interfere with
other users.