Connecting to a database in an another computer

[trex]

hi guys, i haven't tried networking in vb 6 before and i was wondering if its possible for me to put the database in one computer and have the vb application in other computers to access that database. And could you please give me a sample code on how I would be able to do this. The computers are connected via lan. The version of the database is Access 2002. Please help. Thanks in advance guys.

[dglienna]

for the database name, you can use the computer name, or it's internal IP address like this \\192.168.1.1\DB_Files\mydb.mdb or \\DavidServer\DB_Files\mydb.mdb

[trex]

for the database name? what do you mean? Is this the part where Im connecting to the database?

[trex]

Also, will this method allow multiple users? or do i have to something else to cater to such situations?

[dglienna]

It will work for multiple users. Access is only good for up to 5, realistically speaking, though.

[trex]

ummmm i know this is a stupid question but how do i know the internal ipaddress? im sorry but im not really good at this.