access forms in a multi user environment??

[DOGWATCH]

question.

I want to create a sales order database using access 2003 with access forms and reports on a shared network drive.

I've created many similar type applications before, however this application I intend to have up to 10 users accessing the database simultaneously.

I've found that I have run into previous issues with Acces forms where a user is updating a table and it exlusivly locks that table for editing.

I've also created some web applications which have used access and using ASP and ADO I have successfully implemented a multi-user environment.

My question is, is there some sort of option I can select where I can have it so it just maybe takes exclusive control over just the one record that is being edited and doesn't lock the entire table. I want to use the access forms as the front end for the user.

 

[danvlas]

Check the RecordLocks property of the form and select 'Edited Record' rather than 'All records'

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html