View Full Version : Access vs. SQL

2004-12-09, 02:54 PM
I'm trying to link a few databases through VBA and Access is not a company standard, SQL is the standard Database here.

I know most, if not all, of the AutoCAD Databases are setup in Access. What is the best way to convert to SQL? or is there a conversion process and if so, are there any problems?

2004-12-09, 03:20 PM
How did you connect to the Access Databases - ADO or DAO?

2004-12-09, 04:01 PM
That's just it, I can't gain access to Access to be able to test the connection. So I need to be able convert the existing db's so that I can do some testing.

2004-12-09, 04:29 PM
SQL Server has an import wizard for all types of data sets including Access.

But, you don't have to have Access to have access to Access. :)

2004-12-09, 11:08 PM
you can use AutoCAD to look at your access database


right click on data sources
select configure a data source

enter a name and click OK

select Microsoft jet on the provider tab

click on

Select the database

test connection

click OK

The data base is how in your data sources

Right click and select connect