hi, im creating a new website busing dw8 but hit a snag, the site is basic asp linked to a access db, when i try to preview the site i get this error

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
/photo gallery/index.asp, line 8

and line 8 refers to the database connection

Set rsPhotos = Server.CreateObject("ADODB.Recordset")
rsPhotos.ActiveConnection = MM_conGallery_STRING
rsPhotos.Source = "SELECT * FROM Images"
rsPhotos.CursorType = 0
rsPhotos.CursorLocation = 2
rsPhotos.LockType = 1
rsPhotos.Open()

i thought it was a permissions problem but my db and all files have the correct permissions set. The only difference between this site and others ive done is this is my first using dw8, i used dw mx in the past.

could this be the problem, when i have created my connection to the database i have noticed that another file has been created with the same name as my database but with the extension ldb and there is a small padlock attached to the db icon? can i get rid of this?

the ldb file is the Access lockfile. If you are sure no one is accessing the DB it can be deleted safely.

It should be deleted automatically after the asp connection closes but sometimes an aborted update/delete query can leave the file there and the DB locked.

cheers Chris but ive since learn t that my iss is corrupted somehow so ive decided to install apache and learn php from scratch rather than letting dreamweaver produce the code, thanks again

Um, why not continue on with asp instead of letting dreamweaver write your code?

Also, to answer the original question, we need the one piece of information that's not provided, the value of MM_conGallery_STRING.

Close the Images table inside of Access (I'm presuming you're using Access). I see that error all the time on my localhost, and it's always because I have the table open in either design/datasheet view that's being referenced.

i didnt have access open at all and the only other program running was dreamweaver so i dont know why it says another program is using the database.

Probably Dreamweaver was connected to it, in order to provide whichever features it has relating to databases.