Upsizing

[jsw]

I have upsized an Access database to an SQL database via the Access upsizing
wizard.
The first few times I did this all was ok (ie I could enter / edit data in
the SQL database via Access).
I then changed the original Access database (inserted some fields etc) and
used the upsizing wizard again.
This time all my tables seem to be locked. Sometimes the data is lost and I
just get the table headings, with no data and no boxes to enter the data.
Other times I get the data but no more blank data boxes to enter more data.
Usually 2 of the 4 tables loose their data and the other 2 tables keep
theirs. In each case however I can not enter any more data.
Just to add I can enter data directly into the sql database via the database
utility program stored on the main server, this can then be viewed correctly
via access on the other pc (but can not enter data).

Sorry for the long question but whats going on?
Thanks
Jon

 

[Sylvain Lafontaine]

Use the Refresh command (F5 or View --> Refresh) on both the Tables and the
Queries window.

The more commun cause with problem editing data is a missing primay key.
When the Select queries begin to be very complex, you must also set the
UniqueTable property and possibly the ResyncCommand too. There are other
possibilities, like problem with a Bit field; however, in your case, I will
first look into the possibility of a missing primary key.

 

[jsw]

thanks.
Just had a look and each table does have a primary key.
Ill look at the other points though.

 

[Sylvain Lafontaine]

What are you using, a MDB file with linked tables or an ADP Project?