testing a database connection

Hi,
I want to make a connection to an ACCESS database in Dreamweaver. Everything
seems to work, but when I try to test it (putting some data in a table, etc) on
my local testing server, I've got some problems: the first time it works, but
when I change something in the recordset, it doesn't work. I get the following
message:
HTTP 500.100 Internal Server Error, and then something that says that he can't
use the database because the file is already used.
When I close and reopen dreamweaver, I can test the connection again.
(I make the connection with OLE DB).

Thanks!!

Hi

This is generally a permissions issue, see if this tech note helps.

http://www.macromedia.com/support/ultradev/ts/documents/80004005_win2k_error.htm


--
Cheers jojo
Team Macromedia Member Volunteer for Dreamweaver MX
http://www.webade.co.uk
----------------------------------------------------
Extending Knowledge, Daily.
http://www.communityMX.com/
Free 10 day trial
http://www.communitymx.com/joincmx.cfm
----------------------------------------------------

Read Jules article
(http://www.charon.co.uk/content.aspx?CategoryID=27&ArticleID=56) very helpful
about this problem using Access.

Originally posted by: interreg
Hi,
I want to make a connection to an ACCESS database in Dreamweaver. Everything
seems to work, but when I try to test it (putting some data in a table, etc) on
my local testing server, I've got some problems: the first time it works, but
when I change something in the recordset, it doesn't work. I get the following
message:
HTTP 500.100 Internal Server Error, and then something that says that he can't
use the database because the file is already used.
When I close and reopen dreamweaver, I can test the connection again.
(I make the connection with OLE DB).

Thanks!!