Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

open a web app while the database table is open ERROR

Posted on 2004-08-17
6
Medium Priority
?
140 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 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
Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

 
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

Turn your laptop into a mobile console!

The CV211 Laptop USB Console Adapter provides a direct Laptop-to-Computer connection for fast and easy remote desktop access with no software to install.

Question has a verified solution.

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

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

670 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