MS Access Database Connection problem in Excel XP 2002

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
 
K

keepITcool

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 >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Permissions Error 3173 3
Could not open table 'MSysAccounts' in the workgroup information f 6
Retrieving hyperlink from MS Access database 2
excel form populating in access 2002-03 but not 2007 8
Win7 VirtualStore Weirdness with Excel 2002 and earlier 60
Excel form to update data from MS Access data table based on criteriain excel sheet 2
Problem with connection to sql server from excel 2
Using data from cells in a Query to a MS Access Database 2

Top