AutoCAD Map 3D General Discussion

AutoCAD Map 3D General Discussion

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

Access file not attaching

737 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,417
Registered: ‎06-29-2007
Message 2 of 8 (733 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 (708 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 (705 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,417
Registered: ‎06-29-2007
Message 5 of 8 (688 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: 447
Registered: ‎01-12-2008
Message 6 of 8 (643 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 (636 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: 447
Registered: ‎01-12-2008
Message 8 of 8 (599 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
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!