AliceEng
asked on
Troubleshoot and repair Jet 4.0 database engine that will not link to ODBC databases
After installing Norton Internet Security 7.0, I open up Access 2003. Open an existing database, select the 'Get External Data', 'Link Tables...', and then click 'ODBC Databases()' for the file type. Normally, a list of acceptable ODBC Databases will appear for user selection. However, this time there are no database list displayed, and every dialogue box closed up as if the 'Link Tables...' command never had ran in the first place. I started to troubleshoot my problems as follows:
1. Created a new Access database db1.mdb and retried the 'Link Tables...' again. Same problem, no ODBC database list.
2. Examined the MSJet40.dll (version 4.0.8618.0, dated 8/4/2004) registry configuration settings. They all matched what Microsoft recommended. My O/S is WindowsXP Pro, Office 2003, and all security and service packs recommended by Microsoft have been installed.
3. From the Microsoft download center, I proceed to download the current Jet 4.0 SP8 for WindowsXP. Then tried to install it and it won't let me. It said that the version being installed is older than my current Jet version.
4. Next, I downloaded the Jet engine SP8 for use with Windows 2003. While trying to install it over my older version, it aborted saying that my O/S does not match the intended version of this update.
5. Under the Control Panel, I tested my ODBC DSN and all is in good order. My backend database is in SQLServer 2000.
6. I disabled Norton Internet Security and re-opened MSAccess and try again, still the same problem.
Any suggestions on how to repair this mal-functioned Jet 4.0 are much appreciated. Thank you for your attention.
PS: Is this problem related to the installation of Norton Internet Security?
1. Created a new Access database db1.mdb and retried the 'Link Tables...' again. Same problem, no ODBC database list.
2. Examined the MSJet40.dll (version 4.0.8618.0, dated 8/4/2004) registry configuration settings. They all matched what Microsoft recommended. My O/S is WindowsXP Pro, Office 2003, and all security and service packs recommended by Microsoft have been installed.
3. From the Microsoft download center, I proceed to download the current Jet 4.0 SP8 for WindowsXP. Then tried to install it and it won't let me. It said that the version being installed is older than my current Jet version.
4. Next, I downloaded the Jet engine SP8 for use with Windows 2003. While trying to install it over my older version, it aborted saying that my O/S does not match the intended version of this update.
5. Under the Control Panel, I tested my ODBC DSN and all is in good order. My backend database is in SQLServer 2000.
6. I disabled Norton Internet Security and re-opened MSAccess and try again, still the same problem.
Any suggestions on how to repair this mal-functioned Jet 4.0 are much appreciated. Thank you for your attention.
PS: Is this problem related to the installation of Norton Internet Security?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Responding to JDettman's
<<See if you can get a list of ODBC databases using MS Query (part of Excel). If not, then something is wrong with the ODBC Manager/Driver, otherwise it's Access.>>
Thanks for the suggestion, I've tried Excel, no problem. I can see all the SQLServer Data Sources on the list and was able to import from a table into my Excel sheet.
Hence, the error has to do with Access not the ODBC Manager/Driver.
Something is wrong with the Jet database engine. It was working just fine until I've installed NIS 7.0.
Alice
<<See if you can get a list of ODBC databases using MS Query (part of Excel). If not, then something is wrong with the ODBC Manager/Driver, otherwise it's Access.>>
Thanks for the suggestion, I've tried Excel, no problem. I can see all the SQLServer Data Sources on the list and was able to import from a table into my Excel sheet.
Hence, the error has to do with Access not the ODBC Manager/Driver.
Something is wrong with the Jet database engine. It was working just fine until I've installed NIS 7.0.
Alice
ASKER
Responding to Capricorn1 regarding <<uninstalling NIS 7.0>>
I am really afraid to uninstall NIS 7.0 because I've already tried once and the system crashed during the process. I've to download a 'Removal tool' from Symantec to completely clean the Window's Registry of NIS files. After running the 'Removal Tool', I was unable to login to my system saying I have no access right to my Domain. I've to disable internet connection, load the Windows O/S at the raw simple state without network access to get in and repair my system. After two weeks of being totally unprotected without a personal firewall nor anti-virus software, I backup my sytem and created a new CheckPoint for Restore and reinstalled NIS 7.0. Everything ran fine for one week, until I need to access the 'Link Tables' via ODBC to my new SQLServer table. The Jet Engine failed me.
Alice
I am really afraid to uninstall NIS 7.0 because I've already tried once and the system crashed during the process. I've to download a 'Removal tool' from Symantec to completely clean the Window's Registry of NIS files. After running the 'Removal Tool', I was unable to login to my system saying I have no access right to my Domain. I've to disable internet connection, load the Windows O/S at the raw simple state without network access to get in and repair my system. After two weeks of being totally unprotected without a personal firewall nor anti-virus software, I backup my sytem and created a new CheckPoint for Restore and reinstalled NIS 7.0. Everything ran fine for one week, until I need to access the 'Link Tables' via ODBC to my new SQLServer table. The Jet Engine failed me.
Alice
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
See if you can get a list of ODBC databases using MS Query (part of Excel). If not, then something is wrong with the ODBC Manager/Driver, otherwise it's Access.
Better yet, if you have another product outside of an Office that can use an ODBC connections, try it with that.
JimD