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:
Access a broad range of knowledge to help get the most out of your products and services.