Recent content by sharon.chapman7

Bob, You have put me on the right track. I put the following into my code and it works: set cnn = CurrentProject.Connection rst.Open "dbo_Requester", cnn, adOpenKeyset, adLockOptimistic Thanks for your help..Sharon

Sorry, I get a different error: 3709: the connection cannot be used to perform this operation. It is either closed or invalid in this context. It is getting this error when it tries to execute rst.Open "dbo.Requester, cnn, adOpenKeyset, adLockOptimistic Sharon

thanks for the quick reply. I tried these suggestions and I still get the error. I have tried shutting off my pc and restarting it. I have restarted the app and I still get this error. Sharon

Hi, I have an MS Access 2010 database with a module called bas This module reads the fields on a Microsoft Word document and then the data is loaded to a linked SQL Server 2008 R2 table. I am currently desigining this module so I am the only user using this database. I open the MS Access...

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. Set db = CurrentDb() Set rs = db.OpenRecordset("dbo_Filestream_Files", dbOpenDynaset...

Hi, I am trying to convert a UNIX Timestamp to a normal date. I am using Microsoft Access 2003 on an XP Operating system. I am getting a runtime error #6. Can someone please tell me how to fix this? Here is my code: UNIXDateTimeStamp = 1306347240612 Public Function sDate(UNIXDateTimeStamp As...