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

"Sandy" <(E-Mail Removed)> schreef in bericht
newsCD42030-A7F5-4FA9-97D7-(E-Mail Removed)...
> 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

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


"perry" wrote:

> 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
>
> "Sandy" <(E-Mail Removed)> schreef in bericht
> newsCD42030-A7F5-4FA9-97D7-(E-Mail Removed)...
> > 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
>