Re: [ACFUG Discuss] MS Access Issue

Teddy R Payne Fri, 22 Jun 2007 12:22:54 -0700

I have had no problems working with small clients that use Access as long asthe database is used as a data source with active connection turned on.

The database is not a data source in this case. The database is beingtreated as a file.

I suspect the user that is accessing this is ColdFusion, which would keepthe LDB files.


What aspects of the database do they need?  VB forms?  Data entry?

I typically do not support Access as a file, but as a data source.

If they just need the data, can you provide a database pool? Or perhapsremove out what they need into spreadsheets?


Teddy

----- Original Message -----
From: "Larry J. Morrow" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, June 22, 2007 2:27 PM
Subject: Re: [ACFUG Discuss] MS Access Issue

Hi Craig,

Check the settings in your DSN. Depending on the default behavior, thiscould be creating an exclusive lock and then nbot releasing the lock basedon a time out value or a restart of the CF server.

THis is one of the reasons why access is not a good choice for a back enddatabase to a web application. If you are on the Microsoft platform, MSSQL Svr express 2005 is a better choice and migration is fairly easy.


my $0.02

Larry

[EMAIL PROTECTED] wrote:

The problem appears to be that the record locking file (*.ldb) is beingleft when the user closes the database. When the file is first put outon the server (no ldb file exists) the file opens just fine (no message).But closing the file does not delete the ldb file as it should when thelast person who has the file opened closes the database. Because this ldbfile is still out there on subsequent attempts, it appears to MS Accessthat there is a user that still has the file open - the question now iswhy, when opening the database through CF does the ldb file not getdeleted once the database is closed.


Craig Nassal

Federal Reserve Bank of Atlanta
1000 Peachtree St. N.E.
Atlanta, Ga 30309-4470
(404)498-8437
[EMAIL PROTECTED]



"Dusty Hale" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]
06/22/07 10:16 AM
Please respond to
[email protected]


To
<[email protected]>
cc

Subject
RE: [ACFUG Discuss] MS Access Issue

Something tells me you should try some other way than cflocation to openit.

I tried it and it seems buggy where just a clickable link to it opens fine
with no message like the one you describe. This is just my instinct though
so I don't know if that is the real issue or not.

D

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, June 22, 2007 10:02 AM
To: [email protected]
Subject: Re: [ACFUG Discuss] MS Access Issue

We are giving the user access to the database on the file system - this
purpose of this app is to better organize all of the various files this
department uses - information pertaining to the file (name, subject matter

expert, etc) is displayed and there is a "launch" button to open the filein

it's native app (like ms access or excel).....

Craig Nassal

Federal Reserve Bank of Atlanta
1000 Peachtree St. N.E.
Atlanta, Ga 30309-4470
(404)498-8437
[EMAIL PROTECTED]



"Teddy R Payne" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]
06/22/07 09:37 AM
Please respond to
[email protected]


To
<[email protected]>
cc

Subject
Re: [ACFUG Discuss] MS Access Issue

What is your intent for the user to be able to do? Are you giving themaccess to the database on the file system or do you want them to justquery the database?


Teddy

----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, June 22, 2007 7:51 AM
Subject: [ACFUG Discuss] MS Access Issue

I have a CF App that is attempting to open an MS Access Database - when
Access is opening the file, the following message is produced: "You do

not

have exclusive access to the database at this time.  If you proceed to
make changes, you may not be able to save them later.".  I've verified
that there is no other users opening the file or working with the file

in

any way when this occurs.  It does appear that a record locking file is
created when the user opens the file through the app.  They are able to

go

directly to Access and open the file successfully without the message,

so

it appears that the issue is the way that I'm opening the file through

CF

- I'm just using a cflocation to open the file.  Has anyone experienced
this issue and know how to open the file without getting this message?

Thanks for in advance for the help.

Craig Nassal

Federal Reserve Bank of Atlanta
1000 Peachtree St. N.E.
Atlanta, Ga 30309-4470
(404)498-8437
[EMAIL PROTECTED]


-------------------------------------------------------------
Annual Sponsor FigLeaf Software - http://www.figleaf.com

To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=login.edituserform

For more info, see http://www.acfug.org/mailinglists
Archive @ http://www.mail-archive.com/discussion%40acfug.org/
List hosted by http://www.fusionlink.com
-------------------------------------------------------------



-------------------------------------------------------------
Annual Sponsor FigLeaf Software - http://www.figleaf.com