Linked table problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
J said:
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?
Click to expand...

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 said:
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?
Click to expand...
 
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.
 
Back
Top