How do I set up users without their having admin priveleges ?

[Bito0124]

I support a multiuser C# application that allows each user to save and retrieve data to a MS Access 2007 database.

I have lock problems because each user is "seen" as admin
in the database and admin privileges enforce full locks (as I understand it).

Is there a simple way to default all users to something other than admin ?

Thanks for any assistance.

[zmbd]

V2007 did away with the user level security.

Record locking is dependent upon how you are establishing the connection to the database and how the record-sets are being created.

[Bito0124]

Thanks for your reply.

I apologize, I should have written "I support a multiuser Visual Basic 5 application ..."

I have MS DAO 3.6 set as a reference and use following VB command to open the database

Set mDB = OpenDatabase(myDatabase, False, False)

I'm no expert in use of Access database and am looking for a simple way to make the DefaultUser setting be something other than admin.

Is there a way to programmatically set DefaultUser in my VB code ?

[zmbd]

I've moved your thread to the VB forum as they may have better answers for you.
I know in MS Access 2003 and below, you had to develop a new workspace and set users there-in... not sure what you would do from a VB aspect to achieve this same structure. I do know however, no matter what you do, once a user opens your database using v2007 or newer, the user level security WILL be stripped upon conversion... and there's nothing you can do to stop it once the user can open the database.