New data not available in the form after splitting the database

[Armagnac68]

Hi,

I created a database in Access 2010 to store detailed data about jobs and entered all the relationships. I then created tabbed forms to allow entry of new records and alterations/updates/additions to existing job files.

The forms worked exactly as required, allowing new job entries and allowing searching of records by job number while it was on my PC. It was when I split the database that the problems occurred.

The form still allows entry of new records and stores the information in the back end database on the server. But the form cannot 'see' any of the new records that are in the tables, even though they were entered through the form. It still shows the same number of records that I placed in the tables when it was on my PC.

I am sure I am missing something obvious, but am new to Access and can't figure what it is. :banghead:

 

[jzwp22]

After you split the database, did you move the backend file that was created to the server? Did you relink the front end to the backend at it's new location?

 

[rctjoe24]

Did you relink the front end to the backend at it's new location?

I would ensure all your tables are linked correctly to your backend. Remember if you copied your backend to another directory you have to be sure the linked tables are updated to reflect the new location otherwise you're still adding tables to the wrong backend.

Use the linked table manager function to view the table links and update where necessary.