Wrote a system in the company LAN, Access database on the SERVER to the SERVER, the other work PC via software client, at this time only a segment of the company within the local area network (LAN) 192.168.1. *

Connect Adodc statements in the program is:

Inputdata. The ConnectionString=Provider=Microsoft. Jet. The OLEDB. 4.0; Data Source=\ \ Server \ Data management system \ registrationform MDB. Persist Security Info=False; The Jet OLEDB: Database Password=1

Now due to the actual need to increase the 192.168.2. * work PC in LAN segment, then. 2 PC can Access. 1 section of the Access database on the SERVER?

Adodc connection statement should be how to write? With the IP address?

CodePudding user response:

add picture

CodePudding user response:

As long as the network can ping should be able to access, but Suggestions for SQL server database

CodePudding user response:

Thank you moderator, I have not learned SQL server

Heard that access database data can be transplanted to SQL server database is?

So the VB program source code statement to drastically changes?