database can't be open 1

[doyle9732]

I am stumped.

I have numerous Access databases connected with cold fusion applications. But I have one that cannot be opened if the database is opened. The following error occurs:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.

I have compared the properties of this and another database (that is behaving properly) in both Access -> Tools -> options, access -> Tools -> Security, as well as the advanced properties in the Cold Fusion Administrator MX. They are identical (defaults).

Anyone know what I must do to have it be open?

thanks!
Stephanie

 

[jmgibson]

Something similar happened to me recently. The reason the DB became corrupted was due to a networking syncronization issue (created a cached copy on my destop when openend).

The fix that worked for me was as follows.

1) Delete the datasouce.
2) Rename the database.
3) Create a new database on the server using the original file name.
4) Import the tables from the old DB.
5) Recreate the datasouce.

Let me know if this doesn't work. I have a few other tricks that may work.

Good Luck.

 

[doyle9732]

it worked! thanks! You're a superstar!

Stephanie