split database not updating

  • Thread starter Thread starter William Kossack
  • Start date Start date
W

William Kossack

I have a split database (developed by someone else)

I've added a field to the database but the part that contains the forms
and queries does not want to update with the information in the tables
they are linked to.

ie I've added a field to a table in the database. when I look at the
table that is linked to the the table it does not contain the new field.

how do I transfer the fact that I've added a new field to the linked
table?
 
1. Use the Link Table Manager in the Menu Tools / Database Utilities ... to
re-link the Table.

2. If you use a Query as the RecordSource for the Form, you will need to
ensure that the Query includes the new Field. It is not updated
automatically unless you use the All Fields "*".

3. Form is not updated automatically either. You need to add a Control,
e.g. TextBox and then bind the new Control to the new Field.
 
I did that and it still does not know about the new field. I even pointed it to
the new location of the table where I'm trying to figure out why the database is
not working
 
WHICH step did you do?

and WHAT did you mean by "it"?

Remember I can't see what you did and rely on your description!

Do step 1 first then open the linked Table in DatasheetView and DesignView.
If you don't see the new Field, you either added the Field to another Table
in the right back-end /or the correct Table in another (wrong) copy of the
back-end /or both.
 
for starters I did step 1 and the linked table still does not show all the fields in
the database table
I also tried adding the field to one of the queries and it acts as if the database
does not exist.
As for number 3 I tried to add the new checkbox but the form does not show the new
field inorder to bind it
 
I did and it still does not work

I even created a new linked table to the table where I added the new field and
it still does not appear in the linked table
 
I tried what you suggested on a new table (created a new table, put some data
into it, then created a linked table in another database and put some data into
it) and it worked.

there appears to be a problem with the database that I'm working with. it has
been loosing records and dropping information
 
* Check and make sure you got the correct back-end. This happened to me
once before as I modified one copy of the back-end while the linked Tables
actually pointed to another copy of the back-end.

* Delete the existing linked Table and then use the Get External Data ...
command to re-create the linked Table.

* Try Repair & Compact the database and see if it helps (probably it
doesn't).

* Try creating a dummy Table with a few Fields in the Back-End. Go to the
Front-End and try creating a new linked Table to this dummy Table.
 
Try some of these:

* Repair & Compact both Back-End and Front-End?

* Create a new database. Import all Tables from the Back-End. Use this
new database as the Back-End to get rid of corruptions in the existing
Back-End.

* Create a new database. Import all objects from your existing Front-End
database except the linked Tables. Use Get External Data to re-create all
linked Tables. A new database with imported objects often get rid of the
corruptions in the Front-End.
 
got it figured out

I had copied the database into a directory about 5 levels down from root. I'm
wondering if access has a problem with long directory strings because things
just did not work correctly.

However, I looked at the original copy of the database and say that it was in
c:\database so I created a c:\database and copied the database and the forms
database into that folder.

Then I went through the long process of re-linking all the tables queries and
forms to the new location.

This time it worked and I was able to enter things into the form and have them
appear in the database.

The real problem I think is this database consists of some 30 tables with a real
rats nest of relationships.
 
Back
Top