Solved

open a web app while the database table is open ERROR

Posted on 2004-08-17
6
138 Views
Last Modified: 2013-12-24
I am trying to go the site that a database supports while that database is open and the table is open. I have written an app where i could that before. However , this new app does not work, it generates this error

Error Executing Database Query.  
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The table 'projects' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically.  
 
The error occurred in C:\CFusionMX\wwwroot\prosvcs\internal2.cfm: line 63
Called from C:\CFusionMX\wwwroot\prosvcs\internal2.cfm: line 1
Called from C:\CFusionMX\wwwroot\prosvcs\internal2.cfm: line 63
Called from C:\CFusionMX\wwwroot\prosvcs\internal2.cfm: line 1
 
0
Comment
Question by:finnstone
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 5

Expert Comment

by:M256
ID: 11825103
Do you have an upgraded version of the database software?
Or, for that matter, ColdFusion?

Matthew
0
 
LVL 35

Expert Comment

by:mrichmon
ID: 11826311
ACCESS does not allow access via the web connection to a database file that is already open manually.

You need to use a different database to do what you are trying to do  since access does not allow this.
0
 
LVL 17

Accepted Solution

by:
anandkp earned 500 total points
ID: 11827608
I suppose if the table is opened in "Design" mode then - u'll get that error - else u shldnt.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 35

Expert Comment

by:mrichmon
ID: 11831691
If the database is open - even if the tables are not - you will get that error because Access doesn't allow web access to a database mdb file when it is open through windows
0
 
LVL 17

Expert Comment

by:anandkp
ID: 11849573
I've used Access with tables open [Not in Desing mode] & i never has issues with it.
0
 
LVL 35

Expert Comment

by:mrichmon
ID: 11852707
Then you are lucky because Micosoft even says that it is by design that it should not allow this.

I guess it depends on the DSN, but in general if you want to do something like this I would recommend moving to a real database system
0

Featured Post

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question