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
> Primary Key And Splitting Database, Access 2010    
 
   
qwertnard
post Oct 29 2019, 04:01 PM
Post#1



Posts: 33
Joined: 3-April 08



I have a bunch of tables with various relationships. I try to split the database and I get "a primary key or index can't be null". I have checked all the primary keys and don't see a null values so it be a indexed field. Is it possible to find all indexed fields or find the error record automatically?
Go to the top of the page
 
theDBguy
post Oct 29 2019, 04:04 PM
Post#2


UA Moderator
Posts: 76,820
Joined: 19-June 07
From: SunnySandyEggo


Automatically? Depends. Where/When is the error happening?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
GroverParkGeorge
post Oct 29 2019, 04:36 PM
Post#3


UA Admin
Posts: 36,171
Joined: 20-June 02
From: Newcastle, WA


How did you split the accdb?

I also need to know when and where the error appears?
This post has been edited by GroverParkGeorge: Oct 29 2019, 04:37 PM

--------------------
My Real Name Is George. Grover Park Consulting is where I did business for 20 years.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
qwertnard
post Oct 29 2019, 05:05 PM
Post#4



Posts: 33
Joined: 3-April 08



I go through the database tools tab and split it there. It successfully creates a second file however the blue arrows are not on the front end. The back end only two of the four tables appear.
Go to the top of the page
 
PatHartman
post Nov 3 2019, 04:01 PM
Post#5



Posts: 71
Joined: 20-February 03
From: Stratford,Ct USA


Then open each of those tables in design view and open the indexes dialog. Look specifically at the columns that are part of any unique index.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    7th December 2019 - 01:27 AM