Sharing Access Databases

[SJH]

Hi all,

For a school project in a few weeks we're going to be required to create a database in Microsoft Access (unfortunately for me, as I am already competent with MySQL!).

While it may not matter in terms of scoring higher I would like to allow more than one person to be able to open and update the same database without causing sharing violations etc.

Is this at all possible?

Thanks

-Sam

[kleineme]

Hi,

yes it is You may host the mdb-file on a network drive from which it can be accessed by, hm..., more than one user. But don't expect it to be a high-end high-performance database. I don't know the exact limitations but it's a simple solution for smaller environments.

[SJH]

I tried this before but it still gives me a sharing violation Thanks for the help though

[kleineme]

Hi,

I'm using it here (O97/NT4) so it can be done Have you set the permissions for the folder/file to "Change"? What's the exact error message?

[wwb_99]

I have done it alot. All users need read/write/create/delete permissions to the folder, as they have to create the LDB file.

Other thing is to hide the little save object button, as it will lock others out when one users clicks on the little disk icon and saves changes to a form.

WWB