A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Realtionship issue



 
 
Thread Tools Display Modes
  #1  
Old July 19th, 2006, 06:51 PM posted to microsoft.public.access.tablesdbdesign
Empxv
external usenet poster
 
Posts: 3
Default Realtionship issue

I have a DB the has serveral realtionships currently in it is need to add one
more and I keep getting the error the I do not have delete premissions in
'MySysObjects'. I have opened the DB in exclusive mode, tired compact and
repair and have found nothing online. Any help that you can give would be
great.


  #2  
Old July 19th, 2006, 08:50 PM posted to microsoft.public.access.tablesdbdesign
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Realtionship issue

At what point in the process do you get the error?

"Empxv" wrote:

I have a DB the has serveral realtionships currently in it is need to add one
more and I keep getting the error the I do not have delete premissions in
'MySysObjects'. I have opened the DB in exclusive mode, tired compact and
repair and have found nothing online. Any help that you can give would be
great.


  #3  
Old July 19th, 2006, 09:16 PM posted to microsoft.public.access.tablesdbdesign
Empxv
external usenet poster
 
Posts: 3
Default Realtionship issue

I can get to my relationship tabe. When I go to make any changes to the
current relationships is when I get this error. No matter what I try to do
ie add, delete, or change.



"Empxv" wrote:

I have a DB the has serveral realtionships currently in it is need to add one
more and I keep getting the error the I do not have delete premissions in
'MySysObjects'. I have opened the DB in exclusive mode, tired compact and
repair and have found nothing online. Any help that you can give would be
great.


  #4  
Old July 20th, 2006, 12:59 AM posted to microsoft.public.access.tablesdbdesign
John Vinson
external usenet poster
 
Posts: 4,033
Default Realtionship issue

On Wed, 19 Jul 2006 13:16:02 -0700, Empxv
wrote:

I can get to my relationship tabe. When I go to make any changes to the
current relationships is when I get this error. No matter what I try to do
ie add, delete, or change.


Sounds like your systems tables may be corrupt. I'd try creating a
new, empty database; import everything from this one; and try again
using the new database.

John W. Vinson[MVP]
  #5  
Old July 21st, 2006, 05:00 AM posted to microsoft.public.access.tablesdbdesign
Stephen Lebans
external usenet poster
 
Posts: 619
Default Realtionship issue

Do you buy chance have security setup on this MDB? If so make sure you are
logged on as the user was whom created the Relationship window layout in the
first place.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Empxv" wrote in message
...
I can get to my relationship tabe. When I go to make any changes to the
current relationships is when I get this error. No matter what I try to
do
ie add, delete, or change.



"Empxv" wrote:

I have a DB the has serveral realtionships currently in it is need to add
one
more and I keep getting the error the I do not have delete premissions in
'MySysObjects'. I have opened the DB in exclusive mode, tired compact
and
repair and have found nothing online. Any help that you can give would
be
great.




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query Corrupting Results??? Daniel Running & Setting Up Queries 6 April 17th, 2006 02:29 AM
Missing data-not sure if it is a relationship issue or query issue JudyT General Discussion 2 March 2nd, 2006 11:57 AM
Font list box issue Jeffrey Millar Powerpoint 9 February 4th, 2006 05:34 PM
Wrap Text issue jsAlpha General Discussion 2 January 5th, 2006 01:56 PM
Office 2003 on Win XP -hour glass issue -HELP! jonpdavies Setup, Installing & Configuration 0 December 11th, 2005 08:33 AM


All times are GMT +1. The time now is 11:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.