MS Access Database Connection problem in Excel XP 2002

  • Thread starter Thread starter Sarwat Malik
  • Start date Start date
S

Sarwat Malik

I want to get data from Access database into Excel worksheet. But it gives
the following error and doesn't connect to the datbase.

"Could not open table 'MSysAccounts' in the workgroup information file.
(Error 3173)"

I have tried all solutions even reinstalled Office XP 2002 but in vain.
Is there any way to solve this problem urgently.

Thanks

- Ms. Sarwat Malik
 
Looks to me like some ODBC settings
dont allow you to find system tables.

start a new database query
in the 'Choose column' Page of the wizard
click options
make sure that 'system tables' is CHECKED

hth

keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
Back
Top