You can mess around with this code and see if it will work for you.
Option Compare Database
Option Explicit
'In order for the program to run successfully, the ODBC System Data source
'should appear as: Amisys-Live
'
'The error code associated with this problem is 3151. To fix this...
I am not sure I follow. If you go through Control Panel, and find your Data Sources (Win 2000 has it under Admin Tools) you set up your drivers from there. Usually there is a driver you can use to set up another connection.
Sometimes with ODBC it is as simple as checking your ODBC Data Source Administrator and making sure Access is set-up correctly. You may have to remove the set-up and redo to fix your problem.
We use this is Access97:
First: Module
Option Compare Database
Option Explicit
'In order for the program to run successfully, the ODBC System Data source
'should appear as: Amisys-Live
'
'The error code associated with this problem is 3151. To fix this problem:
'...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.