cannot create relationship enforcing referential integrity

hey guys,

i just split my database and i'm having problems creating a relationship which enforces referential integrity. why is this so? referntial integrity
here's my database attached too guys

thanks guys!
Cerebro---SSB-Recon.zip
developingprogrammerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
You forgot the backend, but the reason is most likely that the foreign field contains data which don't have equivalent primary keys.

/gustav
0
developingprogrammerAuthor Commented:
thanks gustav! here is the BE.

i checked if the problem is because the FK doesn't have equivalent PKs but it's not the case.

here's what i tried:
objective - link perfCode.CodeID to perfContainer.FKCodeID using referential integrity
1) i deleted all records from both perfCode and perfContainer
2) i tried to create the relationship again
3) enforce referential integrity was still greyed out.
Cerebro---SSB-Recon-BE.zip
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'm able to create the referential links:
Relationship imageIf you can't do it, then be sure your machine has all updates for both Windows and Office. Also, I sometimes find it necessary to restart the machine. I think it gets "confused" sometimes :)
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Jeffrey CoachmanMIS LiasonCommented:
Also make sure you are running the compact repair utility after each "Design/Editing Session" of the DB's.
0
developingprogrammerAuthor Commented:
thanks LSMConsulting and boag2000!

boag2000 i read your guidelines on how to post databases - apologies for that! will reply that question later on.

ok guys, i've confirmed the issue already.

Problems:
1) if i'm in the FE, i cannot create a relationship between 2 tables in the BE using RI
2) if i'm in the FE, i cannot create a relationship between 1 table in the BE and one table in the FE using RI

However:
1) if i'm in the BE, i CAN create a relationship between 2 tables in the BE using RI.

so essentially i have to be in the database where the tables are located to create the relationship using RI.

AFTER doing so in the BE, it is reflected in the relationship diagram in the FE.

HOWEVER, sometimes i want to create RI relationship between a table in the FE and a table in the BE. it seems impossible. perhaps rightly so cause - what if the network connection is lost?

at least these are my findings. i've attached the 2 test databases here in the zip file i used to play around with.
FE-BE-Referential-Integrity.zip
0
Gustav BrockCIOCommented:
> so essentially i have to be in the database where the tables are located
> to create the relationship using RI.

No. You can easily open a database from another and create/modify relations and RI via code.

> .. sometimes i want to create RI relationship between a table in the FE and
> a table in the BE. it seems impossible.

Yes.

/gustav
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
developingprogrammerAuthor Commented:
Ah I see cool gustav! But I MUST do it via code right? I know how to open a database from another using code = ) was just hoping that I could do it via the linked tables and the relationships UI
0
Gustav BrockCIOCommented:
No GUI. But using is much more fun!

/gustav
0
developingprogrammerAuthor Commented:
ha i see, thanks gustav for confirming this! appreciate it a lot!! = )
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.