Connect to DAO database on network

[rdcody]

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

[Hack]

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

[rdcody]

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