Connect to DAO database on network

Hi,

I have an Access database (mydatabase.mdb), and a program
(data.exe) I wrote to manipulate (add, edit, delete records) in it.
It works great on one computer.

I want to use it on a network of 10 computers. I want to place
the database on 1 computer, and have my program (data.exe)
on the other 9 computers.

Here's my question...

Currently I use the following to connect to the database:

Set db = OpenDatabase(App.Path + "\" + "mydatabase.mdb")


How would I do it on a network? Somewhere in this forum, I read
all I have to do is the following:

Set db = OpenDatabase("\\RemoteComputerName\c\myfolder\mydatabase.mdb")


Is that all I have to do? Or, do I need to use the Winsock control?


Thanks in advance,
Ron

You don't need a WinSock control. Just the fully qualified remote path.

Hey Hack,

So, just to clarify...

If the computer that had the database on it, was named
"BillyBob", and the path to the actual database file is
"C:\myfolder\mydatabase.mdb".......then all I need to put is...

Set db = OpenDatabase("\\BillyBob\c\myfolder\mydatabase.mdb")


...and I will be connected to the db on that computer. Correct?


Thanks,
Ron