Multi Users in Access

[thalam]

Hi guys,

I'm having some issues with a database that I have created. All this time only one user would be in the database. But now I have 2 to 3 people at a time in the database. I get an error and its not letting the users put any information in.

I have it split into a FE and BE. I have it set to share. Any thoughts or suggestions?

Thanks a lot!

 

[boblarson]

I would highly suggest giving a copy of the front end to each user. That way, if someone has default settings of opening exclusive, then it won't matter (plus another whole laundry list of reasons why that would be better too).

 

[KeithG]

Search the forum for FE and BE you should find some good posts.

 

[Fifty2One]

Im with the same thoughts as Bob Larson on distributing front end to each user rather than multi users.
My worst case scenario was when in the past I was working in a place where they had Mr.ClickHappy working on the shop floor who would routinely accidentally crash all sorts of applications... guess what happened to some of my work

 

[thalam]

Thanks a lot for the response. I have given each of the users their own FE. But when they open the database and go to modify or make changes, it locks them saying they can't make any changes. or that it won't save the changes. I have looked around the forum here, and there were quite a few discussion on FE and BE. But none that applied to my situation.

 

[KeithG]

Can the users enter the BE directly with out the warnings?

 

[thalam]

Hi there,

Sorry it took me a while to reply here. I've been out of the office. I've gone directly to the BE and had two computer go in at the same time and they were able to edit the information without any problem.

 

[thalam]

I think I've found the problem. The clients whom I've designed this database for, were linking to the same FE instead of it being on their individual work stations. Thanks everyone for all the help.