• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 144
  • Last Modified:

open a web app while the database table is open ERROR

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
finnstone
Asked:
finnstone
  • 3
  • 2
1 Solution
 
M256Commented:
Do you have an upgraded version of the database software?
Or, for that matter, ColdFusion?

Matthew
0
 
mrichmonCommented:
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
 
anandkpCommented:
I suppose if the table is opened in "Design" mode then - u'll get that error - else u shldnt.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
mrichmonCommented:
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
 
anandkpCommented:
I've used Access with tables open [Not in Desing mode] & i never has issues with it.
0
 
mrichmonCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now