I need to connect with ADO to an Access database on a remote server without
setting up a DSN name.

This can be done with SQL Server where the connect string is:

"SERVER=MyServer;UID=;PWD=;DATABASE=myDatabase;DRIVER={SQL SERVER};DSN="

What should it be to do the same to a Access MDB file on the Remote machine?

Hope someone can help.

Gerrit

The only way I know is to open it directly, but you should have access to
the drive and folder where the database file is.

Dim db as Database
Set db = OpenDataBase("E:\dbname.mdb")

where E is the Drive to acces to the remote machine, I mean the drive that
the remote machine has shared.
But this isn't a remote connection.

You can use:
cn.open ("FileDSN=" & App.Path & "\my.dsn")

then ship a my.dsn with your app... the *.dsn file is just an INI file which
means you can edit it using GetPrivateProfileString, etc.

I do beleive however, you can specify a varstr as a connection without
having a User/Server DSN or DSN file;  I think its something like
"UID=;PWD=;DATABASE=mydb.mdb;DRIVER={Microsoft Access Driver (*.mdb)};DSN="
but you will have to check.

Steve

Thanks.