Timeline for VBA Excel-Access 3251 Runtime error
Current License: CC BY-SA 3.0
22 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 9, 2018 at 19:34 | history | edited | CommunityBot |
added [excel] to 23464 questions - Shog9 (Id=811)
|
|
| Aug 9, 2016 at 9:38 | vote | accept | Ronan O'Driscoll | ||
| Aug 9, 2016 at 9:38 | vote | accept | Ronan O'Driscoll | ||
| Aug 9, 2016 at 9:38 | |||||
| Aug 9, 2016 at 9:38 | vote | accept | Ronan O'Driscoll | ||
| Aug 9, 2016 at 9:38 | |||||
| Aug 9, 2016 at 9:38 | vote | accept | Ronan O'Driscoll | ||
| Aug 9, 2016 at 9:38 | |||||
| Aug 3, 2016 at 3:41 | answer | added | dbmitch | timeline score: 1 | |
| Aug 3, 2016 at 2:09 | answer | added | Ronan O'Driscoll | timeline score: 1 | |
| Aug 3, 2016 at 2:01 | comment | added | Ronan O'Driscoll | RESOLVED NULL (commented the auto field) | |
| Aug 3, 2016 at 1:57 | history | edited | Ronan O'Driscoll | CC BY-SA 3.0 |
deleted 118 characters in body
|
| Aug 3, 2016 at 1:52 | comment | added | Ronan O'Driscoll | Halfway there! Thank you to everyone who has made suggestions / edits so far. I went into the connections in Excel and altered the ShareDeny and changed it to Mode=Share Deny None Also some minor alterations to the code which I have show n the main code on the question. However now i get an really random error saying im trying to assign a Null value? | |
| Aug 3, 2016 at 1:40 | history | edited | user6432984 | CC BY-SA 3.0 |
Code formatting, typo, grammar and removed fluff
|
| Aug 3, 2016 at 1:34 | comment | added | dbmitch | No. You need primary key in ado recordsetr updates | |
| Aug 3, 2016 at 1:33 | comment | added | Ronan O'Driscoll | @barrowc - will try that now thanks | |
| Aug 3, 2016 at 1:33 | comment | added | Ronan O'Driscoll | @dbmitch - yes the ID is a primary key field should i remove this? ... will try using the adoopendynamic thanks | |
| Aug 3, 2016 at 1:32 | comment | added | dbmitch | You might need to add ";Persist Security Info" to your connection string... Or you could always try DAO | |
| Aug 3, 2016 at 1:31 | comment | added | barrowc | ADO version 2.1 is really out of date (it seems to have been released in the late 1990s). Try referencing version 2.8 instead | |
| Aug 3, 2016 at 1:27 | comment | added | dbmitch | I hate ado with access databases. But if you don't want to use DAO try opening with adoopendynamic instead of keyset. Check RS.updatable property right after .open to make sure you recorded can be updated. Is ID a primary key field? | |
| Aug 3, 2016 at 1:12 | comment | added | Ronan O'Driscoll | Sorry its on the ".addNew" or at least thats the line that becomes highlighted The error is the 3251 error and it states "Current Recordset does not support Updating. This may be a limitation of the provider, or of the selected locktype" | |
| Aug 3, 2016 at 1:11 | review | First posts | |||
| Aug 3, 2016 at 1:14 | |||||
| Aug 3, 2016 at 1:10 | comment | added | dbmitch | What line is error? Is it on the update? | |
| S Aug 3, 2016 at 1:07 | review | Triage | |||
| Aug 3, 2016 at 1:20 | |||||
| S Aug 3, 2016 at 1:07 | history | asked | Ronan O'Driscoll | CC BY-SA 3.0 |