Hi,

Adding fields to database, if I use the Stand-alone Recordsets, which
appends fields to the Fields collection, and finally open it:

rs.Fields.Append "FirstName" ,adChar,50
rs.Fields.Append "LastName" ,adChar,50
rs.Open

The problem is I do not know how to a associate the added Fields collection
to the "Employees" table I want to create.

I tried: rs.Open "Employees", cnn,adOpenStatic, adLockOptimistic
and get error ---->[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'Employees'. Make sure it exists and that its name is spelled correctly.

Please show me the syntax

Thanks