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

[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

 

[Klatuu]

Yes.
You could also throw in an Excel spreadsheet, too

It is not at all uncommon to link to multiple back end data sources.

 

[Larry Linson]

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

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

 

[John Spencer]

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
'====================================================

 

[Dirk Goldgar]

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?

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.

 

[Larry Linson]

Am I misunderstanding what you are saying?

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

 

[John Spencer]

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

 

[Henry]

Thanks guys. you save me alot of time.

Henry Nguyen