473,326 Members | 2,134 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Error 3622 Open SQL Server Table with Identity Column

133 100+
I'm having issues attempting to open a Microsoft SQL table, where the same code has been used in the past without any issues. The error is "Error 3622 Open SQL Server Table with Identity Column." Any assistance would be greatly appreciated.

Expand|Select|Wrap|Line Numbers
  1.     Dim dbs As DAO.Database
  2.     Dim rst_AllText_Credits As DAO.Recordset
  3.     Dim rst_AllText_SQL_Format_Compare_SQL_Table_Credit_Memo  As DAO.Recordset
  4.     Set dbs = CurrentDb()
  5.  
  6.     Set rst_AllText_Credits = CurrentDb.OpenRecordset("Credit_Memo")
  7.     rst_AllText_Credits.MoveFirst
  8.  
  9.     If rst_AllText_Credits.EOF = False Then
  10.         rst_AllText_Credits.Close
  11.  
  12.     ''' Else
  13.  
  14.     ' make sure the all text credits are within the sql marketplace database credit table
  15.         Call sql_mke_tbl_Credit_Memo_sql_format
  16.         Call sql_Match_Credits_to_SQL
  17.  
  18.         Set rst_AllText_SQL_Format_Compare_SQL_Table_Credit_Memo = CurrentDb.OpenRecordset("sql_Match_Credits_to_SQL")
  19.         rst_AllText_SQL_Format_Compare_SQL_Table_Credit_Memo.MoveFirst
  20.         If rst_AllText_SQL_Format_Compare_SQL_Table_Credit_Memo.EOF = True Then
  21.             'delete all text recs
  22.             '    Call sql_Delete_Credit_Memo_Records
  23.             '    DoCmd.SetWarnings (False)
  24.             '        DoCmd.OpenQuery "sql_Delete_Credit_Memo_Records", acViewNormal, acEdit
  25.             '    DoCmd.SetWarnings (True)
  26.         Else
  27.             ' gets reprocess to sql
  28.         End If
  29.         rst_AllText_SQL_Format_Compare_SQL_Table_Credit_Memo.Close
  30.     End If
  31.  
  32.  
Aug 20 '14 #1
3 2609
zmbd
5,501 Expert Mod 4TB
Something sounds glitched in the frontend.
Open a new blank frontend.
Copy all of your objects/code over to the new front end.
Re-create your linked tables (if any).
(^_^)
Aug 20 '14 #2
jforbes
1,107 Expert 1GB
I’ve run into this after moving tables out of MS Access and into SQL, then using ODBC to connect to the moved table. Here is a link to Microsoft’s KB Article that describes the error you are getting:
http://support.microsoft.com/kb/190620

It’s saying you need to tweak your openRecordset Statements and your Execute statements to use dbSeeChanges as an option:
Expand|Select|Wrap|Line Numbers
  1. 6.     Set rst_AllText_Credits = CurrentDb.OpenRecordset("Credit_Memo")
  2.  
To
Expand|Select|Wrap|Line Numbers
  1. 6.     Set rst_AllText_Credits = CurrentDb.OpenRecordset("Credit_Memo" , dbOpenDynaset, dbSeeChanges)
Again, you’ll probably need to look for Execute statements and update them also. This is from some code in house, but it was changed from:
Expand|Select|Wrap|Line Numbers
  1. dbLocal.Execute sSQL, dbFailOnError
To
Expand|Select|Wrap|Line Numbers
  1. dbLocal.Execute sSQL, dbFailOnError + dbSeeChanges
Aug 21 '14 #3
zmbd
5,501 Expert Mod 4TB
That was my intial thought; however, as noted there's usually an execute statement involved and I'm seeing that in the posted code and dowlingm85 stated that the code has been working in the past; hence my suggestion to rebuild the frontend.

dowlingm815
Place a STOP command between lines 3 and 4.
Once the debugger starts, [F8] thru the code and let us know when the error triggers.

I am still in the your-front-end-is-tweeked-camp.

Please let us know what works.
Aug 21 '14 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Gunnar Vøyenli | last post by:
Hi (SQL Server 2000) I have an existing table (t) with a column that is NOT an identity column (t.ID), but it has manually inserted "row numbers". I want to make this column become an identity...
2
by: Dave | last post by:
I cannot insert into my appointments table because the primary key and identity column, appt_id, cannot be added. What do I have to change in my SQL statement to add new records into this table? I'm...
2
by: JJA | last post by:
I have fixed length records (167 bytes) in a .txt file and want to load this data exactly as is into a staging table where I hope to be able to later get at selected columns using the SUBSTRING...
2
by: valerio | last post by:
Hi all, I've some problem to import data to DB2 using the db2move and db2look tools. Follow the problem : I have exported data from db2 v. 7 database on windows server, using the db2look and...
3
by: mal_k100 | last post by:
Hi All, 1. Created table in SQL Server 2K with Primary key as int Identity 2. Link to table in MS Access 2K 3. Using form in MSAccess to update the linked table I want SQL server to...
2
by: WhiteEagl | last post by:
Hello, I would need some help with this identity column problem in SQLServer. I have a database with two tables. The Parent table has an Identity column. Parent (ParentID IDENTITY, Name)...
2
by: .Net Newbie | last post by:
Hello, I am somewhat new to .Net and currently working on an intranet site using C# going against SQL Server 2k. I am accepting personal information on a single webform and trying to insert the...
2
by: kharless | last post by:
Greetings, If I use a "select into" to clone a table, all attributes are created correctly, however, if I use the same statement across a linked server, my identity column loses its IDENTITY...
1
by: Hongyu Sun | last post by:
Hi, All: Please help. I use sql server as back end and Access 2003 as front end (everything is DAO). A table on SQL server has an identity column as the key. We have trouble on adding...
1
by: itisjitin | last post by:
Hi All, 1. Created table in SQL Server 2K with Primary key as int Identity 2. Link to table in MS Access 2K with child table 3. Using form in MSAccess to update the both master and child linked...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.