Linking FE to BE with 1 to 1 table relation ship

[ablom]

My app is split into the classic FE and BE. Data tables are in two mdb's and the app is another. One of the main forms on the App is tied to a form by a query that links two tables in a 1 to 1 relation ship. For Business reasons the 1 -1 needs to be maintained. When the User is on the machine with the data mdb's and the App(the "Master" FE) they can add new records delete them etc. Both sides of the 1-1 tables get updated ( via code in the afterupdate of the form ).

My problem is that when a client machine connects to the data on the "master machine" over a lan the right hand side of the 1-1 table does not get updated thus causeing the tables to get out of synch. It will make a record in the left hand side of the 1-1 but not the right.

When the client, or Master, for that matter starts up I have code that checks the links to the data mdb's ensureing that they are there.

Using msAccess 97

Any ideas greatly appreciated.

 

[PHV]

Does access recognize the PrimaryKey of each linked table ?
Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ablom]

Thanks for the White Paper info.

I am embarrased to say that the problem was that when I installed the FE on a client machine the right hand side table of the 1-1 was NOT getting linked to the correct ( i.e backend) data file. So the required tables were never being joined.

Alls well that ends well. Appreciate the help.

Ablom