Dreamweaver CS3 : Training From The Source

[Mr_Pedantic]

I am currently working through this book (using ASP) and am struggling on Chapter 7.

When connecting to the database, if I choose "Using DSN on testing server" (as instructed by the book), I get the message "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."

If I choose "Using local DSN", the connection is made.

However, when I update the index page to enter the traveler's journal, the live data will not work and I get the following error message:

Can anybody help me, please?

[Lawrence_Cramer]

Are you using an Access database?  If so check to be sure that it is not open in MS Access or that it is not locked.  Windows will lock the file when you have it opened in Access, and even after closing Access, it will sometime neglect to unlock it.  sometimes you even have to reboot your system to get Windows to let go of it... VERY frustrating during development. (One more reason to move to a true DBS like MySQL or SQL Server (Express for local dev and testing)

Hope this helps.

--
Lawrence Carmer - *Adobe Community Professional*
http://www.Cartweaver.com
Complete Shopping Cart Application for
Dreamweaver, available in ASP, PHP and ColdFusion

Stay updated - http://blog.cartweaver.com

[Mr_Pedantic]

Hello Lawrence,

Thanks for the reply.

I am using Access. I have re-booted several times to no avail. I tried changing permissions in Access, but made the situation worse in that neither of the options then produced the desired result.I have managed to get back to where I started by re-installing the.mdb file from the cd.

I will have to look at permissions further when I have time. I think you may have started me off on the right track though. Thank you!

Regards

David

[Mr_Pedantic]

I appear to have got this working, although the instructions in the book about connecting to a DSN on the testing server appear to have been wrong? I got it to work by "Using local DSN".

The major point was that I needed to allow the user created by IIS (IUSR) to have full access to the database file and the directory it was in.

Lawrence provided valuable information about the locking of files by Access. It seems that every time that I used Dreamweaver to try to connect to the database, a "locking file" was added into the directory. This could be removed by opening and closing the database in Access.

[Mr_Pedantic]

The final piece of the jigsaw was that I needed to put a copy of the.mdb file into the folder inetpub/wwwroot/newland/database. The option "Using DSN on testing server" then worked. This was not specifically stated in the book and I had to work it out for myself.