Monitoring program (Delphi) requires real-time operation and write access database,
I read the program (c #) need real-time read access file and screening of useful information,
(all use the same user open) :
1, monitor, and reader can run independently (read/write access)
2, read the program can and access2010 open the database at the same time,
3, the surveillance program is running, reader and access2010 all can not open the database, tip "unable to lock file"
4, reader or access2010 opened the access database, monitoring program can run, but wrong in the writing database times: "operation must use an updateable query",
Saw some questions and answers, why should it be used to monitor the exclusive way to open the database to other program to open it, but people write monitor told me that he had run on another machine monitor again after reading (Delphi writing),
Meng, and don't change the program of others, no monitoring program source code, and I don't know what he said on another machine is what circumstance, please help solve the problem,
CodePudding user response:
Please answer
CodePudding user response:
Can't change monitoring program, there are two methods:Copy of 1, query time to create, to query the data;
2, closed immediately after the query link is disconnected, let the monitor data can be written, the premise is that does not affect the monitor data;