linked table on network

  • Thread starter Thread starter willy k
  • Start date Start date
W

willy k

Hello Group: we networked two computers and linked an Access table. At first
it worked fine. Then the one database crashed (would not open). We copied the
other one over, then the linked table would not open. We reconstructed the
table but now it cant be edited from the other computer. Any help would be
appreciated.
Thanks
Willy
 
willy,

when you link an Access table from one mdb to another mdb the data are
local in one mdb and linked in the other. This means that you can not
shift the mdbs and nothing happens.

The crashed mdb is the one with local tables?. If this is the case
your data are lost but you may reconstruct a local table and the
linked tables will work without problems.

If this does not help you, please explain if you can see but not edit
the linked table or you can not see nor edit the linked table, and the
error message, if any, you get.

Regards,

Valentín Playá
Sonotronic S.A.
Madrid, Spain
***************************************************************************
 
linked tables don't work over a network.

Move (upsize) to SQL Server if you want multiple people to
(functionally) use your database at the same time.

-Aaron
 
dude smoke rubbish for breakfast with your eskimo butt buddy, old man

for all I care.

It's true.

MS Access isn't reliable enough for real world usage.

-Aaron
 
Valentin, Thank you for your response. I am new to this group and was not
able to find my post or any response until today.
I can see the table just cannot edit it.Thanks again

willy
 
willy,

you must have total control privileges for Access to the directory and
the mdb file with local tables. I dont know any other reason for not
being able to edit.

Regards,

Valentin
***************************************************
 
Valentin, Thank you very much. You were right , the permissions were not set
to allow network users to change files.
Thanks again
Willy
 
Back
Top