Connecting to a database in an another computer
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.
Re: Connecting to a database in an another computer
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
Re: Connecting to a database in an another computer
for the database name? what do you mean? Is this the part where Im connecting to the database?
Re: Connecting to a database in an another computer
Also, will this method allow multiple users? or do i have to something else to cater to such situations?
Re: Connecting to a database in an another computer
It will work for multiple users. Access is only good for up to 5, realistically speaking, though.
Re: Connecting to a database in an another computer
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.