How do you share a database in Access 97?

[deedees]

Every time another user on another computer accesses this database, it comes up read only if it is already open on another computer. How do you share this database between multiple users?

 

[RonRegan]

Okay, first: have you created two separate databases, one with the programs, forms, reports, etc and one for just the data? <br><br>In design mode, click on tools, options. Click the advanced tab. Select &quot;shared&quot; for mode.<br><br>hth<br><br>

 

[deedees]

We have two separate databases-forms & data. We have chosen the 'shared' mode. It will still only let one user access the database at a time. The others still come up in read-only. Any other suggestions?

 

[deedees]

Could this problem have anything to do with our network? We have tried test databases and no sharing allowed.

 

[deedees]

We installed Access on one of our servers and uninstalled/installed on the PCs in question. It worked fine. We were unable to share the database that existed soley on a PC, but are able to share a database from an NT server.