Database Error

[Shiv Kumar G.M.]

I have a EXE file, which repairs the Access 2000 database by removing the space used by the deleted records.

This EXE works fine. But I need to call this EXE from one more MDI. The user will enter to the MDI after logging, where I need to open the databse and check the table for user name and password. If he is successfuly, then he is allowed to work inside. In the menu of the MDI I am trying to call that EXE file. The EXE file executes properly but the database size is not reduced, if I call it from within MDI. But the same works if I run that EXE separately.


I am using ADO. In the design time, I right click and set all the properties to access the database Access 2000 and one text box is bound to this.


Regards,
Shivakumar G.M.

[Cakkie]

How are you calling the EXE? Is it using COM or just using the Shell statement?

Tom Cannaerts
[email protected]

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook

[Shiv Kumar G.M.]

It's using only shell statement

[Cakkie]

Strange, when using Shell, It runs like if you start it manually. One possible cause I can think of is that the database might be in use by the program that is shelling the EXE. When starting it manually, that program probably isn't started.

Tom Cannaerts
[email protected]

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook