Re: Semi-unable to add new records to table--primary key needed?

On 12/22/19 4:02 PM, Boylan, Ross wrote:

>> 5) At this point it seems your data is going to live in two worlds and
> in the end it will fall on you to maintain the integrity between the worlds.
>
> That's what I'm afraid of.
>
> The data itself lives only on the backend, but information about it lives in both places.

To make things more interesting table relationships can be hidden in the
Relations tab:

"On the Design tab, in the Relationships group, click All Relationships.

This displays all of the defined relationships in your database. Note
that hidden tables (tables for which the Hidden check box in the table's
Properties dialog box is selected) and their relationships will not be
shown unless the Show Hidden Objects check box is selected in the
Navigation Options dialog box."

>
> I'm not sure that the relationship synchronization issue is limited to cases with a server backend. Even the file based data, managed directly by Access, has foreign key relations in it (I'm pretty sure), and those too could be out of sync with the Relation objects describing that same data.

Pretty sure that FK's show up in the Relations tab as:

" If you enforce referential integrity for this relationship, the line
appears thicker at each end. In addition, the number 1 appears over the
thick portion of the line on one side of the relationship, and the
infinity symbol (∞) appears over the thick portion of the line on the
other side."

>
> I also probably need a better understanding of when operations happen in Access SQL vs being passed through to the server.

Yeah.

The Postgres side can be dealt with by looking at the server log. You
can also enable the ODBC logging, though right now I cannot remember how
to do that.

Don't know how you would do that for the internal Access side of things.

>
> Ross
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com