Seek Method on Network

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have code like this:

Set rs1 = CurrentDb.OpenRecordset("MyTable")

rs1.Index = "MyCompositeIndex"
rs1.Seek "=", Field1, Field2, Field3

If Not rs1.NoMatch Then

' Calculations and Edits to fields are done here
..
..

End If

This all works fine on my stand-alone database. Now I've split the database
so it can run on the network and I get the error message:

Error 3251 Operation is not supported for this type of object.

So my question is, how do I seek - or find a record that satisfies a
composite group of criteria in a networked database. I need to get the
record and perform a number of calculations and then do an update to the
fields. Thanks for any help you can provide.
.

Relevant Pages

  • Re: Seek Method on Network
    ... As you found the Seek method doesn't work with attached tables: they open dbOpenDynaset instead of dbOpenTable. ... This all works fine on my stand-alone database. ... so it can run on the network and I get the error message: ... composite group of criteria in a networked database. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Requery on command button not working
    ... Are these calculations coming from "across the ... See http://www.QBuilt.com for all your database needs. ... >> The CPU is busy executing your request. ... >>> buttons the intention is to display the releveant data for that period. ...
    (microsoft.public.access.forms)
  • Re: why>?
    ... i haven't ever been asked to build a point of sale system in excel you ... Access is flexible enough to work with any existing database backend. ... people shouldln't have to be software developers? ... that sensible people who need to perform many calculations will try to ...
    (microsoft.public.excel)
  • Re: Financial modelling from Excel to Access
    ... A Database can handle efficiently a lot more rows than Excel, ... to do some time-phased calculations. ... I would suggest you consider an approach of storing the data in a database ... > of Access to Excel regarding financial modelling. ...
    (microsoft.public.excel.misc)
  • Re: considering learning Access
    ... The appropriate question is not "what kind of calculations?" ... *data* can a database perform calculations on? ... Access VBA has many built in functions and you can use those to also create your ... way to speed is up is to temporarily set the Excel calculation to ...
    (microsoft.public.access.gettingstarted)