Multi user

[weeze2]

Hi there. I need serious help
I put an Access database out and there is about 20 to 30 users that is going to access the db during the day. My problem is more than one user at a time. More than one can open the db at the sam etime, but they cant run queries if another person opene dthe db before.
Is there something serios one has to take into consideration when having multiple users..that I may have overseen. I am new to shared databases
I hope someone can help!

 

[weeze2]

oh and I forgot to say that its MS Access 97.

 

[jebry]

Hi!

Go into Tools/Options and on the Advanced tab make sure the default open method is Shared.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[weeze2]

well it is on shared..Is it maybe because I saved it as a MDE file?

 

[grnzbra]

Are you familiar with unbound forms? Things are only tied up for the time needed to read a record and fill in the text boxes on the form. Then the recordset is dropped. After any changes are made and a commit button is clicked, the recordset is opened, the changes are made and it is closed again.