Access error # 2335

[HNewt]

Access Error #2335

Access 2003. OS: Win XP Pro

For a client I have created a database to track customers details and purchases. I have designed a form for data entry, the form is tabbed, the first tab is Clients Details, the second is purchase details.

I have used one subforms to allow entry of date and amount, and to show the history of that client, the second subform is linked to a Query to show the total purchases for the client.

I have tested the database on my computers, it works as I wanted it to and have installed it on the clients peer server, where it is also fully functional, the same on another workstation.

The problem I am having is that the workstation that the data will be inputted from returns the error message when opening the form:

“You must use the same number of fields when you set the LinkChildFields and LinkMasterFields properties. You entered a different number of fields for one property than you did for the other.
If you use the Relationships command (Tools menu) to define a relationship between the tables underlying the form and subform, Microsoft Office Access will link the form and subform automatically and then set the LinkChildFields and LinkMasterFields properties.”

I have checked that the relationships are correct, I have uninstalled and reinstalled Office on the workstation but still receive the error message. I have double checked that the options are set identically for all the workstation, but I can not resolve the problem.

Has anyone experienced this problem before, or have any suggestion which route I should go down to cure the problem?

[MMcCarthy]

This is a new one to me. I would suggest the following checks.

1. Check the subform object and see what master and child fields are showing. Even if it looks correct hit the button with dots to the right and make sure the correct fields are available in the dropdown lists.

2. Check the library references on the problem computer and make sure that no libraries are marked as missing. Also check that the list corresponds to your own computer including version numbers.

3. Compile the database from the VBA editor and make sure no errors are appearing.

Mary

[HNewt]

This is a new one to me. I would suggest the following checks.

1. Check the subform object and see what master and child fields are showing. Even if it looks correct hit the button with dots to the right and make sure the correct fields are available in the dropdown lists.

2. Check the library references on the problem computer and make sure that no libraries are marked as missing. Also check that the list corresponds to your own computer including version numbers.

3. Compile the database from the VBA editor and make sure no errors are appearing.

Mary

Many thanks Mary for those suggestions. I have now checked out all of your suggestions and have turned up no problems, but the database still returns error # 2335. The machine is very new, Windows is correctly installed, all of the tools I use for checking the registry and virus / malware return a negative for any problems. I have even restored to a date that would have been before any input errors by the user coud have changed the setting of the program or the machine.
My next move will be to create a compleatly new database that can use the tables that have been created so far.

Many thanks again