By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,573 Members | 3,008 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,573 IT Pros & Developers. It's quick & easy.

VBA code error odbc 3146

P: 2
I am getting an error 3146 odbc on rs.update. I have a form (form1) based on table motion_imagery. In form1, using VBA I'm trying to load two fields from form1 into table 2, File_Books.

Expand|Select|Wrap|Line Numbers
  1. Set db = CurrentDb()
  2.     Set rs = db.OpenRecordset("dbo_Filestream_Files", dbOpenDynaset, dbSeeChanges)
  4.     rs.MoveLast
  6.     rs.Edit
  7.     rs![Prefix_CTRL_NBR] = Me.Prefix_CTRL_NBR
  8.     rs![CTRL_ID] = Me.CTRL_NBR
  9.     rs.Update
can someone help?

Feb 22 '12 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 931

Error 3146 is a generic ODBC error message. It means that Access cannot properly establish contact with your back end table, and it can occur for any number of reasons. Is dbo_Filestream_Files a linked SQL Server table? If so, and if the table is properly linked to the back end source, you should be able to open it in datasheet view and examine its contents. If you aren't able to do that, then it means that you need to properly the link the table to the back end source.

Feb 22 '12 #2

Post your reply

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