OBDC Drivers for access

[Climberman]

I have a 64 bit vista and need the obdc driver for access 2007 there are only drivers for sql

 

[boblarson]

What program are you trying to connect to an Access 2007 database?

 

[Climberman]

I use Dreamweaver 8 and access 2007 I am trying to connect dreamweaver so that I can view my site on my computer before uploading it to the host.

 

[boblarson]

Check this page out (remember to scroll down as it appears at first glance to be an almost empty page).

 

[Climberman]

Thanks for the help, I don't know what to do with those strings I only know to go to the Data source odbc and there you should be able to choose .mdb but all there is are two sql choices.
Am I suppose to connect to the sql

 

[boblarson]

Thanks for the help, I don't know what to do with those strings I only know to go to the Data source odbc and there you should be able to choose .mdb but all there is are two sql choices.
Am I suppose to connect to the sql

Do you not have Access 2007 installed on your machine? If not, you might install the Runtime (free) and then perhaps the data source will be available to you.

 

[Climberman]

I have 2007 I will try to the runtime if I can figure that out I wondered why it didn't install with I loaded access

 

[boblarson]

I have 2007 I will try to the runtime if I can figure that out I wondered why it didn't install with I loaded access

Can you upload a screenshot of what you see when you go to the ODBC manager and try to click New DSN?

 

[Climberman]

I tried to reinstall access and it still says that .mdb isn't there and I need to install them

 

[Climberman]

I will upload a screen shot

 

[Climberman]

I will upload a screen shot
I hope this works

 

[boblarson]

When you get to that dialog, click the ADD button and Select System DSN, and not the configure button for Access.

 

[boblarson]

You should have an ACCDB file one which if you are using the ACCDB file format, is what you would need.

I know there has to be another way to connect using DreamWeaver, but I don't have it to look at to tell you how.

 

[Climberman]

This snap shot is all I get it is sql

 

[Climberman]

Here it is

 

[Climberman]

I use to have the older version of window but then I bought a new computer and it come with vista 64 bit and now I can't get things to work

 

[boblarson]

Yeah, it looks like you have a problem. So, did you install Access 2007 or Office 2007 with Access included? This is strange. I had Windows Vista 64 bit and my ODBC drivers were installed when I installed Office. I have Windows 7 64 bit now and I don't have a problem with them being gone.

 

[Banana]

A thought. Are you sure you're actually looking in ODBC (x86)? I remember being confused when I found out there were two locations, one for 64-bit and other one for 32-bit (e.g. x86).

 

[Climberman]

Should I reinstall access

 

[Climberman]

I have office 2007