Editing a split database

[cwrockloff]

I recently split a database and distributed the front end to the users of the database (only two people). I had to change only the name of two different fields in the database. This is the process I used to change it:



On the backend I edited the names of the existing fields, and saved.

On the front end: On the form that includes these fields, I removed the previous field and re-added the field with the updated name

I am still receiving the attached error message asking for a parameter value for each of the OLD field names.

How do I get rid of these parameter value errors??

[davegri]

If the form recordsource is a query, it probably will still be looking for the old table field names.

[ssanfu]

You might also have to refresh the links to get the updated field names. (don't remember about Access, but I have to in SQLS Express)

In the menu:
EXTERNAL DATA/Linked Table Manager
Click Select All (you can only select the table where the fields were renamed, but I always select all)
Click OK

Open the linked table where the fields were renamed. Are they correct now?