Linked table problem

[J]

I am linking to 2 tables in someone else’s database on the network (just for
the purpose of viewing some data) but when he opens his database, I can’t
access the tables. Is it because he’s opening the database in exclusive mode
or what’s the deal?

 

[Joan Wild]

I am linking to 2 tables in someone else's database on the network
(just for the purpose of viewing some data) but when he opens his
database, I can't access the tables. Is it because he's opening the
database in exclusive mode or what's the deal?

That would do it, but is he opening in exclusive mode? It may be that users
don't have full permissions on the folder where the mdb is.

 

[J]

That would do it, but is he opening in exclusive mode? It may be that users
don't have full permissions on the folder where the mdb is.

--
Joan Wild
Microsoft Access MVP

I'm not positive. I'll need to confirm next time this happens but his database is not split into FE,BE so does that "automatically" lock me out when he has it open?

 

[Joan Wild]

Not necessarily. It could be that the database is set to open exclusively.
Check in Tools, Options, Advanced tab for the default open mode.

The database really should be split if more than one user is going to use
it. You run an increased risk of corruption, for one thing.