Upgrading access 2000 to access 2003

[Torgeir Torgersen]

Yesterday I upgraded a customer from access 2000 to access
2003. After this upgrade they get some error messages when
they try to open some access databases.

The first error is this:
Security warning Unsafe epressions are not blocked.

Will this problem disapear if i install Microsoft jet 4.0
service pack 8??

The second error says:

Your Club1 database or project contains a missing or
broken reference to the file MARQUEE.OCX version 1.0
To ensure that your database or project works properly you
must fix this reference.

"The application you are attempting to use has a reference
it cannot resolve to an object, type library, DLL, or
external database. Either the object, type library, DLL,
or database was deleted or its name has changed. Examine
the Available references list in the References dialog box
in the Visual Basic Editor (Tools menu) to determine if
any action is required. If you did not create this
application, contact the programmer or administrator of
the system.
If the reference listed in the Available references list
is preceded with "MISSING:" clear the check box to remove
the reference if it is no longer required. If you still
need to use the reference, clear the check box entry
for "MISSING: <referencename>" in the Available references
list, and then create a new reference to the file using
the Browse... button. If this is an installed database
application, you may need to reinstall or repair the
application.
More information about this error message online."

How can i repair this.

Regards

Torgeir Torgersen

 

[Allen Browne]

The first message is the worst of the new nonsense in Access 2003.
To avoid it, set your Macro Security setting to low under:
Tools | Macros | Security
If you do not see the menu item, reset your menu by right-clicking on the
toolbar area, and choosing Customize.

The 2nd message indicates that the customer's machine does not have the
marquee.ocx where Windows expects to find it. If you do not need this
library, open a code window, choose References from the Tools menu, and
uncheck it. If you do need it, make sure the library is present on the
customer's machine, in the right place, and is registrated in that location.
Use regsvr32 to register it if necessary.

More information about references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

More infomation about macro security:
http://office.microsoft.com/assista...3&CTT=8&Origin=EC011081751033&Product=acc2003

 

[Torgeir Torgersen]

Hey

Thank you very much for a quick answer. I am wondering
about where the library should be located . Is it the
access directory or elsewhere. I have never worked with
access and dont know where the library should be placed.

torgeir torgersen

 

[Allen Browne]

I don't use this ocx, so cannot say.
Typically you would find ocx files in windows\system32.