Split DB Question - Multi User Environment Launch

[aussie92]

Hey Everyone -



I need help!!! I have a lauching today and it is not going well....

I have a database where everything is determined by user ID (which I have the database pick up based on the computer). My problem is, anytime someone tries to pull a form, it throws an error saying that someone is already in the database. It gives the computer number of who that is so I know it is not a bogus error, but I have tried everything and it does not let users access anything at the same time!!!

I have the database split and I tried having users download the front end and even rename it and it still says if someone is in the db!! How is that possible when it is a copy?

Please help! If you need more information, I will glady provide it!

Thanks!!

[ssanfu]

Is the dB Default Open Mode set to Exclusive or Shared?? It should be Shared.

[aussie92]

Yes, it is.

[ssanfu]

The only time I have seen where only one person at a time can be in the dB is when the open mode was set to exclusive. Even then, other people could browse (but not change) the dB.

Could be in your code.... would have to step through the code....(won't have use of A2K7 until tonight )

[aussie92]

Yea I have no idea... I am at my witts end here and my management team is pretty ticked off right now lol

Is there anything I can explain better or send over?

[katmomo5]

Where can I find Default Open Mode? I am having the same issue.

[katmomo5]

Do I set this on the back-end?