|
I am developing a simple programe in vb6 with ms access database, currently this programe run in a computer , now we go to work this programe in 4 computer , how can i share the access data base ... now i am using following codes
Public CnCargo As ADODB.Connection
CnCargo.Open "Provider =Microsoft.ACE.OLEDB.12.0;Data Source=F:\Invoice\Invoice.accdb;"
**** if the database path is working based on ip address it is very good ....
**** how can we configure INI file database path
please advice , if know
regards
mano
|
|
|
|
|
If I understand it correctly, you want to place the access MDB on one computer, make sure that folder where the MDB exists is shared, then you configure the connection string to reference the MDB something like "...Data Source=\\yourServerComputer\YourShareName\Invoice.accdb"
|
|
|
|
|
yes u correctly understood , but we are not maintaing server computer , and then it is not mdb file it is accdb file
please help
|
|
|
|