can SQLconnection read a Access DB?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Can I use SQLconnection to connect to a Access DB File on my local drives?

Thanks.

Jon
 
Joh,

SQLConnection is for connecting to an SQL Server database. For Access you
can use an OLEDBConnection.

Kerry Moorman
 
Jon said:
Can I use SQLconnection to connect to a Access DB File on my local drives?


No. that's why it's called "SQL"connection (=> SQL Server). Use an
oledbconnection instead.


Armin
 
¤ Hi,
¤
¤ Can I use SQLconnection to connect to a Access DB File on my local drives?
¤

Not directly, but you can create linked tables in SQL Server that connect to an Access database.


Paul
~~~~
Microsoft MVP (Visual Basic)
 

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

Back
Top