Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ChrisHuyghe
Starting Member
2 Posts |
 Posted - 2008-02-14 : 21:58:15
|
| After upsizing my database from access to SQL I get the error 3622 (must use DBSeechanges) and I can't figure out the correct syntax.My original code in the afterUpdate Event, which I used to create an audit trail, by inserting any changes (in my Main table) in to a new table (called backup), looks like this: Dim db As Database Set db = CurrentDb db.Execute "INSERT INTO [Backup] " _ & " SELECT * FROM [Main] WHERE " _ & " [Main].[ID]=" & Me![ID] & ";" Set db = NothingWhat is the correct syntax in MS Access for a SQL 2000 back end? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-15 : 01:10:57
|
Can you add DBSeeChanges as a parameter for the DB.Execute command?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
ChrisHuyghe
Starting Member
2 Posts |
Posted - 2008-02-15 : 06:37:43
|
| I've tried that, but I can't figure out the right syntax. |
|
|
|
|
|
|
Error 3622 after upsizing to SQL