adCmdTable

I dont think this parameter is so important! This is taken form Access help and we are looking at the Options parameter...

Parameters

Source  Optional. A Variant that evaluates to a valid Command object, an SQL statement, a table name, a stored procedure call, a URL, or the name of a file or Stream object containing a persistently stored Recordset.

ActiveConnection  Optional. Either a Variant that evaluates to a valid Connection object variable name, or a String that contains ConnectionString parameters.

CursorType  Optional. A CursorTypeEnum value that determines the type of cursor that the provider should use when opening the Recordset. The default value is adOpenForwardOnly.

LockType  Optional. A LockTypeEnum value that determines what type of locking (concurrency) the provider should use when opening the Recordset. The default value is adLockReadOnly.

Options  Optional. A Long value that indicates how the provider should evaluate the Source argument if it represents something other than a Command object, or that the Recordset should be restored from a file where it was previously saved. Can be one or more CommandTypeEnum or ExecuteOptionEnum values.

CommandTypeEnum = 2 (adCmdTable)
Evaluates CommandText as a table name whose columns are all returned by an internally generated SQL query.

soenderup are you there?

Jeg fandt svaret i MS-SQL books...

/sønderup