Connecting to Access 2007 from Dreamweaver

[i2photo]

I am having problems with what I think should be a relatively simple matter.
I am using an XP machine running IIS and ODBC as a testing server for a web
application that has to talk to an Access 2007 database. I have downloaded
and installed the Access Database Engine from Microsoft and have ODBC set up
with a System DSN pointing at the Access 2007 Database file.

I know that the Provider record I need to use is "Microsoft Office 12.0
Access Database Engine OLE DB Provider" but I can't seem to get Dreamweaver
to get a valid connection. Can anyone help me out here. I have searched a
lot on the web for help or recommendations with no success. Any help or
pointers would be gratefully received.

 

[Alex Dybenko]

Hi,
try that one:
http://www.connectionstrings.com/?carrier=access2007

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[i2photo]

That was what I needed to fix my problems - thank you very much.