Thanks Peter, I'll play a bit more and see if I can sort it out. Thanks for the advice :)
--- In [email protected], "Peter Gore" <[EMAIL PROTECTED]> wrote: > > 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:delphi- [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] 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] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
