link database (1 Viewer)

[dgoulston]

is it possible to link a table to my database from another computer which is on the network, i want to use the ip address of the other computer to access the database is this possible

 

[Emohawk]

I dont think it's possible to link a table via IP address (Guys/Girls, please correct me if I'm wrong.). It is easy enough to link to an existing table in another Database though. Just go and create a new Table and when the Dialog box appears to create the table in Desing View, Datasheet etc... Choose "Link Table" at the bottom and follow the prompts.

 

[dgoulston]

sorry i may have worded it wrong... i know it definetly is possible, as another programmer at the company i work for has done it before but he is not in for a couple of weeks

its jus does anyone know how....

DAL

 

[Pat Hartman]

I can't give you details because I haven't done it but:
1. Your network software must support peer-to-peer sharing.
2. The computer that holds the db with the tables must "share" the directory so that the network software can "see" it.
3. In the link dialog box, you need to type in the network address rather than choosing a mapped drive. Use the UNC format:

\\servername\directory path\db name

 

[dgoulston]

yay,,,

thankyou pat.

you are truely the master of access..

it works perfectly. and is much nicer than the other ways i thought of.

thanks agian & everyone else who tried to help....

DAL