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

A

Agatagog

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.
 
A

Allen Browne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't delete relationships 4
Access '07 Beta 2, "Record(s) cannot be deleted, no delete permiss 4
No Delete Permission on 'MSysObjects' 5
Cannot access foreign database Msysobjects - No read rights 2
How do I delete a dependency 2
Corruption in access 2003 form 1
Access 2007 Beta 2, Cannot delete a database relationship! 0
User-defined Outlook fields in Access 2

Top