Subdatasheets not linking correctly

[Guest]

I have a split Access 2003 database that I use for keeping a log of changes
that I make to the different database I work on.
3 Tables - tblDatabase, tblVersion and tblChange each has a primary key that
is used as the link to the subordinate table. I have setup relationships to
this effect with referential integrity enforced.

Whilst I do not normally use (or recommend) subdatasheets they suit my needs
for this application, so I have set these properties up on the tables too.
When I open the back-end database I can open the Database table, drill-down
to the Version table (using '+') and drill-down again to the change table.
However when I link these tables to the front-end, the first drill-down
between database and Version works fine, but there is no '+' to enable me to
drill down to the Change table.

I used to have this working, it was only when I tweaked the sort order on
the Version table that I started having problems. I have removed all sort
orders on the tables, but to no avail. What is frustrating is that it works
on the back-end but breaks when linked to the front-end, yet supposedly all
the table properties are read-only and cannot be modified from the front end.

Any suggestions appreciated.

Peter Schmidt
Ross-on-Wye, UK

 

[Guest]

I solved the problem by deleting the relationships and subdatasheet
properties from the tables in the back-end and then opening the tables and
using Insert>SubDatasheet from the menus and letting Access create the
relationships again itself. I then edited the relationships to add
referential integrity. Looking at the table properties I cannot see anything
different to what I had typed in there before so maybe there was a slight
corruption??? I had tried running a repair before. Ho hum!

 

[Pieter Wijnen]

Using the SubDataSheet feature is not recommended see
http://allenbrowne.com/bug-09.html
for this & related issues

Pieter