access database on network

[R Sharma]

hi i am new in the database projects across network, now for eg if there are 10 client machines and a server and we have our access database on the server how can we connect the client to the databse ie the path would be???

[Guillermo Rivero]

You could use an ODBC data source, or you can use \\server_name\database_name.mdb Free your mind...

[loid grey manuel]

hi, i have the same problem with my project. i have an existing system which is a stand alone app. using ms access version 95, created in VB6.0... well because it's a bit old system. but is runs quit very well. the system owners decided to make the app. run over the network, they have a total of 10 workstations on their office, all are running win 7 OS. 1 is for the primary admin and 4 is for staff. 5 are for users. the database is located at workstation 1, the other computers wants to access the database. here is a sample code given to me: Option Explicit Dim Conn As New ADODB.Connection Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\IP\DIR\Data\masterFile.mdb" as the patch but i get an erro "User-Define not defined" on "Dim Conn As New ADODB.Connection" am i missing something like an add-on or reference maybe, like in C# we used to add the reference for SQL connection. do i need to install something?