Himself a program with the Access database, the database is opened, if at this time many times to open the Excel table, although the database and table and has nothing to do but tend to cause problems database, there is in the database table data sorting chaos (even in this special table in ascending or descending order are useless), but with "compression or repair the database" back to normal after repair, Excel and Access will influence each other? I am using office2003,

CodePudding user response:

May be Office2003 by OLE, read and write Excel and Access, caused by the interference,
This should be the problem of Office2003,

CodePudding user response:

Office of memory, cache garbage
Really want to solve, to buy the sort of super thick Microsoft books to consult, should how to call API, and then clear memory method of garbage, and so on

CodePudding user response:

Good strange, if the customer says, the official reply, poisoning, system problems, reshipment

CodePudding user response:

Can only say that access database is not perfect, if memory, cache, this problem is likely to affect each other