Where do I set up delete permission on 'MSysObjcts' in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I get an error message while trying to reconfigoure relationships in Access
2007 Beta. It does not allow me to remove the exisiting relationships. The
original file have been created in Office XP, but already saved as an access
2007 file.
The message says : Records cannot be deleted; no delete permition on
MSysObjects.
I checked the DB user permitions and everything is set to the Admin user
which seams correct.
 
You do not want to delete objects from MSysObjects!
Fortunately, MS denies you permission to do that.

If you are attempting to programmatically delete all relationships in your
database, see the DeleteAllRelationships() function at:
http://allenbrowne.com/DelRel.html
 
Back
Top