Topics Search

dbSeeChanges Run-time error 3622

dbSeeChanges Run-time error 3622
Views: 149
I'm getting an error : A new error has occured. Run-time error 3622

"You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column."

I've tried adding dbSeeChanges (in red below), but I then get an Invalid Argument Error.

Can anyone tell me where I'm going wrong. Thanks.

Dim rs As ADODB.Recordset
Lot = """" & Me.Lot.Value & """"
SQL = "Select * from dbo_WipDevStatus where Lot = " & Lot & ""
Set rs = CurrentDb.OpenRecordset(SQL, dbSeeChanges)
Sponsored Links:

Similar posts...


You Must use dbseechanges option with openrecordset Error

You Must use dbseechanges option with openrecordset Error Icon
I am trying to run queries in other databases by using the following code:

'Opening the Database Set db = DBEngine.Workspaces(0).OpenDatabase("C:\Test\Test12\Testdb.mdb") 'Running specified queries db.Execute "qry_try_This", dbFailOnError Set db = Nothing

But I keep getting the error of:
Run time error 3622
You must use dbseechanges option with openRecordset option when accessing a SQL server table that has an Identity column

I am by far a beginner using DAO, and am not sure what exactly is causing this error, or how to correct it

Error #3622 After Migrating my Database

Error #3622 After Migrating my Database Icon
I successfully (I think) migrated my Access 2007 db to MSSQL Server 2008R2 but I am getting error #3622 "You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column." when I try to run the following code:

Set rsCompany = dbs.OpenRecordset("SELECT * FROM [Company Information] WHERE CompanyDefaultLocation Like 'Yes'")

Do you know what is causing this? I get a similar error with the following lines of code:

Set rs = CurrentDb.OpenRecordset("SELECT * From Contacts WHERE ContactCompany =""" & Me.Client & """") and Set rsLoginAttempt = db.OpenRecordset("LoginAttempt")

I don't see a pattern to know what I need to change.

I do not get the error when I run the code:

Set rs = db.OpenRecordset("SELECT * FROM Employee WHERE EmployeeUserName =""" & EnteredUserName & """") and
Set rstProjectName = dbs.OpenRecordset("Project File")

What is the dbSeeChanges option that is referred to in the error message

dbSeeChanges error on search form

dbSeeChanges error on search form Icon
I have a form which acts as a search form to find records within the database.

The database was created in access but has since had the table upsized to SQL 2005. The Search Form was working but now I get the following error displayed.

You must see the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column.

The debugger takes me the the following lines of code.

Set db = CurrentDb
Set rcd = db.OpenRecordset("select " & _
"IT_SupportTable.LogNumber " & _
"FROM IT_SupportTable" & _
" WHERE " & strWhere & ";")

Can anyone help me with where I should be putting the dbSeeChanges

using dbSeeChanges

using dbSeeChanges Icon
I have had to upsize an Access 2003 BE to SQL Server 2005. This means for each table in SQL Server that has an IDENTITY field I will need to add the optional parameter dbSeeChanges to each recordset used.
What I would like to know is, does it matter if I use the dbSeeChanges option on tables that don't have an IDENTITY field?
Also can it be used on local access tables?

The reason I ask is that it is easier to change all OpenRecordset commands than just the ones that use the IDENTITY field.

Sending Outlook E-mail - Run-time error '429'

Sending Outlook E-mail - Run-time error '429' Icon
I copy and pasted this code from another one of my DBs that was executing it just fine. Now I get run-time error 429. I do have MS Office 2010. However, I had Excel 2003 installed on my machine because some of our software is only compatible with 2003. Ever since then I've been getting this run-time error. I have all the libraries referenced. Does anyone have a solution for this?

ODBC Error 3146 on rs.update

ODBC Error 3146 on rs.update Icon
Using MS Access, I have a form that is based on a table called Motion_Imagery. In the VBA of this code I want to take two fields on the form and add the data in those two fields to the last record that was added to table Online_Books. When I run my code I get the error when it gets to rs.update, here is my code:

Set db = CurrentDb()
Set rs = db.OpenRecordset("dbo_Filestream_Files", dbOpenDynaset, dbSeeChanges)


rs![Prefix_CTRL_NBR] = Me.Prefix_CTRL_NBR

Error "Run-time error '1004': General ODBC Error

Error "Run-time error '1004': General ODBC Error Icon
I'm having trouble running a file that I run weekly, when running the update query I receive error message: "Run-time error '1004': General ODBC Error

When I run debug, it fails at the 2nd line of code below:

My excel links the CCL data from Access via the below details and from what I know, nothing has changed. I've googled the error and it seems to mention an awful lot that there could be a problem with the link but I'm very inexperienced with Access and not quite sure where I should be looking.

Adding a new record with VBA

Adding a new record with VBA Icon
I am trying to add a new record using the following code

Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("dbo_TimeTracker", dbOpenDynaset, dbSeeChanges)

With rs
!IIDI_Major_ID = Me.IIDI_Major_ID
!Time = Me.Time
!Status = Me.Status
!Notes = Me.Notes
!UserID = CurrentUser()

End With

Now the problem I'm getting is that I get a runtime error # 3146 ODBC call failed error message and is highlighting the .Update part of the code The strange part is that the above table is updated with the new record?

Run-time error-214735267 (80020009)

Run-time error-214735267 (80020009) Icon
Run-time error-214735267 (80020009)
You can't assign a value to this object.

That is the error message I am getting for attempting to increase the value of a field when another field is true.

And now, I am getting the error:
"Run-time error '2465'

Microsoft Office Access can't find the field ' ' referred to in your expression."

The space between the apostrophes is for a symbol that I cannot find outside of the box. It is a straight vertical line.

Run Time Error 1004

Run Time Error 1004 Icon
I have code which outputs data into Excel on to separate sheets, I have also been asked now to give a combined sheet and every now and again I come up against Run Time Error 1004, I believethis is due to copy and pasting to many times, but when I am running the code it is only being run 4 or 5 times at the moment.

I am not sure what to add in to prevent the error from happening.

The extract of code is shown below.