Solved

open a web app while the database table is open ERROR

Posted on 2004-08-17
6
134 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 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Citrix netscaler connection to Web Interface 9 110
WSUS Client Issues 52 1,298
Problem to Eclipse 16 118
Websocket through haproxy reused connection causes "Not a valid frame" error. 4 73
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 …
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

895 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now