OLE DB Database Connection

[jamesbrightley]

Ok,

My first ever post on webmasterworld!

Right I have started dabling in the world of web design with the help of Dreamweaver. I messed around with php for a bit and now decided to learn/create asp.net

I thought I would try and try setup a site so users can register/login etc with the use an Access '07 Database. I did a bit of research and decided to use a OLE DB connection. I managed to conenct to the database with the following Conection string:

Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=D:\MySite\users.accdb;
Persist Security Info=False

The connection appears to work and Dreamweaver says everything is OK when I press the test button.

However when i try and view the tables from the new databse connection it shows that there are None.

I have spent ages trying to figure out for myself why it will not work and have reached a dead end! Any suggestion or help would be much appreciated.

James

[mattur]

How are you viewing the tables?

[jamesbrightley]

I'm simply clicking the plus sign on the connection tree on the panel on the left hand side in Dreamweaver. Usually with a PHP test server I had setup before you can actually see the the tables and the table headers. i.e user_id, user_name etc etc

Im guessing its probably a permisions thing with Vista which im actually getting really frustrated with!

[mattur]

Sorry James, I don't really use DW so can't help there.

I would say though that if you're serious about putting together dynamic database driven apps you'll need to learn to code ASP - or ASP.NET, PHP etc. (Probably not the answer you're looking for :))