I have set up a connection from dreamweaver MX to a microsoft access XP database using ASP Javascript. When I click the test button everything is okay, however when I then go to the database panel and click on my connection the tables are not visible. Please help this is driving me insane.

regards
Dovey

Did you create a recordset?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I have set up a connection from dreamweaver MX to a microsoft access XP database using ASP Javascript. When I click the test button everything is okay, however when I then go to the database panel and click on my connection the tables are not visible. Please help this is driving me insane.

regards
Dovey
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

"If it weren't for the last minute, nothing would get done."

Hi,

I tried to create a recordset, however as there are no tables for it to connect to it wouldn't let me. It kept giving kme a message saying it can't find any tables in the database for me to use as a recordset.

I don't know what to think, have you uploaded the database again to make sure it isn't corrupted?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi,

I tried to create a recordset, however as there are no tables for it to connect to it wouldn't let me. It kept giving kme a message saying it can't find any tables in the database for me to use as a recordset.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

"If it weren't for the last minute, nothing would get done."

More times than I can remeber, I've created new datdabases and tried it with them as well. I have noticed a .ldb file being created in the same directory as my database when I am working in Dreamweaver, this appears to be some kind of permissions controlling file but I can't figure out what it is doing and it disappears when I close dreamweaver.

Hi dovey,

Just a thought - open the db and save it somewhere else with a totally differnt name. Set up the new connection and test.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote> More times than I can remeber, I've created new datdabases and tried it with them as well. I have noticed a .ldb file being created in the same directory as my database when I am working in Dreamweaver, this appears to be some kind of permissions controlling file but I can't figure out what it is doing and it disappears when I close dreamweaver.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
LDB is an Access lock file which can be opened with workbench.exe, should be in the progams directory.

Digga

Sharing Knowledge Saves Valuable Time!!!