I have one user out of 30 that is displaying incorrect information in
one subform. The database is split. The data is in an Access database
on the server and the front ends are on each workstation. It's all
Access (No SQLServer, Oracle, etc.).

When she pulls up the subform, the information is incorrect. If I go
straight to the linked table on her database, the information is
correct.

I've repaired, reinstalled, run chkdsk, to no avail. What is wrong
with this PC??

On Jul 25, 10:45*am, musicloverlch <lho... (AT) gmail (DOT) com> wrote:
What do you mean by incorrect information? Too few records, to many
records, no records, grabbing data from another table?

On some event in the main form you could enter something similar to
MsgBox "Child " & Me.YourSubFormName.LinkChildFields & " " & _
"Master: " & Me.YourSubFormName.LinkMasterFields
Change "YourSubFormName" to the subform name you use. Maybe put in a
dbl-click event in some control on the mainform to test. Are the link
fields expected?

Well, it is displaying data, but I have no idea where it's getting it
from. The info is from the correct table, but the wrong info. They
are linked by a internal databse identifier called GA_Record_ID.







On Jul 25, 11:39*am, Patrick Finucane <patrickfinucan... (AT) gmail (DOT) com>
wrote:

On 25/07/2011 23:34:13, musicloverlch wrote:
Are you positive the correct tables are linked. Check the connect strings
point to your server. Phil

"musicloverlch" <lhowey (AT) gmail (DOT) com> skrev i en meddelelse
news:c589dd86-4716-4678-9f8d-782a233878d0 (AT) s17g2000yqs (DOT) googlegroups.com...
Have you tried to replace the Front-end database on hers computer, with a
copy from your computer?



How do they connect to the Back-end database, manual or from a
function/procedure build in your program?



Have you tried to remove all linked tables, (break the chain) from the
Front-end database and reconnect all the tables again?



Jørn

The front end has been replaced multiple times.
The tables are permanently linked.

I guess I could try unlinking and relinking the table on her PC.




On Jul 26, 1:07*am, "JHB" <jhb... (AT) hotmail (DOT) com> wrote: