splitting db

  • Thread starter Thread starter ted medin
  • Start date Start date
T

ted medin

We split the db & now have problems.
Had to change all recordset with opentable to open dynaset.
However, now that we use dynaset seek no longer is available.
rstMember.Index = "sheet1mem#" was the first indication we had more trouble.
So what can one use in place of the seek method? TIA
 
So what can one use in place of the seek method? TIA
Click to expand...

SQL... use the WHERE clause and ORDER BY. Your network manager and your
other users will love you too.


HTH


Tim F
 
Findfirst worked just fine. Tnx
A further question. I tried to write code to run on both the dbopentable &
dbopendynaset. Tried this:
if rstMYobject.connection.type = vbopendynaset then ...

However, rstMYobject.connection.type always returned a 2. I was unable to
figure out how to return the vbopenTYPE
Bottom line is what is the syntax to return the vbopentype? TIA
 
Not sure why you would want/need code to run using both the dbOpenDynaset or
dbOpenTable method. Just use dbOpenDynaset all the time for this code.

As for determining whether a table is linked or not, you'd need to test the
Connect property of the TableDef that corresponds to the table; linked
tables have a string in the Connect property, while unlinked tables have no
value/string in the Connect property.

--

Ken Snell
<MS ACCESS MVP>
 
Ok thanks you have been a great help.

Ken Snell said:
Not sure why you would want/need code to run using both the dbOpenDynaset or
dbOpenTable method. Just use dbOpenDynaset all the time for this code.

As for determining whether a table is linked or not, you'd need to test the
Connect property of the TableDef that corresponds to the table; linked
tables have a string in the Connect property, while unlinked tables have no
value/string in the Connect property.
Click to expand...
 
Back
Top