Defining a TableDef and seeting to a recordset

[Miked]

Hi:

I'm a newbie and need some conceptual help on this. You'll see my
other posts as flailing around on this group. Basically, I need to
create a recordset (which is the way I want to handle my primary data
in my VBA code) and then populate that recordset. I can't see to
figure it out!

I've create creatina tabledef; I'm able to set the tabledef, but then
I can set the recordset open to that. Do I need to add my data to the
tabledef before I do that? Or is there a way to add the data directly
to the recordset?

Thank so much in advance!

Miked

 

[Tony Jollans]

Hi Miked,

See my answer to your other post, but also - TableDefs and Recordsets are
Access constructs. If you are working with Access you would probably be
better asking these questions in an Access newsgroup.