access database on network
-
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???
You could use an ODBC data source, or you can use \\server_name\database_name.mdb Free your mind...
-
You could use an ODBC data source, or you can use \\server_name\database_name.mdb Free your mind...
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?