AutoCAD Map 3D Developer

Reply
Valued Contributor
edwa8511
Posts: 52
Registered: ‎11-21-2008
Message 1 of 4 (2,831 Views)
Accepted Solution

32/64 bit Database Problems (Access or SQL)

2831 Views, 3 Replies
02-18-2011 10:47 AM

I have just updated my system to Windows 7 and Map 3D 2011 (64 bit).  I did have all of my databases in Access, but it seems that none of them are connecting on my new system.  I have been told that the best solution is to move everything to SQL, which we have, but I am ignorant about using. 

 

Should I keep trying to solve the problem with the Access files that I know, or should I spend the time to learn SQL?

 

Any Suggestions?

*Expert Elite*
norman.yuan
Posts: 959
Registered: ‎04-27-2009
Message 2 of 4 (2,826 Views)

Re: 32/64 bit Database Problems (Access or SQL)

02-18-2011 12:17 PM in reply to: edwa8511

The connection to Access database only works if you have MS Access 64bit version installed, or you can downloaded MS Access engine 64-bit and install it to the computer.

 

The catch is if your computer (64-bit Windows) has 32bit MS Office (very likely, because MS recommend to use Office 32bit, rather than 64-bit in 64-bit machine) installed, you cannot install 64-bit Access engine. So, if you want to keep your data in Access DB, then you need to install 64bit Access Engine, and install 64-bit Office (if the user need to use Office).

 

If you are very interested in programming, going beyond Access DB and start learning a server type database system, such as SQL Server, is always a good investment., considering the powerful DB system SQL Server Express and its express version of Management Studio is free and often more than enough to serve a small/midium-sized office.

Valued Contributor
edwa8511
Posts: 52
Registered: ‎11-21-2008
Message 3 of 4 (2,822 Views)

Re: 32/64 bit Database Problems (Access or SQL)

02-18-2011 01:30 PM in reply to: norman.yuan

Thanks for the info.

 

So I should ask our IT to reinstall my Office and us the 64 bit version?

 

Would I still need to install additional drivers for the Access data connection or would everything be included with the 64 bit Office?

*Expert Elite*
norman.yuan
Posts: 959
Registered: ‎04-27-2009
Message 4 of 4 (2,821 Views)

Re: 32/64 bit Database Problems (Access or SQL)

02-18-2011 02:00 PM in reply to: edwa8511

Even you installed 64-bit MS Office (Office2010), if it is standard version (e.g. not incudling MS Access), you stll have to download MS Access Database Engine 64-bit from MS site and install it. If other CAD users need to use the drawing (with DB links to the *.mdb/*accdb file set up) with 64-bit Acad, they also need MS Access Database Engine 64-bit installed.

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community