R
rael_lucid
Hi,
I am trying to install an Access 2003 DB onto a PC running Windows 2000 SP4
+ Office Pro 2003.
The database requires a few tables to be linked to an external database
(non-MS) through an ODBC DSN.
The DSN works perfectly with other apps (eg: MS Excel import data) but fails
with MS Access.
The following occurs:
1 - Select File -> Get External Data -> Import
2 - in the "files of type" combobox, scroll down to "ODBC Databases()"
Normally, the ODBC DSN selection window opens... but on this computer,
nothing happens.
I have tried the following:
- install latest Office 2003 service packs
- install latest MDAC components (2.8 SP1)
- reinstall Office 2003
Any ideas?
I am trying to install an Access 2003 DB onto a PC running Windows 2000 SP4
+ Office Pro 2003.
The database requires a few tables to be linked to an external database
(non-MS) through an ODBC DSN.
The DSN works perfectly with other apps (eg: MS Excel import data) but fails
with MS Access.
The following occurs:
1 - Select File -> Get External Data -> Import
2 - in the "files of type" combobox, scroll down to "ODBC Databases()"
Normally, the ODBC DSN selection window opens... but on this computer,
nothing happens.
I have tried the following:
- install latest Office 2003 service packs
- install latest MDAC components (2.8 SP1)
- reinstall Office 2003
Any ideas?