MS Access Database Connection problem in Excel XP 2002
 

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

MS Access Database Connection problem in Excel XP 2002
 

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


"Sarwat Malik" wrote:

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