Can't use Database after it was being opened in Vista

  • Thread starter K90267000 via AccessMonster.com
  • Start date
K

K90267000 via AccessMonster.com

Hi all,
does opening the database in VIsta, affects the database's set of permissions?


My scenario:
(1) ABC.accdb was used in XP environment.
(2) ABC accdb then opened in Vista.
(3) ABC.accdb open in XP again.....BOOM....
a series of Msyscompact error....stating...

The necessary permissions to use the 'blah blah....' object. Have your
system administrator or the person who created this object establish the
appropriate permissions for you.

i cannot use the previous Vista to try open it again, because i have re-
installed XP on the machine.

What should i do ?

Thanks!
 
K

K90267000 via AccessMonster.com

more info...
when I try to opening, the message is............
"microsoft access has detected that this database is in an inconsistent state,
........blah..."
i click ok...
it says "Access has recovered this database. Examine to verify there are no
missing ...blah..."
i click ok...
on the navigation panel, there is only a "MSysCompactError" table
when i try to open, it says....
"the db cannot be opened because the VBA project contained in it cannot be
read....blah......
.....blah......asking me to delete VBA ......"
i click ok......
the "MSysCompactError" table appear...
column 1: error codes of "-1907"
column 2: error description.." you do not have the permission to use XXX......
..."

any help please? :)
 
Top