I need to create a DB that will keep users from accessing the same file. Essentially locking other out when one user is accessing the file.

Is there a way for access to do this? Any help is appreciated.

Thanks, Max

is this about mdb/mde file locking or general file locking?

access itself does not lock files, except it's own when compacting....

but you could create function that does it for you and put it in access....

if your "file" is an access table that you are feeding to a form, your form has
Properties ¦ Data ¦ Record Locks = All Records or No Locks or Edited Record

if you choose All Records, second and subsequent users of the form can see data but not edit (and get a beep & status msg if they try).

if your "file" is not an access table - what is it?

izy

No idea. This is all in the beginning planning stages.

What I'm suppose to make is a document management type program. But have no idea.

Does anyone know of any code to help me get started.

Thanks for the help

It's regarding general file locking. I need the users to view files (like in explore), the admin will need to assign a folder/file to a user to work on. That folder will now be locked so no one else can open it and make revisions to it, or undo the others work.

I hope this makes sense. Your help is appreciated

This sounds like something you would need to use API for.
Try going to allapi.net They give a pretty decent explanation
for each API call, and good examples of how to use it in VB.