allowing multiple users in one db

  • Thread starter Thread starter Tracey
  • Start date Start date
T

Tracey

I have a few databases that were recently converted to
access xp. The users tell me at one time they were able to
be in and work in the same database w/out errors. Now the
second user cannot even open the db. They get an error
Error 3734 and that is it.

What do i need to do to allow multiple users in a db? both
could be adding and updating info.

thanks
 
I would make sure that the application is free of errors (while looking at
code...do a compile and save all).

You should also realize that you can't have multiple users in a
database..and modify the forms while this occurs.

You can however have multiple users updating the data.

This means that you need to split your database into two parts.

Front end part (code, forms, reports). Each users gets a copy of this on
their pc. So, you NEVER want to allow multiplate users into the applcation
part that you create..

Back end part (the data tables). This is the back end data part that your
share to everyone (usually this goes on your server).

Further, you should also be distribution a mde file to each user.

For information on splitting ..check out:

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

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm

And also check out:

http://www.granite.ab.ca/access/autofe.htm
 
I would like to move to kind of model from our current
replication model - is there anything special I have to do
to allow many users to update the same table in the back
end database?
 
Back
Top