I trying to acces by a recordset on my table and that doesn't function. it say to me
run-time error '3001':

invalid argument.

my source code is


Dim rstTMP1 As New Recordset 'table TransfertInscTMP1
Dim NewEmail As String
Dim NewWorkPhone As String
Dim NewFaxNumber As String

Set rstTMP1 = CurrentDb.OpenRecordset("TransfertInscTMP1", dbOpenDynaset) 'the place that doesn't run

thanks for your help

Hi,
Did you try repair funtion(tools > database utilities > compact and repair)? Maybe it can help.

On the other hand I think there is missing return reference to current database...

Set dbs = CurrentDb command


Attila