Re: Those darn Access .ldb files

2001-03-07 Thread Jeffry Houser
I'm confused. Are you trying to unlock the database inside a 'functional' page that users will see? I've only had to do this when I am copying over the database. Using method two, I would run it without the try/catch tags. If the page throws an error, who cares. It's a page for my o

Re: Those darn Access .ldb files

2001-03-07 Thread Jay Patton
This has worked well for me when ive had that problem: Unlock Database! Select * >From YourTable Where lock="whatever you want it to" I just refresh the page a few times and it unlocks the DB. Hope this is helpfull. Jay Patton Web Design / Application Design Web Pro USA 406.549.3337

Re: Those darn Access .ldb files

2001-03-07 Thread Douglas Knudsen
Got Linux? http://linuxmall.com From: [EMAIL PROTECTED] AT INTERNET on 03/07/2001 02:43 PM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: Re: Those darn Access .ldb files I'm confused. Are you trying to unlock the database inside a 'functio

RE: Those darn Access .ldb files

2001-03-07 Thread Christian L. Watt
re or anything else. Just recopy and off you go. Hope this helps... cw -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 07, 2001 12:20 PM To: CF-Talk Subject: Re: Those darn Access .ldb files ooops! The intent: I have a page that an end user ca

Re: Those darn Access .ldb files

2001-03-07 Thread Larry C. Lyons
Douglas, A simple way of avoiding Access .ldb files would be to create a blank database. Then link it to the real database using File -->Get External Data-->Link Tables. Select the appropriate database and tables. Then whenever you need to swap out the database its just a matter of copying the fi

Re: Those darn Access .ldb files

2001-03-08 Thread Douglas Knudsen
pt at night to copy over the actual one. From: [EMAIL PROTECTED] AT INTERNET on 03/07/2001 04:00 PM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: Re: Those darn Access .ldb files Douglas, A simple way of avoiding Access .ldb files would

RE: Those darn Access .ldb files

2001-03-08 Thread Dylan Bromby
to get rid of locks on access or excel DSNs in CF4.5, use: where {DSN} is your DSN. then to re-enable: -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 8:31 AM To: CF-Talk Subject: Re: Those darn Access .ldb files This was a

Re: Those darn Access .ldb files

2001-03-08 Thread Larry C. Lyons
: [EMAIL PROTECTED] AT INTERNET on 03/07/2001 04:00 PM > > To: [EMAIL PROTECTED] AT INTERNET@CCMAIL > cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) > > Subject: Re: Those darn Access .ldb files > > Douglas, ~~ Structure your

Re: Those darn Access .ldb files (forgot to add)

2001-03-07 Thread Jay Patton
sorry i forgot to add, that code i sent you is from a page that i use called unlock.cfm and i just run that page when the db gets locked. Jay Patton Web Design / Application Design Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com - Original Message - From: <[EMAIL PROTEC