Help Converting from ODBC to OLE DB ?

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

Have not used Access in some time but here goes:
Existing .mdb file with forms and reports etc. uses the native SQL Server
ODBC driver through linked tables.
Can I use an OLE DB connection by pointing to a .UDL file I have setup?
Will the fields and controls in my Access forms blow up?
Just curious if this can be done in am attempt to leverage a more stable DB
connection.
Thanks
TT
 
You cannot use Ole Db to create linked tables (nor pass-through queries), if
that's what you're asking.
 
Back
Top