Board index » delphi » Access a database over a WAN?

2003-11-16 01:25:29 AM
delphi64
Using Delphi 7 pro I want to open an Access 97 database on a remote PC over
a WAN. I will only be able to identify the remote machine by it is IP address
or possibly a DNS name. Is this possible with ADO? If not which other
database tools would do the job?
Thanks for any advice,
Colin
 

I do that by mapping a drive to the remote machine. Maybe you can do the
same.
HTH, Glynn
"Colin" <XXXX@XXXXX.COM>writes

"Colin" <XXXX@XXXXX.COM>writes
would much
simpler to handle since MSDE works like MS SQL Server (in fact it is SQL
Server
just it has some limitations in connections you may establish)
 

I use this with a TADOConnection
const
machine='\\192.168.0.1\SharedDir\
Myconex.ConnectionString :=
...
...
'SourceDB='+machine+';'+
..
..
Maybe the same will work for you
Aldemar
"Colin" <XXXX@XXXXX.COM>escribi?en el mensaje