linked table on network

[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

 

[Valentín Playá]

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
***************************************************************************

 

[a a r o n . k e m p f]

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

 

[Tony Toews [MVP]]

linked tables don't work over a network.

Rubbish.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[a a r o n . k e m p f]

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

 

[willy k]

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

 

[Valentín Playá]

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
***************************************************

 

[willy k]

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