04-28-2009, 04:50 AM #7 jzwp22 Access Hobbyist Join Date: Mar 2008 Posts: 2,629 Thanks: 0 Thanked 311 Times in 308 Build and test a new query in the query designer where you explicitly define a JOIN condition.

I have checked & changed nothing to do with folder persmissions etc. Database or object is read-only The query for the recordset appears to be un-updateable. i am also racking my brains as to when i changed this and i think i remember. Posts: 5 Thanks: 0 Thanked 0 Times in 0 Posts I have only set the permissions on the database.

You’ll be auto redirected in 1 second. Database or object is read-only. (Error 3027) You tried to save changes in a database that was opened for read-only access. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.Would you like to participate? Check whether Anonymous access has been enabled or not. 2.

overbar with parenthesis Projectiles in a world devoid of gunpowder more hot questions question feed default about us tour help blog chat data legal privacy policy work here advertising info mobile Then use SAS 9.2 to append the new file to the existing XLSM file. That was my other problem –Simple Sandman Dec 15 '15 at 17:24 add a comment| up vote 2 down vote As mentioned in another answer, the dbOpenSnapshot option results in a