?
Solved

open a web app while the database table is open ERROR

Posted on 2004-08-17
6
Medium Priority
?
144 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
  • 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 2000 total points
ID: 11827608
I suppose if the table is opened in "Design" mode then - u'll get that error - else u shldnt.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

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

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…
When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses

593 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