AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

Reply
Contributor
indianadarren
Posts: 22
Registered: ‎07-30-2011
Message 1 of 8 (751 Views)

Access file not attaching

751 Views, 7 Replies
02-27-2012 09:02 PM

I am trying to ATTACH this Access file. I'm in the Task Pane, map Explorer tab, selecting the Data Source icon. I have used the right click - attach method, as well as the two other methods of Attaching DATA sources (i.e. drag & drop)...nothing is working. Any ideas? Is the file bad?

Attached for your consideration

 

haha, just got this error message when I tried attaching it to this post: "The file does not have a valid extension for an attachment.doc,pdf,dwf,dwg,dxf,dst,gz,gzip,zip,bm,bmp,gif,jfif,jpe,jpeg,jpg,psd,tif,tiff,png,htm,html,xml,xls,lsp,svf,3ds,vcf,png,text,txt,log,env,dcl,rvt,rfa,ipt,iam,ipn,dwfx,idw,csv,nwf,nwc,nwd,sdf,cfz,vtfx,vtf are the valid extensions."

 

If you include your email address I will send it to you for your consideration.

thanks in advance!


*Expert Elite*
Alfred.NESWADBA
Posts: 9,608
Registered: ‎06-29-2007
Message 2 of 8 (747 Views)

Re: Access file not attaching

02-28-2012 02:45 AM in reply to: indianadarren

Hi,

 

You can connect to MS-Access with two ways

  • using command _DBCONNECT
  • using command _MAPCONNECT and try it via ODBC

....and please say you have a 32bit OS, otherwise you have to work with workarounds (as there a no drivers for MDB-files for 64bit except you install >>>this<<< and that may be problematic with some kind of office-installations).

To verify what's now the better method depends on what you like to do with the MDB-data.

 

You can't "attach" is as reference as the MS-Access database has no graphical objects to be shown on the modelspace.

 

- alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Contributor
indianadarren
Posts: 22
Registered: ‎07-30-2011
Message 3 of 8 (722 Views)

Re: Access file not attaching

02-29-2012 03:20 PM in reply to: indianadarren

No, not working. I have a map file without data. I have an Access file with data. According to the following url, I should be able to link them and then generate a link template.

 

http://docs.autodesk.com/MAP/2010/ENU/AutoCAD%20Map%203D%202010%20User%20Documentation/HTML%20Help/i...

 

also, here:

 

http://docs.autodesk.com/MAP/2010/ENU/AutoCAD%20Map%203D%202010%20User%20Documentation/HTML%20Help/i...

 

When I follow the Autodesk "How to Instructions" the results are attached as a jpg. Epic failure, but only @ work - this works fine on my home computer (piece of crap laptop). Are the problems linking Access data to map files?

 

Contributor
indianadarren
Posts: 22
Registered: ‎07-30-2011
Message 4 of 8 (719 Views)

Re: Access file not attaching

02-29-2012 03:28 PM in reply to: Alfred.NESWADBA

RDBMS:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and the Application.

 

This is the specific error

 

hope it helps

: (

 

*Expert Elite*
Alfred.NESWADBA
Posts: 9,608
Registered: ‎06-29-2007
Message 5 of 8 (702 Views)

Re: Access file not attaching

03-02-2012 02:05 AM in reply to: indianadarren

Hi,

 

and the main question once more: you are working on 32bit or 64bit?

 

- alfred -

-------------------------------------------------------------------------
Alfred NESWADBA
Ingenieur Studio HOLLAUS ... www.hollaus.at
-------------------------------------------------------------------------
Valued Mentor
Ajilal.Vijayan
Posts: 449
Registered: ‎01-12-2008
Message 6 of 8 (657 Views)

Re: Access file not attaching

04-05-2012 06:44 AM in reply to: indianadarren

Hai,

 

I am working on 64bit , windows 7 and using Civil 3d 2012.

I am also getting the same message while I trying to connect to access or Excel.

Pleae have a look at the images attached.

 

Active Contributor
dwolford
Posts: 40
Registered: ‎08-21-2008
Message 7 of 8 (650 Views)

Re: Access file not attaching

04-05-2012 08:03 AM in reply to: indianadarren

If you are running Windows 7 (64-bit) with AutoCAD 64-bit you can't connect to 32-bit Microsoft Access/Excel without significant workarounds.  Search this forum for the workarounds.  The easiest workaround is to install a 64-bit version of MS Office.  Otherwise you have to uninsall 32-bit MS Office, download a MS Access driver 64-bit from Microsoft and then reinstall the 32-bit MS Office.  This information is based on my recollection from reading similar posts on this subject.

Valued Mentor
Ajilal.Vijayan
Posts: 449
Registered: ‎01-12-2008
Message 8 of 8 (613 Views)

Re: Access file not attaching

04-08-2012 11:21 AM in reply to: indianadarren

Hai,

Thanks for your reply and forgive me for my late reply.

 

Yeah now I have to deal with our IT team and let see what happens!!

 

At the same time I have done some workaround and I found this article saying that you can use The 32-bit version of the ODBC Administrator tool on 64-bit platform.


But again I need the IT team to solve it.

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.