Jason, It is because Access still has a ldb file hanging around and it only gets deleted after your program terminates. The way I have got around it previously, as one of my apps requires the zipping up an access db and emailing it, was to:
1. Close the connection and make connected = false 2. Copy the Access mdb file to a temp directory. 3. Zip it from the temp directory, then delete the Access mdb file from the temp directory. 4. Make connected = True It works with no problem. Mike -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Fischer Sent: Monday, 9 May 2005 6:52 PM To: [email protected] Subject: [delphi-en] ADO Connection and Access - Close totally Hello, How do I close a connection to an Access Database so that I can zip up the mdb file. I am using an ADO Connection and I close the connection, but when I try to "zip" up the mdb file I get an error from the TCabFile component that I am using that the file cannot be opened. If the application is not running, then it is easy to "zip" the mdb file. SO my question is, how do I close the connection totally, so that I can compress the file? Thanks ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
