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

VBA code error odbc 3146

P: 2
Hi,
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)
  3.  
  4.     rs.MoveLast
  5.  
  6.     rs.Edit
  7.     rs![Prefix_CTRL_NBR] = Me.Prefix_CTRL_NBR
  8.     rs![CTRL_ID] = Me.CTRL_NBR
  9.     rs.Update
  10.  
can someone help?

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


patjones
Expert 100+
P: 931
Sharon,

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.

Pat
Feb 22 '12 #2

Post your reply

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