Multiple Error Messages (!!)

[Guest]

Hi there,

I administer a networked database running from an Access platform. I was
recently given a new computer at work. The computer was in good shape, free
of viruses, etc. although I did have to update it to Windows XP Service Pack
2. Once doing this however I tried to open the database and now encounter
multiple error messages (mostly with the coding underneath).

But even before any of those messages come up (and they come up as soon as I
try to use any form to access data from other tables, queries, etc.) the
following message pops up as soon as I open the database:

"Your Microsoft Office Access database or project contains a missing or
broken reference to the file 'sstabs32.ocx' version 2.0."

I have no idea what this file is or what part it plays in the database. A
google search on 'sstabs32.ocx' wasn't helpful. I am hoping--perhaps
vainly--that fixing that file will resolve many of the subsequent error
messages coming up.

Any help will be tremendously appreciated.

Thanks,
YYY

 

[storrboy]

Hi there,

I administer a networked database running from an Access platform. I was
recently given a new computer at work. The computer was in good shape, free
of viruses, etc. although I did have to update it to Windows XP Service Pack
2. Once doing this however I tried to open the database and now encounter
multiple error messages (mostly with the coding underneath).

But even before any of those messages come up (and they come up as soon as I
try to use any form to access data from other tables, queries, etc.) the
following message pops up as soon as I open the database:

"Your Microsoft Office Access database or project contains a missing or
broken reference to the file 'sstabs32.ocx' version 2.0."

I have no idea what this file is or what part it plays in the database. A
google search on 'sstabs32.ocx' wasn't helpful. I am hoping--perhaps
vainly--that fixing that file will resolve many of the subsequent error
messages coming up.

Any help will be tremendously appreciated.

Thanks,
YYY

There is a file named sstabs32.ocx that the DB relies on. You'll need
to likely get it off one of the other computers, copy it to the one
with the problem and register it. If you can determine the location of
it on another machine, I would first copy it to the same location on
yours, and see if the DB works. If not you may need to register it
using regsvr32.exe.

In the Start/Run box enter - regsvr32.exe "pathToFile\sstabs32.ocx"

 

[Allen Browne]

Open the code window (e.g. press Ctrl+G.)
Choose References on the Tools menu.
Try unchecking the box beside the "missing" library.
Then choose Compile on the Debug menu.

If the library is not actually used, that could solve the problem. If the
library is used, you will need to find out what this library is and get the
correct version installed on your computer.

For more info, see:
Solving Problems with Library References
at:
http://allenbrowne.com/ser-38.html

 

[Guest]

Hi there Allen,

Your suggestion

Try unchecking the box beside the "missing" library.
Then choose Compile on the Debug menu.

seemed to do the trick! The missing library was called "Sheridan
Tab/Notebook OCX Control". (My previous computer was a laptop so perhaps it
had something to do with that.)

Many thanks. You saved the day.

David