Thanks Mike, I get it all up and running. Thanks for everyones help :)
--- In [email protected], "Mike Lucek" <[EMAIL PROTECTED]> wrote: > 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:delphi- [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/
