Updating Access dba from Excel (1 Viewer)

china99boy

Registered User.
Local time
Today, 11:42
Joined
Apr 27, 2006
Messages
161
Hi guys,

Not sure what I am doing wrong, I have an Access dba that stores records. I create an Excel spreadsheet that pulls the data from access. This works great,but I am having problem updating the record. I have a sample that works great and I simply added the coding to my application but continue to recieve a

run-time error '3265'

Item cannont be found in the collection corresponding to the requested name or ordinal.

When the user changes the data in excel and clicks the update button the changes should reflect in the Access dba.

Can anyone figure what I may be doing wrong?

Thanks in advance. I have added both excel and access files.
 

Attachments

  • test.accdb
    396 KB · Views: 151
  • Test.xls
    66 KB · Views: 192

Users who are viewing this thread

Top Bottom