Incorrect connection to acces

Report · Jan 22, 2012

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

Report · Jan 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?

Report · Jan 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

Report · Jan 23, 2012

The reason for using Access is, that I have used it for years from version 2000. I have used ODBC-connections until version 2003. But with version 2007 I could not create ODCB connections on my Windows 2003 server. (looks like it does not support accdb format)

I have read that OLEDB connections are faster than ODBC connection, and they are easier to make, cause I don't have to go to my server, which stands in another building. ( I also have som small web-application running on yet another server, which is not my own)

Now I am using Office 2010, so I had a need to shift the way I connect to Access-database. I know a little of ASP and VBscript, but not so much, that I can program from scratch - thats why I use dreamweaver.

I have been looking a little on MySQL. But then I have to use php, as far as I understand.

I can se - after posting this message, that others with the same subject appears at th ewindow to the rigth. And no one with a usable solution. So I think there is no why to use Access after 2003 with Dreamveaver.

tnx for your response.

Report · Jan 23, 2012

You can still get a copy of MS office professional 2003 for not a lot at many software houses. Add that to Dreamweaver CS3 or even CS4 and you can still use access as a database.

Learning PHP from scratch is not something that is at all easy, as I have found out recently, and it seems that the in built systems in CS5.5 are quote "Great for doing a quick mockup of a database driven website for a simple site" at which point the author dropped Dreamweaver and continued with the Zend Framework. This makes CS5.5 look like it has a flat learning curve!

I don't agree entirely, but then I don't write really complex websites. Access can be used for many database driven sites, but MySQL is free and more capable, with which I would not argue.

I would argue that you can used access and CS3 to write good sites. Access and ASP is now past its sell by date, and Dreamweaver does not support either in the way that it used to do.

I would have thought that someone would have come up with a way to use asp and MySQL. I find MySQL is a lot easier to learn than PHP, coming from a database background.

My first project was a stock control database written in Applesoft in 1978 - followed by a Debt recovery system using Omnis 3 on an IBM compat.

Access, PHP and MySQL are simple in comparison.

The best system is one that you know!