Skip to main content
J
Johnny Odgaard
Participant
January 22, 2012
Question

Incorrect connection to acces

  • January 22, 2012
  • 4 replies
  • 794 views

I have made a connect to an access database with this connection string "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\data\lager.accdb"

The connection is established, but viewing the tables I got "null." in front of all tablenames and queries like this image show.

The means, that I got an error in the webpage. I can remove the letters null. when in the codeview, but then I can't use the application window above.

Anybody any ideas?

Johnny Odgaard

This topic is closed to new replies. Start a new post to keep the conversation going.

4 replies

B
bregent
Participating Frequently
January 22, 2012

I'm not sure how well MS Access 2007 is supported in DW, if at all. You might have to code by hand. Try using ODBC rather than OLEDB.

Is there a reason you need to use Access, rather than a more suitable DBMS?

W
whatalotofrubbish
Inspiring
January 23, 2012

It also depends if you are using a 64 bit machiner. There are no 64 bit drivers for Access.

If this is the case, the following link may help:

http://http://archives.postgresql.org/pgsql-odbc/2005-09/msg00125.php

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices