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: 99
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: 8


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: 1


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 Office 365 on Win 10 & Office 2007 on Win XP
Go to the top of the page
 
DanielPineault
post Nov 27 2017, 01:50 PM
Post#2


UtterAccess VIP
Posts: 5,867
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 ...(you are responsible for your choices and actions)
Go to the top of the page
 
GroverParkGeorge
post Nov 27 2017, 01:50 PM
Post#3


UA Admin
Posts: 32,393
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.

--------------------
My Name Is George and I believe in Karma
How to Ask a Good Question
Beginning SQL Server
Visit My Blog on Facebook
Go to the top of the page
 
JenniferMurphy
post Nov 27 2017, 03:00 PM
Post#4



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


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

--------------------
Using Office 365 on Win 10 & Office 2007 on Win XP
Go to the top of the page
 
JenniferMurphy
post Nov 27 2017, 03:01 PM
Post#5



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


Thanks, GPG.

--------------------
Using Office 365 on Win 10 & Office 2007 on Win XP
Go to the top of the page
 
DanielPineault
post Nov 28 2017, 09:00 AM
Post#6


UtterAccess VIP
Posts: 5,867
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 ...(you are responsible for your choices and actions)
Go to the top of the page
 
JenniferMurphy
post Nov 30 2017, 02:07 PM
Post#7



Posts: 99
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 Office 365 on Win 10 & Office 2007 on Win XP
Go to the top of the page
 
« Next Oldest· Access Errors + Error Handling· Next Newest »
 
Display Mode: Standard · Switch to: · Switch to: Outline

Track this topic ·Email this topic · Print this topic · Subscribe to this forum

Custom Search
RSSSearch   Top   Lo-Fi    23rd April 2018 - 10:13 AM