access 2007 upgrade

[Guest]

I have just installed the new access 2007 (previously was using 2003). I have
a database I use that won't seem to work in the new access. Most of the
visual basic does not seem to run. No errors are reported but for instance,
the on click event procedure is totally ignored. I have tried these different
things...running the 2003 file in 2007 (VB does not run), importing all the
objects into a new 2007 database (same thing), and I have tried to save a
copy of the 2003 file as a 2007 file but there is a strange table that I
cannot take ownership of called Msyscompacterror. I cannot do anything to
this table (delete, move, modify) since I do not have ownership. It seems
strange that MS would put something out like this that would not convert or
run past versions error free. Maybe I'm missing something. Can anyone point
me in the right direction to fix this? If not, I will have to remove 2007 and
stick with what works-2003.

Thanks in advance.

 

[Allen Browne]

Two suggestions:

1. Go to :
Office Button | Access Options | Trust Center | Trust Center Settings
and set the folder where your database is as a trusted location.

By default, VBA code won't run unless you deal with the security issues.

2. MSysCompactError is a table Access creates when there was a problem with
your database. Open it (using A2003 if necessary) and read what its
record(s) say. You may have lost an index, relation, or data.

If you can't delete it, you can create a new database and import everything.
If you want it to be compatible with older versions of Access, go to:
Office Button | Access Options | Popular
and set the Default File Format to Access 2000.

Then to import, click the External Data tab of the ribbon, and then Access
in the Import group.

 

[Guest]

Thanks allen,
The trust center fix did the trick for the 2007 version and the Msys
table was taken care of by using the 2003 version.

Thanks again.

 

[Joshua A. Booker]

Allen,

How do you configure a policy to add a location to trust center for all
domain users?

TIA,
Josh

 

[Allen Browne]

Haven't tried, Josh.

Perhaps someone who has will answer.