I can send you some code to play with if you are not to sure how to do the copy.
Mike -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Fischer Sent: Monday, 9 May 2005 10:41 PM To: [email protected] Subject: [delphi-en] Re: ADO Connection and Access - Close totally That sounds good, but how do I then restore the Access file again? I want to do it from the program, how will I get around this? Or is it not a problem. Thanks --- In [email protected], "Mike Lucek" <[EMAIL PROTECTED]> wrote: > 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 ----------------------------------------------------- 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/
