S
sindica
I am migrating the data source of an access project to sql server 2000.
I use link table. Everything else works fine except two forms.
Here is the situation:
1. A table called [tblRecords] has no key in the access db. I figured
out the field [ID] should be the key and it is a numeric field in
access. [ID] is an 11-bit integer. I transferred the database from
access to sql server, it was automatically changed to float type.
2. There are two forms those recordsources are based on table
[tblRecords]. Their sources are all of the data records from
[tblRecords]. And they are the only places that have problems.
The problem is:
After I search the records, I change some of the fields. I navigate to
other records. And I come back to the record that has been modified.
Sometimes it keeps the change, sometimes not.
My observance:
1. There is a ADO control at the bottom of the form. And there is a
number that indicate the position of the record in the control. If we
open the link table, we can also find a ADO control at the bottom of
the table.
2. Whenever the number in the control of the form is consistence with
the number in the table, the update is successful; otherwise, it is the
record located at the position indicated by the number that has been
changed.
3. I guess access remember the data modification and its position in
the table and change it.
4. But what I don't understand is why the recordsource of the form is
not ordered as indicated. A strange thing is that the data seems not
randomly sorted. Because there is a right position for a specified
record and a wrong position for it. And the wrong position keeps the
same in so many trials.
The former programmer sugguested me to manually update the records,
which means a lot of programming. It's the bottom line.
Any one has some idea? Can we force access to sort the records
correctly? Or can we force access update the records according to the
key field?
Thank you so much!
I use link table. Everything else works fine except two forms.
Here is the situation:
1. A table called [tblRecords] has no key in the access db. I figured
out the field [ID] should be the key and it is a numeric field in
access. [ID] is an 11-bit integer. I transferred the database from
access to sql server, it was automatically changed to float type.
2. There are two forms those recordsources are based on table
[tblRecords]. Their sources are all of the data records from
[tblRecords]. And they are the only places that have problems.
The problem is:
After I search the records, I change some of the fields. I navigate to
other records. And I come back to the record that has been modified.
Sometimes it keeps the change, sometimes not.
My observance:
1. There is a ADO control at the bottom of the form. And there is a
number that indicate the position of the record in the control. If we
open the link table, we can also find a ADO control at the bottom of
the table.
2. Whenever the number in the control of the form is consistence with
the number in the table, the update is successful; otherwise, it is the
record located at the position indicated by the number that has been
changed.
3. I guess access remember the data modification and its position in
the table and change it.
4. But what I don't understand is why the recordsource of the form is
not ordered as indicated. A strange thing is that the data seems not
randomly sorted. Because there is a right position for a specified
record and a wrong position for it. And the wrong position keeps the
same in so many trials.
The former programmer sugguested me to manually update the records,
which means a lot of programming. It's the bottom line.
Any one has some idea? Can we force access to sort the records
correctly? Or can we force access update the records according to the
key field?
Thank you so much!