1 Reply Latest reply on Oct 25, 2016 9:29 AM by Nancy OShea

    I noticed that all my database table names in the "Table:" field get a null. prefix.how to deal it?

    wangs48219683

      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

      issue?

      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]