users update front end

[ALands]

After splitting my database in access 2007 - the users can insert a new
record and update - but when i check to verify if the new records displays in
the table on the back end, the new record is not there and the users cannot
see the new entries made by different users. Why, did i do something wrong
when i split the database?

 

[Golfinray]

The tables that the users see in the FE should be linked to the actual tables
in the BE, and I'm sure they are. Therefore, if the users are using forms to
update tables they should be updating. Is a query the recordsource of the
forms or is the tables the recordsource? If the queries are the recordsource,
you would be updating the queries but not the tables. You could then run
update queries to update the tables from the queries.

 

[John W. Vinson]

The tables that the users see in the FE should be linked to the actual tables
in the BE, and I'm sure they are. Therefore, if the users are using forms to
update tables they should be updating. Is a query the recordsource of the
forms or is the tables the recordsource? If the queries are the recordsource,
you would be updating the queries but not the tables. You could then run
update queries to update the tables from the queries.

You're mistaken, Golfinray. Queries have no independent existance! If you
update a Query you are updating the table or tables which comprise the query.

 

[John W. Vinson]

After splitting my database in access 2007 - the users can insert a new
record and update - but when i check to verify if the new records displays in
the table on the back end, the new record is not there and the users cannot
see the new entries made by different users. Why, did i do something wrong
when i split the database?

My guess is that the database wasn't in fact split, or not split completely.
Open the Tables window - do the table names have a little arrow icon next to
them (indicating that they are linked)? If not then they are local tables, and
each user will have their own independent copy.

You can also hover the mouse over the tablename and see the "Connect" string
appear - this should show the name of the backend. if it doesn't... you're not
split correctly.