topic Re: dbconnect with microsoft access 2007 in AutoCAD Forum

dbconnect with microsoft access 2007

Anonymous — Thu, 08 Sep 2016 18:27:56 GMT

I am having problems with connecting Access 2007 (32 bit) to AutoCAD 2017 (32 bit).

I create a data source name.

The Date Link Properties dialog box indicates the following OLE DB Providers:

1. Microsoft OLE DB Provider for ODBC Drivers

2. Microsoft OLE DB Provider for Search

3. Microsoft OLE DB Provider for SQL Server

4. Microsoft OLE DB Provider Simple Provider

5. MSDateShape

6. OLE DB Provider Microsoft Directory Services.

The only one that connects is OLE DB Microsoft Directory Services however when I test the connection I receive an error indicating the connection failed. I select yes and the data link indicates the test connection succeeded. The "red x" disappears from the data source I created but I am not able to open the table.

Can someone assist me?

Re: dbconnect with microsoft access 2007

john.vellek — Thu, 08 Sep 2016 19:31:21 GMT

HI @Anonymous,

I'm afraid that my version of Access is a lot newer but I would still like to try working with your database/table. Is it possible for you to attach it for me?

I am also working in 64 bit 2017 so we will have to see if that makes a difference as well. If memory serves me, I have used Microsoft OLE DB Provider for ODBC Drivers in the past.

Re: dbconnect with microsoft access 2007

Anonymous — Thu, 08 Sep 2016 20:26:03 GMT

I would appreciate your help. Sure - you can remote into my pc.

Re: dbconnect with microsoft access 2007

john.vellek — Thu, 08 Sep 2016 20:31:14 GMT

Hi @Anonymous,

Since this is forum support, remoting into your desktop is not really possible. However, if you can share your drawing and database I will see if I can provide you with some suggestions. If we need to do this privately and not on the forum itself let me know and I can send you a secure upload location.

Re: dbconnect with microsoft access 2007

Anonymous — Thu, 08 Sep 2016 20:39:34 GMT

I've attached a sample drawing. Looks like I can only attach 1 file so I'll send you the database file next.

Re: dbconnect with microsoft access 2007

Anonymous — Thu, 08 Sep 2016 20:46:48 GMT

Won't allow me to send the Access file. Getting this error:
Correct the highlighted errors and try again.
The file assets.accdb does not have a valid extension for an attachment and has been removed. art,3dp,3ds,ach,asx,avi,axm,bm,bmp,cfz,chm,cps,csv,dbf,dcl,doc,docx,dst,dwf,dwfx,dwg,dws,dwt,dxf,dyf,dyn,eco,env,esri,f3d,f3z,fbx,fm,gif,gz,gzip,iam,ics,ide,idw,iks,ipn,ipt,jfif,jpe,jpeg,jpg,log,lsp,mac,max,mb,mp4,mpg,msg,nc,nc1,nwc,nwd,nwf,obk,pat,pc3,pdf,pkt,png,png,ppt,pptx,prj,psd,rar,rfa,rft,rlf,rtd,rvt,sat,sdf,sdf,sdf2,sdf3,shp,shx,simstudio,sldasm,slddrw,sldprt,step,stm,stp,svf,svg,text,tif,tiff,txt,vcf,vtf,vtfx,wmv,xls,xlsx,xml,xps,zip are the valid extensions.

Access file has an accdb extension.

Re: dbconnect with microsoft access 2007

john.vellek — Thu, 08 Sep 2016 20:48:01 GMT

Hi @Anonymous,

Please place the file(s) in a ZIP file and then attach them. If you still have difficulties please let me know.

Re: dbconnect with microsoft access 2007

Anonymous — Thu, 08 Sep 2016 21:05:35 GMT

I'm coming up with an error when I zip them to Outlook. The files are small - do you have an email account I can send them to.

Re: dbconnect with microsoft access 2007

john.vellek — Thu, 08 Sep 2016 21:08:22 GMT

Hi @Anonymous,

Don't use email to do this. Simply rt-click the file(s) and Send them to a compressed file. Then using your web browser go to this thread

http://forums.autodesk.com/t5/autocad-2013-2014-2015-2016-2017/dbconnect-with-microsoft-access-2007/m-p/6551001#M140608

and you can start a new post and add the file as an attachment.

Re: dbconnect with microsoft access 2007

Anonymous — Thu, 08 Sep 2016 21:13:00 GMT

Here you go.

Re: dbconnect with microsoft access 2007

john.vellek — Thu, 08 Sep 2016 21:22:18 GMT

Hi @Anonymous,

Excellent! Let me download and take a look.

Re: dbconnect with microsoft access 2007

john.vellek — Thu, 08 Sep 2016 21:32:52 GMT

Hi @Anonymous,

I prepared a Screencast video to show how I can access your database in AutoCAD. In addition, I have a link here to a recent YouTube video prepared by a colleague that shows how you can use this connection on your drawing.

Please let me know how this works for you and if you need additional assistance.

Please select the Accept as Solution button if my post solves your issue or answers your question.

Re: dbconnect with microsoft access 2007

Anonymous — Fri, 09 Sep 2016 00:34:36 GMT

I am getting the attached error message.

Re: dbconnect with microsoft access 2007

Anonymous — Fri, 09 Sep 2016 03:08:15 GMT

I created a similar Excel spreadsheet and get the same error message. Please note that I am using a standalone pc and am not connected to a network.

Re: dbconnect with microsoft access 2007

john.vellek — Mon, 12 Sep 2016 13:51:51 GMT

Hi @Anonymous

When configuring the dbconnector did you use "Microsoft OLE DB Provider for ODBC Drivers"?

With the Excel spreadsheet you used the Datalink feature?

Perhaps you have some permissions issues. Are you a local administrator on your workstation?

Re: dbconnect with microsoft access 2007

Anonymous — Fri, 09 Sep 2016 20:02:07 GMT

I logged on as administrator, added Microsoft Access Database to the ODBC connection and configured dbconnect as you suggested. I receive the attached error message.

Re: dbconnect with microsoft access 2007

john.vellek — Fri, 09 Sep 2016 20:11:20 GMT

HI @Anonymous,

This is a MS error message that (I am guessing) means that you have a 64 bit driver and a 32 bit application. They must match in order to create the link.

Here is an article I found that might help you correct this.

Please select the Accept as Solution button if my post solves your issue or answers your question.

Re: dbconnect with microsoft access 2007

john.vellek — Mon, 12 Sep 2016 13:52:46 GMT

HI @Anonymous,

I am checking back to see if you were able to get your ODBC connector installed and configured properly.

Please update your status.

Re: dbconnect with microsoft access 2007

Anonymous — Thu, 15 Sep 2016 19:34:53 GMT

I'm attempting to work on the problem at a Microsoft forum - still in limbo. As for now dbconnect is not working.