Cannot connect to Access database

[nickbush]

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]

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 Ford
Adobe Community Expert Dreamweaver/ColdFusion
Fordwebs, LLC
http://www.fordwebs.com


"nickbush" <webforumsuser@macromedia.com> wrote in message
news:g8tph5$5u0$1@forums.macromedia.com...
> 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 !
>
>
>
>
>
>

[nickbush]

Thanks Ken

My Windows is Vista Home Premium 32 bits

I tried the string you suggested but, unfortunately I get a meaningful "undefined error" (I hope this is the right translation because I use a French version of Dreamweaver).

Nico

[Newsgroup_User · Accepted solution]

See if this helps:

http://blogs.iis.net/bills/archive/2007/5/21/1718507.aspx

--
Ken Ford
Adobe Community Expert Dreamweaver/ColdFusion
Fordwebs, LLC
http://www.fordwebs.com


"nickbush" <webforumsuser@macromedia.com> wrote in message
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 I get a meaningful
> "undefined error" (I hope this is the right translation because I use a
> French
> version of Dreamweaver).
>
> Nico
>
>
>

[nickbush]

Indeed, it worked !
Thank you very much Ken.

everything seems ok now !

Again, thank you.