[AccessD] Error 3027 in A2003 runtime

Gustav,

Thanks, Gustav.

No, I don't really have to delete the temp table...but I wasn't thinking of
a workaround for such a simple thing. You're right, though. Thanks.


On Tue, Oct 21, 2014 at 7:17 AM, Gustav Brock <gustav at cactus.dk> wrote:

> Hi Steve
>
> Welcome back.
>
> Do you really have to delete the table?
> Couldn't you just delete all records?
>
> /gustav
>
> -----Oprindelig meddelelse-----
> Fra: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] På vegne af Steve Erbach
> Sendt: 21. oktober 2014 13:38
> Til: Access Developers discussion and problem solving
> Emne: [AccessD] Error 3027 in A2003 runtime
>
> Dear Group,
>
> It's been a long while since I logged into AccessD. I use Access for only
> one old project (10-1/2 years) that I've supported for too long, I'm afraid.
>
> I recommended that Windows 7 machines be installed for this particular
> client. I also recommended moving from Access 2003 to Access 2010 to sort
> of keep up with the times, eh?
>
> However, my application requires import and export to Paradox v. 4 tables.
> I didn't discover that Microsoft dropped support for Paradox tables (and
> Lotus 1-2-3 spreadsheets) until the program crashed.
>
> So I created an Access 2003 Runtime package with the Developer Tools and
> installed that instead (after UN-installing Office 2010 first, then
> installing the Runtime, then re-installing Office 2010!). But I ran into a
> different problem.
>
> In preparation for importing Paradox data, the app deletes a temporary
> Access table with:
>
> DoCmd.DeleteObject acTable, "xyztable"
>
>
> The app crashes with the 3027 error:
>
> Cannot update. Database or object is read-only.
>
>
> It's been so long that I've worked with the Access Runtime that I don't
> know where to look. The app has worked for 10-1/2 years on Windows XP using
> Access 2003. I didn't remember that there was any particular restriction on
> deleting or creating tables. The table being deleted, by the way, is in the
> front-end.
>
> Could anyone help me with this?
>
> Sincerely,
>
> Steve Erbach
> Neenah, WI
> --
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Regards,

Steve Erbach
Neenah, WI
http://www.NeenahPolitics.com
http://www.TheTownCrank.com