Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VB Problems have appeared since Access database was Upsized to SQL

Status
Not open for further replies.
jcg6

jcg6

Technical User
Feb 18, 2002
50
US
I am having problems with updating recordsets in my VBA code. Everything worked great when the database was in MS Access, but I upsized it to SQL Sever 2000 and now I am getting error messages when I try to update records in a recordset. Here is an example:

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

Does anyone know what I need to change in my code when a database is upsized from Access to SQL Server? Please let me know as soon as possible. Thanks very mucy.
 
Sort by date Sort by votes
Nevermind - I figured it out. :)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Converting from 32bit to 64 bit. After converting, database takes significantly longer to open 1
Replies
14
Views
2K
dhookom
dhookom
Moss100
  • Locked
  • Question
Find unique rent amount and date this was first charged
Replies
4
Views
894
dhookom
dhookom
DarkOne72
  • Locked
  • Question
MS Access DoCmd.Transferdatabase Assistance
Replies
2
Views
3K
lameid
lameid
BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
3K
dhookom
dhookom
Moss100
  • Locked
  • Question
Open New Access Database and Maximise the Application Window
Replies
0
Views
538
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top