Updating data in a multiuser environment

[Guest]

I have a mdb file in a server folder that several users have access to, but
when there's at leat one user using it, then it becomes read only for every
one else. In other words, I have to ask everybody to exit the file so I can
update it.
p.s. I've already tried spitting the file and it didn't work.

 

[Joseph Meehan]

I have a mdb file in a server folder that several users have access
to, but when there's at leat one user using it, then it becomes read
only for every one else. In other words, I have to ask everybody to
exit the file so I can update it.
p.s. I've already tried spitting the file and it didn't work.

Each user need full access (read edit create delete) and they all need
to assure their default method of opening a file is not set to exclusive.

However it appears you have another problem, even if you fix the one you
asked about.

When sharing data, you should have the data stored on the server in a
back end database and each user should have their own copy of a front end
database on their own machine. The back end houses all the shared data and
the front ends have queries, forms and reports with links to the back end
data. This makes things work a lot better and avoids many many problems.

Access has a database splitter wizard. Look under tools, database
utilities. Also check out the help file for more information on splitting.

 

[Guest]

Hi WaPinheiro,

As Joseph has indicated, all users need to have RWCD privileges to the
shared folder. If each user has their own copy of the FE installed on their
local hard drive, then it becomes immaterial as to whether or not they have
changed their default open mode from Shared to Exclusive. This mode will
apply only to their copy of the FE file--it is not propagated to a shared BE
file.

Here is an article that contains lots of tips for you:
Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html

The three most important things are:
1.) Disable NameAutocorrect
2.) Set all table SubDatasheets to [None] and
3.) Ensure that you have a persistent connection to the BE database.

p.s. I've already tried spitting the file and it didn't work.

What didn't work about it?


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[ortaias]

I have a single user database that I am attempting to convert to a
multiuser database. I have been getting the error message that the main
table is locked. By splitting the database, I have been able to get it
to work, except for a couple of remaining issues. I have posted my
problem on this forum. In short, it appears that you can
unintentionally lock your recordset through code. I am still trying to
figure it out.

See Chapter 12 of "Programming Microsoft Access Version 2002" by Rick
Dobson which discussess how to make your database multiuser.