I try to build a dynamic web page in ASP using Dreamweaver CS6 in a Windows7 X64 environment. I have an .accdb database, created with Microsoft Office Access 2010 X64, and this Custom Connection String:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("/data/myblog.accdb")
The above connection string gives me a "Connection was made successfully" message when I use the Test button.
But when I want to create a Recordset (Query) and choose my connection, I noticed that all my table names in the "Table:" field get a null. prefix.
For example, a table called "mUsers" becomes "null.mUsers" and so on. Is there any idea why is this happening?what's the current method to deal with this
Thanks in advance.
[Moved from non-technical Forum Lounge to Dreamweaver forum... Mod]
[Here is the list of all Adobe forums... https://forums.adobe.com/welcome]
Can I ask why you're using Classic ASP with Access database? ASP hasn't been actively developed since 2008. Microsoft replaced Classic ASP with ASP.NET. And Access databases are a poor choice for web applications. MSSql is a better fit.