• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    AutoCAD Map 3D

    Reply
    Contributor
    indianadarren
    Posts: 18
    Registered: ‎07-30-2011

    Access file not attaching

    461 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!


    Please use plain text.
    *Expert Elite*
    Posts: 6,457
    Registered: ‎06-29-2007

    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
    -------------------------------------------------------------------------
    Please use plain text.
    Contributor
    indianadarren
    Posts: 18
    Registered: ‎07-30-2011

    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?

     

    Please use plain text.
    Contributor
    indianadarren
    Posts: 18
    Registered: ‎07-30-2011

    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

    : (

     

    Please use plain text.
    *Expert Elite*
    Posts: 6,457
    Registered: ‎06-29-2007

    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
    -------------------------------------------------------------------------
    Please use plain text.
    Valued Contributor
    Ajilalv
    Posts: 78
    Registered: ‎01-12-2008

    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.

     

    Please use plain text.
    Active Contributor
    Posts: 40
    Registered: ‎08-21-2008

    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.

    Please use plain text.
    Valued Contributor
    Ajilalv
    Posts: 78
    Registered: ‎01-12-2008

    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.

    Please use plain text.