[AccessD] Error 3027 in A2003 runtime

Steve Erbach erbachs at gmail.com
Tue Oct 21 06:38:00 CDT 2014


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


More information about the AccessD mailing list