finnstone
asked on
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\prosv cs\interna l2.cfm: line 63
Called from C:\CFusionMX\wwwroot\prosv cs\interna l2.cfm: line 1
Called from C:\CFusionMX\wwwroot\prosv cs\interna l2.cfm: line 63
Called from C:\CFusionMX\wwwroot\prosv cs\interna l2.cfm: line 1
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\prosv
Called from C:\CFusionMX\wwwroot\prosv
Called from C:\CFusionMX\wwwroot\prosv
Called from C:\CFusionMX\wwwroot\prosv
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.
You need to use a different database to do what you are trying to do since access does not allow this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
I've used Access with tables open [Not in Desing mode] & i never has issues with it.
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
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
Or, for that matter, ColdFusion?
Matthew