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
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
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 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
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
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
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
: [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
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
9 matches
Mail list logo