Re: Trouble with DAO "SEEK" in converting application to SQL Express back end.

"Larry Linson" <bouncer@xxxxxxxxxxxxx> wrote in
Vr_Wf.13970$VL2.5902@trnddc04:">news:Vr_Wf.13970$VL2.5902@trnddc04:

You have never been able to use dbOpenTable or Seek on anything
but native Jet tables in the same MDB/MDE. As far as I know, that
is well-documented.

Er, you mean in the same MDB as referenced by the database object
with which you created the recordset.

It's perfectly easy to open a different database that has the tables
in it, assign it to a db variable, and then open a table-type
recordset on it.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Object invalid or no longer set error involving database object. H
    ... hasn't been set correctly before attempting to open the recordset. ... routines where if I declare a dao database object then: ... The database object D ... access mdb backend. ...
    (microsoft.public.access.modulesdaovba)
  • (no subject)
    ... - LDB locking which a persistent recordset connection fixes ... New format of Access 2000 MDB ... Place backend MDB on the root of the network share rather than several folders down ... Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version. ...
    (comp.databases.ms-access)
  • Re: Object invalid or no longer set error involving database objec
    ... routines where if I declare a dao database object then: ... Here I get the Object invalid or no longer set error. ... access mdb backend. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Object invalid or no longer set error involving database object. H
    ... Here I get the Object invalid or no longer set error. ... The database object D ... access mdb backend. ...
    (microsoft.public.access.modulesdaovba)
  • Re: ADO, DAO, ADO objects like Connection and Recordset ETC.
    ... > Hi, i am creating a system where i want to connect to a database and ADD, ... > I have been adviused previously not to use the ado data control and use ... > Dim dbConsultant As Database 'declare the database object ... > Dim rsMySet As Recordset 'declare the recordset object ...
    (microsoft.public.vb.general.discussion)