Results 1 to 2 of 2
Thread: Sub Datasheet link lost (2003)
2008-08-22, 23:54 #1
- Join Date
- Jan 2001
- Warrington, Cheshire, England
- Thanked 0 Times in 0 Posts
Sub Datasheet link lost (2003)
Something that's been done to a DB during development has caused the sub datasheet link between two tables to be lost.
The two tables are still there and have not been renamed. A field has been moved from EmployeeDetail table to Salary table and the original field deleted from EmployeeDetail.
At the end of this part of the development, the link is still there; opening EmployeeDetail and then clicking on the plus sign shows the associated Salary info.
Post this, there have been changes to queries, but I can't see how this can affect the datasheet/subdatasheet link. What sort of thing could I have done to cause the link to disappear?
(I know it's simple to remake the link when I am prompted by Access - but I would like to know what I've done to make it disappear)
2008-08-23, 00:04 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Sub Datasheet link lost (2003)
I have no idea, but I'd recommend turning off subdatasheets. They can have unexpected effects and have a negative impact on performance. See the 'Tables: SubdatasheetName' section in Allen Browne's Microsoft Access Flaws - Problem properties.