Error opening linked tables

[Rick Smit]

At this moment i'm developing some applications using
Access 2000 (with all servicepacks installed). This worked
fine, until i got the error "unknown" while opening a
linked table. Now i can't open any linked table from any
database. Also Access projects (ADP with SQLServer as
backend) doesn't work anymore. I already re-installed MS
Office. This isn't the sollution. Can anybody help me?
This is a serious problem. I don't want to re-install
Windows.......

 

[Joan Wild]

Have you tried deleting the link and recreating it?

 

[TC]

You are saying that when you double-click a linked table to open it, Access
replies with the message "unknown"?

TC

 

[Rick Smit]

Hi Joan,

I've tried to delete the link and recreate it. This didn't
work out. I've search the web and newsgroups and there are
other people having this problem. Nobody ever had the
solution. Looks like a unsolved bug.

Kind regards,
Rick Smit

 

[Joan Wild]

Hi Rick,

Hi Joan,

I've tried to delete the link and recreate it. This didn't
work out.

Could you be more specific on this. What happened; did you get an error
message?

 

[Rick Smit]

Yes TC, that's right.

You are saying that when you double-click a linked table to open it, Access
replies with the message "unknown"?

TC

 

[TC]

Sorry Rick, I don't mean to disbelieve you, but let me get this straight:

You go to the database window, double-click a linked table, and you get a
messagebox containing the single word "unknown"? No other text?

What is the title (if any) on the top line of the messagebox?

What are the buttons on the message box?

Does the messagebox have any icons (pictures) etc.?

I'm asking these questions in an effort to identify where the error is
coming from. The plain message "unknwon" is not an MS Jet or Access error,
AFAIK.

TC

 

[Rick Smit]

It's a simple plain messagebox. No pictures or icons, only the text
"unknown". This happend in every Access database (or project) i'm
trying to open. Because it happens with all databases it seems to be a
configuration Error from Access on my computer???? :-((

 

[TC]

Ok. Rick, would you try this please. Put the following code in a module.
Replace ZZZZZ with the local name of one of the linked tables that gives you
the error. If you can, cut and paste the code verbatim, rather than
re-typing it. Make sure there are no other modules, reports, forms, queries
or tables open. Then open the debug window (ctrl-g) and type z <return> to
run the code. Then copy/paste the results back to this thread. I have an
idea what might be hapenning, & this output will help.

Unfortunately I don't have Access on this PC, so this code is off the top of
my head; but it should be ok.

public sub z()
dim db as database, td as tabledef, p as property
set db = currentdb()
set td = db.tabledefs![ZZZZZ]
for each p in td.properties
debug.print p.name; vbtab; ">";
on error resume next
debug.print p.value;
if err.number <> 0 then debug.print err.description;
on error goto 0
debug.print "<"
next
set td = nothing
set db = nothing
end sub

HTH,
TC