I am following a tutorial on the adobe site for how to connect to an Access database using Dreamweaver CS5. It states that I cannot connect to Access unless I have changed my settings to enable 32 bit applications. I am unable to find this function using Windows 7.
Are you following David Powers' tutorial?
He explains it here
Enabling connection to an Access database on 64-bit Windows
Any reason you're using Dreamweaver for ASP (or are you using ASP.NET?) development?
Since it's a Microsoft proprietary technology, Adobe lost interest in ASP back around CS4. They left the tools there but don't develop or support them anymore.
ASP developers are better off using Microsoft Expression Web.
I am following the D Powers tutorial. There is no real reason for me using ASP and happy to use ASP.net but really need a tutorial on how to connect to an Access database using this or MS Expression Web; any suggestions? I am real beginner with Dreamweaver and Access, but trying to keep it simple compared to SQL.
Unfortunately the tutorial does not work for Windows 7 as I can not find how to enable the 32 bit applications. The interface and options are very different in windows 7 and I have tried the help to search for information with no joy.
I have Windows 7 Ultimate here and I just followed the tutorial. Works OK.
Which flavour of Windows 7 are you running?
Can you get to the IIS Manager?
From the tutorial
The Microsoft Access Driver is not available in a 64-bit version, so you need to use the 32-bit driver.
When I select my Controls Panel I do not get the option of Administrative Tools. I only have the following options:
- systems and security
- network and internet
- hardware and sound
- user accounts and family safety
- appearance and personalization
- clock, language and region
- ease of access
I'm guessing that you're running Windows 7 Home Premium?
IIS is not installed by default on the Home versions of Windows 7.
See also Setting up an ASP application server
Do you have to use ASP (which needs IIS)?
PHP, free and open source, is a much more popular choice for web developers these days and does not rely on IIS at all.
Europe, Middle East and Africa