Using access to access an access database and an SQL database at t

  • Thread starter Thread starter Henry
  • Start date Start date
H

Henry

Hi All,

Can I use Access 2003 to access another Acess 2003 database (.mdb) and an
SQL database at the same time?

Thanks,
Henry Nguyen
 
Yes.
You could also throw in an Excel spreadsheet, too :)

It is not at all uncommon to link to multiple back end data sources.
 
Henry said:
Can I use Access 2003 to access another Acess 2003
database (.mdb) and an SQL database at the same time?
Click to expand...

Yes, as Klatuu said, but only with an MDB/MDE or ACCDB/ACCDE database. You
can only access data in an MS SQL Server database from an ADP/ADE.

Larry Linson
Microsoft Office Access MVP
 
Larry,

You can link to MS SQL database tables using ODBC from an MDB using a
DSN or using a DSN-less connection string. I have several databases
where I have done that.

Am I misunderstanding what you are saying?

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
John Spencer said:
Larry,

You can link to MS SQL database tables using ODBC from an MDB using a DSN
or using a DSN-less connection string. I have several databases where I
have done that.

Am I misunderstanding what you are saying?
Click to expand...


I imagine what he meant was that, from an ADP/ADE, you can only link to SQL
Server, but from and MDB/MDE/ACCDB/ACCDE you can link to a variety of data
sources including JET and SQL Server.
 
John Spencer said:
Am I misunderstanding what you are saying?
Click to expand...

I can see where what I wrote might be misunderstood.

My point was intended to be this: you canNOT link to an MDB or ACCDB, nor
via ODBC to an ODBC-compliant database from an ADP -- ADPs can only work
with SQL Server databases. Sorry I was not clear.

Larry Linson
Microsoft Office Access MVP
 
OK. Now the light dawns. I see now what you meant. Thanks.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and move Access 13 database on laptop to pc with Access 13 0
Best way to deploy Access read-only database that is linked to SQL tables 6
Relink of SQL Server tables in Access 2013 causes massive bloat 0
Access Frontend to SQL database 2
Opening multiple databases at the same time in Access 2007 5
Insert in to access database 4
Compact Access Database from Excel via VBA 1
Compact and repair 1

Back
Top