Its an ADO thing. Closing the TADOConnection doesn't actually close it until the application terminates unless the OLE DB Services = -2 is added to the connection string. It's worked for me on other databases where I was having similar problems to you.
Peter Gore Project Manager IT (ddi) 01277 376433 (swb) 01277 372916 (mob) 07952 695755 ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Fischer Sent: 09 May 2005 12:39 To: [email protected] Subject: [delphi-en] Re: ADO Connection and Access - Close totally Hi Peter, No Change. The same thing is still happening. What is the "OLE DB Services = -2" used for? Sorry, never really used Access before. Thanks --- In [email protected], "Peter Gore" <[EMAIL PROTECTED]> wrote: > > Try this > > > > Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;Persist Security > Info=False;OLE DB Services = -2; > > > > Peter Gore > > Project Manager IT > > (ddi) 01277 376433 > > (swb) 01277 372916 > > (mob) 07952 695755 > > ________________________________ > > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of Jason Fischer > Sent: 09 May 2005 10:41 > To: [email protected] > Subject: [delphi-en] Re: ADO Connection and Access - Close totally > > > > Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;Persist Security > Info=False > > Replace the %s with my DB path and file name. > > > --- In [email protected], "Peter Gore" <[EMAIL PROTECTED]> wrote: > > > > What connection string are you using? > > > > > > > > Peter Gore > > > > Project Manager IT > > > > (ddi) 01277 376433 > > > > (swb) 01277 372916 > > > > (mob) 07952 695755 > > > > ________________________________ > > > > From: [email protected] [mailto:delphi- [EMAIL PROTECTED] > On > > Behalf Of Jason Fischer > > Sent: 09 May 2005 09:52 > > 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 > > > > * 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] > > <mailto:[EMAIL PROTECTED] subject=Unsubscribe> > > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > > Service <http://docs.yahoo.com/info/terms/> . > > > > > > > > > _____________________________________________________________________ > _____ > > TM Retail, Ashwells Road, Brentwood, Essex CM15 9ST > > > > This e-mail including any attachments is intended only for the > addressee > > named above and it may contain confidential or privileged > information. > > If you are not the intended recipient please notify the sender and > note > > that the contents must not be disclosed to anyone else, no copies > can be > > taken and all existing copies must be destroyed. > > TM Retail will not be liable for any error in transmission. > > You should carry out your own virus checks before opening any > attachments. > > Opinions, conclusions and other information in this message > > and attachments that do not relate to the official business > > of TM Retail are neither given nor endorsed by it. > > TM Retail is the trading name of Forbuoys Limited. > > > > [Non-text portions of this message have been removed] > > > > > ----------------------------------------------------- > 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] > <mailto:[EMAIL PROTECTED]> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/> . > > > > _____________________________________________________________________ _____ > TM Retail, Ashwells Road, Brentwood, Essex CM15 9ST > > This e-mail including any attachments is intended only for the addressee > named above and it may contain confidential or privileged information. > If you are not the intended recipient please notify the sender and note > that the contents must not be disclosed to anyone else, no copies can be > taken and all existing copies must be destroyed. > TM Retail will not be liable for any error in transmission. > You should carry out your own virus checks before opening any attachments. > Opinions, conclusions and other information in this message > and attachments that do not relate to the official business > of TM Retail are neither given nor endorsed by it. > TM Retail is the trading name of Forbuoys Limited. > > [Non-text portions of this message have been removed] ----------------------------------------------------- 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] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . __________________________________________________________________________ TM Retail, Ashwells Road, Brentwood, Essex CM15 9ST This e-mail including any attachments is intended only for the addressee named above and it may contain confidential or privileged information. If you are not the intended recipient please notify the sender and note that the contents must not be disclosed to anyone else, no copies can be taken and all existing copies must be destroyed. TM Retail will not be liable for any error in transmission. You should carry out your own virus checks before opening any attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TM Retail are neither given nor endorsed by it. TM Retail is the trading name of Forbuoys Limited. [Non-text portions of this message have been removed] ----------------------------------------------------- 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/
