"Class not registered" error received

[iccohen]

Hello-

I have Access 2000, and I imported an Excel spreadsheet as
a table in Access with no probs.

I tried to setup a field in my main table as a Lookup (no
problem), but when I attempt to bring the 2 columns across
in the Lookup dialog boxes and click Next, it states Class
not registered (as an informational dialog box), so I have
to stop.

Anyone know why this appears?

Note that the Field still shows the imported table as the
Lookup, and it still shows up in the Form, but the end
results in my Reports are incorrect.

Thanks,

-Steve

 

[tina]

recommend you don't use Lookup fields in your tables. see the following link
for more info.
http://www.mvps.org/access/lookupfields.htm

 

[iccohen]

Interesting stuff. Unfortunately, they don't recommend
what to do. I have several hundred ports I need to setup,
and now I'm stumped!

 

[tina]

post detail of what you're actually trying to accomplish, maybe i or someone
else can help further.