Set rs = CurrentDb.OpenRecordset("PricingSelling", dbOpenTable)
which appears to be a crash of some description. The only difference between my setup and the example is the table i'm trying to open is a linked table and the table exists as a sharepoint list
To investigate further i made a local table copy of the sharepoint list linked table and i don't get this error, so i'm guessing opening a table as a recordset doesn't work with linked sharepoint lists
apologies for drip feeding information as i didn't know there would be an issue with where the table resided/whether the table was linked or local
With the local table though i get the next error:
So this goes back to an understanding about what the following line does:
Code:
.Index = "srch_index"
@arnelgp any pointers/ideas would be gratefully received
delving a bit deeper as i go, the fundamental bit i'm not getting is where "src_index" is set because i can see it is an index of the table, but i can't see where it is defined.
i get what the line is doing now it is telling the recordset which index to use and when i look at the indexes it shows ID and srch_index
delving a bit deeper as i go, the fundamental bit i'm not getting is where "src_index" is set because i can see it is an index of the table, but i can't see where it is defined.
i get what the line is doing now it is telling the recordset which index to use and when i look at the indexes it shows ID and srch_index
ok so i see what to do now, not sure it helps because my table is a linked table but still at least i know where it was setup, goodness that was bugging me that i couldn't find where it was configured
i have not worked with sharepoint before but
if you can Open the backend and add it to the
database collection, then you can open the table
using OpenTable.
Public Function GetBE() as dao.database
static db as dao.database
if (db is nothing) then
set db=dbengine.workspace(0).opendatabase("thepathtodb")
end if
set GETBE=db
end sub