Re: Are all records retrieved


<Rashapoo@xxxxxxxxx> wrote in message
news:1143152193.513882.319430@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thanks
I think I get what you said. I initially tested this with an
underlying table that had only 200 rows. In this case when I changed
the last record in DB1 and navigated to the same last record in Db2 I
did not see the change.
This must be because since table is small Access had loaded whole thing
into memory and the change on last record in Db1 wouldn't have impacted
the last record in Db2 which is being displayed from memory.

When I tried to repeat the test with a much larger table (this had 5K
rows), I got a failure at the get go. When I changed a column on DB1
and tried to get to the next record, I received a message "No current
record". Which seems to be because

"This error occurs after the unsuccessful application of one of the
Find methods or the Seek method, when the underlying Recordset contains
no records or the record has been deleted. Move to or select another
record, and try the operation again. If the Recordset is empty, you
cannot position to a current record. Check the BOF and EOF properties."

I guess I will find the answer to this in a different thread.

But, the gist of what you are saying is if there are a large number of
records in the underlying table then since all are not loaded into the
memory in Db2 (unlike the case with 200 records) when I navigate to the
last record it is retrieving this from the database thus showing me
what was updated in DB1.

Does this apply only to linked tables or also to tables that are in the
database?


The errors that you are getting do not sound normal. I would start a new
database, then import the old table into the new database and do a compact
and repair.
Apart from that, you seem to have understood exactly what I am saying -
although I don't have any precise facts or figures for you.
I used the example of linked tables, because that is generally the area of
concern. A multi-user database where you are worried if the data you see on
your screen matches what your colleague next door see on his. But the same
thing is true of local tables: you could show this by creating two forms
based on the same table, opening then at the same time and experimenting by
editing the records.


.

Relevant Pages

  • Re: Are all records retrieved
    ... the last record in DB1 and navigated to the same last record in Db2 I ... the last record in Db2 which is being displayed from memory. ... Find methods or the Seek method, when the underlying Recordset contains ...
    (comp.databases.ms-access)
  • Re: Another idea from pick goes mainstream...
    ... underlying database - when you buy a system from Reynolds & Reynolds, ... available is that "VAR X" is unlikely to use a case study that mentions ... even the database vendor promotes" ...
    (comp.databases.pick)
  • Re: Keep it alive
    ... Sub OpenPasswordProtectedDB() ... TSI SOON database add-in ... another db (let's call it db1), display the application window to the ... Because the database object is closed as soon as the memory used by db1 ...
    (microsoft.public.access.formscoding)
  • Re: Drilltrough Question
    ... not query the underlying relational database, ... that in AS2000 drilllthrough queries retrieved data from the underlying ... I could retrieve any column from any table in the ...
    (microsoft.public.sqlserver.olap)
  • Re: Link table from a secured database to another secured database
    ... but my boss didn't agree on it, coz the first database has been distributed ... >> user in the secured DB1. ... >> and I could open DB1 without asking for permissions! ... >Say user Tom exists in WG1 and has permissions to DB1. ...
    (microsoft.public.access.security)