https://code.google.com/p/fivewin-contributions/downloads/detail?name=fivedbu_20130503.zip
Full source code included
static function RSSaveRecord( oRS, aRecord, nRecNo )
local n
if oRS:AbsolutePosition != nRecNo
oRS:Move( nRecNo, 0 )
endif
for n = 1 to oRS:Fields:Count
TRY
if oRS:Fields[ n - 1 ]:Attributes != 90 // non updateable
oRS:Fields[ n - 1 ]:Value = aRecord[ n, 2 ]
endif
CATCH
END
next
oRS:Update()
return nilRick,
Could you email me your database ? thanks ![]()

Antonio
I sent you the sample Access database ( 11mg ) via YouSendIt.com addressed to your gmail account.
Let me know if you do not receive it to download.
Thanks
Rick Lipkin
However, if you are sure you have the permission on the object, but still get this error, then it is very likely that the object information and property data are partially corrupted and Microsoft Access thinks you have no read permission for the specific object mistakenly.
Antonio
The .mdb I sent you is a legacy database that I inherited for an invoicing application I have re-built using ADO ( ms jet ).
I did try a different .mdb ( much simpler ) and it did open with FiveDbu. The database I sent you has had relations and queries stripped from it and I did compact and repaired it before I sent it to you.
I can tell you that I do not have any problems opening recordsets or connections with the .mdb I sent you
Let me play with your code next week and see if I can tweak it to use the .mdb I sent you.
Thanks
Rick Lipkin
Rick,
thanks so much for your great feedback and help ![]()
Antonio,
Thank you for the modified version with connection-string.I have tested it with this result.
Result with SQLite.
It's working nice. The only problem is that you can't edit an empty field. It's only possible to edit a field, if something is already in the field.
Result with MySQL.
The connection is working, but it's not possible to browse the fields since you still have to select a database after the connection, and that is not possible, because the database is already specified by IP-adress in the connection-string. It's not a real file...
That is also a little problem when you specify a SQLite-database. Here I can select the file, after entering the connection-string, but this is normaly not needed, because the file is already specified in the connection-string.
I suggest to directly browse the database, after entering the connection-string..