UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Error: Data Integrity Rules Have Been Changed, Access 2007    
 
   
JenniferMurphy
post Nov 27 2017, 01:22 PM
Post#1



Posts: 97
Joined: 1-May 14
From: Silicon Valley


I was working on a new database. I needed a lookup table for the 2-letter state codes, so I did a search and found this one:

Attached File  States.ZIP ( 8.11K )Number of downloads: 6


I needed to change the field names to match my style. Then I added am autonum field, canceled the existing primary key, and made the new field the PK, I got this error:

Attached File  Access_20171127_Error__Data_integrity_rules_have_been_changed.jpg ( 27.58K )Number of downloads: 0


The solutions I found online involve scary things like registry changes. Can I ignore this error? Do I need to do something? Did I do something wrong?

I can easily delete the table and create a new one from scratch.

Thanks

--------------------
Using Access 2007 on Windows XP
Go to the top of the page
 
DanielPineault
post Nov 27 2017, 01:50 PM
Post#2


UtterAccess VIP
Posts: 5,446
Joined: 30-June 11



All it is saying you have change indexes and required fields and asking if you want to retest the existing data to ensure it meets the new criteria or simply ignore compliance for existing records.

Normally, you simply click yes to ensure everything is good, but you can choose to skip it.

If you're paranoid about it, simply make a backup copy and then make the changes. If ever you aren't happy, you just revert to your backup copy.

Whatever you do, there is absolutely no need to mess with your registry because of this!

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page
 
GroverParkGeorge
post Nov 27 2017, 01:50 PM
Post#3


UA Admin
Posts: 31,195
Joined: 20-June 02
From: Newcastle, WA


Based on what I see, you should be able to just save it and move it. It's probably related to removing the Primary Key designation from the "States" field.

--------------------
Go to the top of the page
 
JenniferMurphy
post Nov 27 2017, 03:00 PM
Post#4



Posts: 97
Joined: 1-May 14
From: Silicon Valley


Thanks, Daniel. I clicked Yes and everything seems to be OK.

--------------------
Using Access 2007 on Windows XP
Go to the top of the page
 
JenniferMurphy
post Nov 27 2017, 03:01 PM
Post#5



Posts: 97
Joined: 1-May 14
From: Silicon Valley


Thanks, GPG.

--------------------
Using Access 2007 on Windows XP
Go to the top of the page
 
DanielPineault
post Nov 28 2017, 09:00 AM
Post#6


UtterAccess VIP
Posts: 5,446
Joined: 30-June 11



Glad to hear you got it all sorted out.

Just remember, quite often, a quick backup is your best strategy.

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page
 
JenniferMurphy
post Nov 30 2017, 02:07 PM
Post#7



Posts: 97
Joined: 1-May 14
From: Silicon Valley


QUOTE
Glad to hear you got it all sorted out.

Just remember, quite often, a quick backup is your best strategy.

Agreed. I subscribe to a backup system that makes file backups to the cloud continuously throughout the day and keeps several versions. And I make a dated copy of any file just before any non-trivial changes. Then I take a mirror image backup at least once a week.

Thanks, Daniel

--------------------
Using Access 2007 on Windows XP
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    11th December 2017 - 02:07 PM