Upsizing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jsw - 26 Aug 2005 14:58 GMT

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

Reply to this Message

Sylvain Lafontaine - 26 Aug 2005 15:05 GMT

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.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

>I have upsized an Access database to an SQL database via the Access
>upsizing
[quoted text clipped - 19 lines]
> Thanks
> Jon

Reply to this Message

jsw - 26 Aug 2005 15:32 GMT

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

> Use the Refresh command (F5 or View --> Refresh) on both the Tables and the
> Queries window.
[quoted text clipped - 28 lines]
> > Thanks
> > Jon

Reply to this Message

Sylvain Lafontaine - 26 Aug 2005 15:47 GMT

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

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

> thanks.
> Just had a look and each table does have a primary key.
[quoted text clipped - 38 lines]
>> > Thanks
>> > Jon

Reply to this Message