I have an older water line project that was connected to the file water.mdb. I am trying to connect the dwg to the mdb and am getting an error. I have enclosed a screen shot of the error. FYI i am using 2011 Civil 3d, and the dwg was originlly done in Autocad Map. (2005 I think) Any help would be greatly appreciated. Also, I am just using drag/drop to attach this dbase.
are you now on 64bit Windows? If so you will have to install the 64bit ODBC-driver for MDB (check >>>here<<<, but be careful with your existing MS-Office-installation!).
Or convert your MDB to any other 64bit-compatible database like MS-SQL-Server and get then connected to that.
- alfred -
Instead of FDO, what about connecting the .MDB file by means of _MAPATTACHDB command..?
Agree, if the dwg was from 2005 version then that's how it was connected to it then.
>> Instead of FDO, what about connecting the .MDB file by means of _MAPATTACHDB command..?
Does not work either in 64bit without the 64bit-driver ;(
>> What software would I use to convert MDB to SQL?
If you install the SQL-Server (with all tools) then you have also "SQL Server-Import/Export Assisten" installed (or you can it install afterwards), check >>>this link<<<.
But there are also a lot of tools around data-exchange between different db-servers!
- alfred -
Hello. Assuming that you are running Windows 7 64-bit...
Windows 7 64-bit doesn't handle ODBC the way it used to, so you can't drag & drop Access or Excel files into Map Explorer like you used to on 32-bit.
Please see the following links for instruction on how to do this on 64-bit:
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Start with some of our most frequented solutions to get help installing your software.