Cannot connect to Access database

Question

Hi,

I've already spent much time on the issue of connecting to my
Access database and cannot figure out why it will not work at all.
Here is the situation :
I use Dreamweaver CS3 with Access 2007 on a Windows Vista
computer (with IIS 7.0).

While my connection to the database works on a Windows XP
computer it will not work on my vista computer ! It always fails
when testing from the BD OLE connection window

Has anyone come into this problem before? Please help !

Newsgroup_User · Accepted Answer

See if this helps:http://blogs.iis.net/bills/archive/2007/5/21/1718507.aspx-- Ken FordAdobe Community Expert Dreamweaver/ColdFusionFordwebs, LLChttp://www.fordwebs.com"nickbush" <webforumsuser@macromedia.com> wrote inmessage news:g8uat8$rv9$1@forums.macromedia.com...> Thanks Ken>> My Windows is Vista Home Premium 32 bits>> I tried the string you suggested but, unfortunately Iget a meaningful> "undefined error" (I hope this is the right translationbecause I use a > French> version of Dreamweaver).>> Nico>>>

Newsgroup_User · Answer

64-bit Vista?The 32-bit drivers are not installed.Try using a connection string like this:"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Websites\database\yourdatabase.mdb;"-- Ken FordAdobe Community Expert Dreamweaver/ColdFusionFordwebs, LLChttp://www.fordwebs.com"nickbush" <webforumsuser@macromedia.com> wrote inmessage news:g8tph5$5u0$1@forums.macromedia.com...> Hi,>> I've already spent much time on the issue of connectingto my Access > database> and cannot figure out why it will not work at all.> Here is the situation :> I use Dreamweaver CS3 with Access 2007 on a WindowsVista computer (with > IIS> 7.0).>> While my connection to the database works on a WindowsXP computer it will > not> work on my vista computer ! It always fails when testingfrom the BD OLE> connection window>> Has anyone come into this problem before? Please help !>>>>>>

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded