Parameterized queries or not?

[Chip]

Hi,

I am trying to move several field values from one table to
another within my Access DB. I am currently opening a
recordset as the srcObj and another as the targetObj but
the targetObj is using a Command Object and parameters to
create the INSERT statements.

My question is on the Command Obj and Connection Object.
First can I create a CommandObject without a connection?
If not then when creating a connection I don't want to
reference the MDB file as a hard coded path as many of the
examples show for the ConnectionString. Any examples would
be greatly appreciated.

 

[Bryan Reich [MSFT]]

You can use
Application.CurrentDb.Name
to get the filename of the open database without hard coding a value in.
Hope this helps.