Using a database on more than one computer

[jackijackijacki]

I am having trouble opening databases on more than one computer, using the
Access 2007 program. I have tried doing this with my own database, as well
as the Sample Northwind database. Both these databases are on a network and
both are set (in Access Options) to open in a shared rather than exclusive
way.

Can anyone suggest why this might be happening and especially how to resolve
this problem?

Thanks!

 

[John W. Vinson]

I am having trouble opening databases on more than one computer, using the
Access 2007 program. I have tried doing this with my own database, as well
as the Sample Northwind database. Both these databases are on a network and
both are set (in Access Options) to open in a shared rather than exclusive
way.

Can anyone suggest why this might be happening and especially how to resolve
this problem?

Thanks!

"Trouble" is a bit ambiguous. What problems are you having?

Do note that a shared database should certainly be split. The tables should be
in a shared backend - either a .mdb, .accdb, or SQL/Server instance - and each
user should have their own copy of the frontend.