Hi, dear all:

I meet the wired problem on my dynamic web pages. I built them on dreamweaver MX 2004 using ASP and Access 2003, the database is on the university server, I directly test pages on the server.

Everything works fine before. But now, I can't view all the tables under the "Database" in "Application" panel. It shows "none", and for those pages (already built and work fine) to add information to database, click the "Insert record", the error message will pop up: The table was not found.
It asked me to check the DSN, I did, and the connection was successful ! (the first wired thing)

But I can't build any dynamic pages to access the database, and even can't modify old pages.

The other wired things are:
2) I still can view those dynamic pages (already built) online, and they work very well.
3) I still may add new information online, and they are input to the database on the server, even in dreamweaver MX 2004, their "insert record" show "no table"
4) I want to make a "recordset" under "Server Behaviors" in"Application" panel, if I do it in "simple" way, it shows error message "Unable to retrieve tables from this connection..", however, if I use the "Advanced" method, write the SQL : Select * From table_name, and test it, it works! Shows all information in that table.

I really don't know what is going on. Can anybody give me any suggestion? I really appreciate!
My email is: Thanks!
June

Dreamweaver MX 2004/ ASP/ Access

Hi June,
This may be the same as the problem I had after our IT guys has upgraded XP to Service Pack 2. I was unable to view tables etc and had nearly torn out all my hair trying to find out what was wrong but everything is OK now. Got a workaround fix by searching Macromedia (Adobe) support . The information is on this page:

www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19515

All the best,
Riggers