Help Converting from ODBC to OLE DB ?

[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

 

[Douglas J. Steele]

You cannot use Ole Db to create linked tables (nor pass-through queries), if
that's what you're asking.