Getting a null. prefix in my table names

Report · Dec 02, 2007

I try to build a dynamic web page in ASP using Dreamweaver CS3 in a Windows XP SP2 Pro x63 environment. I have an .accdb database, created with Microsoft Office Access 2007, and this Custom Connection String:

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("/blog/database/blog.accdb")

The above connection string gives me a "Connection was made successfully" message when I use the Test button. But when I go to create a Recordset (Query) and I choose my connection, I notice that all my table names in the "Table:" field get a null. prefix. For example, a table called "tblUsers" becomes "null.tblUsers" and so on. Is there any idea why is this happening? Thanks in advance.

Report · Dec 02, 2007

"uemeulo" <webforumsuser@macromedia.com> wrote in message
news:fiu9k0$283$1@forums.macromedia.com...
> I try to build a dynamic web page in ASP using Dreamweaver CS3 in a
> Windows XP
> SP2 Pro x63 environment. I have an .accdb database, created with Microsoft
> Office Access 2007, and this Custom Connection String:
>
> "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" &
> Server.MapPath("/blog/database/blog.accdb")
>
> The above connection string gives me a "Connection was made successfully"
> message when I use the Test button. But when I go to create a Recordset
> (Query)
> and I choose my connection, I notice that all my table names in the
> "Table:"
> field get a null. prefix. For example, a table called "tblUsers" becomes
> "null.tblUsers" and so on. Is there any idea why is this happening? Thanks
> in
> advance.

The prefix usually denotes the object owner, or "schema"

Dreamweaver has provisions for limiting the displayed tables:

Restrict database information displayed in Dreamweaver
http://livedocs.adobe.com/en_US/Dreamweaver/9.0/WSc78c5058ca073340dcda9110b1f693f21-79b9.html

but

Set or change Access 2003 user-level security in Access 2007
http://office.microsoft.com/en-us/access/HA101662271033.aspx

mentions the following:

The information in this article applies only to a database created in Access
2003 or earlier versions (an .mdb file). User-level security is not
available for databases created in Office Access 2007 (.accdb files). Also,
if you convert your .mdb file to the new format (an .accdb file), Office
Access 2007 discards your user-level security settings

So I'm guessing you get the null prefix because owners are not supported in
.accdb format, but dreamweaver still tries to display the schema.

If you restrict database information to a specific schema name, Dreamweaver
should not prepend the schema name in the Tables panel.