G Guest Jul 11, 2005 #1 Hi, Can I use SQLconnection to connect to a Access DB File on my local drives? Thanks. Jon
G Guest Jul 11, 2005 #2 Joh, SQLConnection is for connecting to an SQL Server database. For Access you can use an OLEDBConnection. Kerry Moorman
Joh, SQLConnection is for connecting to an SQL Server database. For Access you can use an OLEDBConnection. Kerry Moorman
A Armin Zingler Jul 11, 2005 #3 Jon said: Can I use SQLconnection to connect to a Access DB File on my local drives? Click to expand... No. that's why it's called "SQL"connection (=> SQL Server). Use an oledbconnection instead. Armin
Jon said: Can I use SQLconnection to connect to a Access DB File on my local drives? Click to expand... No. that's why it's called "SQL"connection (=> SQL Server). Use an oledbconnection instead. Armin
P Paul Clement Jul 11, 2005 #4 ¤ 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)
¤ 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)