Access 2007 - Recordset not updateable after splitting

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

Hello -

I created a database in Access 2007 and used the database splitter. I put
the backend on a shared network drive. I can see the tables via the Linked
Table Manager.

My Front end is called Variance.accdb
My BackEnd is called Variance_be.accdb.

However, the fields on the forms on my front end are now not updateable. I
checked form properties and there are no locks. Allow Edits is set to yes,
Recordset Type is Dynaset

Not sure where to go from here - Any help appreciated!
Sandra
 
Check in the recordsource of your form whether the query contains formulas,
functions, and/or calculated fields.
If so, remove this particular field temporarily from the query and see
whether the form (and it's recordsource) is updatable.
Check other fields as well.

If this is the case, you will have to think about altering your datamodell
to facilitate this particular field (these particular fields) or
have the field(s) be calculated on the form.

Krgrds,
Perry
 
Thank you Perry :-)

There were no calcualtions in the query but when I removed one of the tables
from my query it took care of the issue. I will just do a DLookup for that
data within the form.

Have a great day!
sandra
 
Back
Top