Share via

Access 2010 runtime error 3027

Anonymous
2013-09-09T17:27:49+00:00

I am using access 2010 for a small database for the factory I am working for. I do not have much experience with access. I'm using accdb on both the front and back ends.  I have a Timeclock form setup on the front end for the floor workers to use. It is linked to the backend which is in a shared folder. The front end is in a shared folder as well. The problem I am having is that whenever I try to click the clock in button on the timeclock it errors out on the data entry step. When it tried to edit the recordset I get an error 3027: Cannot update: Database or object is read only. I have temporarily lowered all security on the folders thinking that may be an issue. Both folders are in the database's trusted locations. So far as I can tell the back end database is not set to read only. In the forms code I have made sure that I set the recordset as a dynaset recordset. I am completely at a loss for what's going wrong here. if you need any other information please do not hesitate to ask. Any insight at all on the situation is greatly appreciated.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-09-10T14:33:37+00:00

    Nevermind I finally found the issue. It was a permissions issue with the folders. Thank you all for all of your help. You have been great.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. ScottGem 68,830 Reputation points Volunteer Moderator
    2013-09-09T19:02:48+00:00

    What are the permissions on the back end folder? What are the permissions on the FE folder?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2013-09-09T18:45:42+00:00

    Let's try...

    1. Right mouse click on the file itself and see if it's Read Only.  This code happen if copied from another location of downloaded from eMail.
    2. If that does not work, make a back-up, then make sure *Track Autoname Correct* is unchecked, run a Compact & Repair and see if that works.
    3. Still not workining?  Make a back-up, yes, again (one can never have too many back-ups) and then create a new database front end.  Uncheck *Track Autoname Correct* and *Compact on Close* and import all your Objects in.  (Repeat for backend file) Hopefully, this resolves the issue, if not we're here!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. ScottGem 68,830 Reputation points Volunteer Moderator
    2013-09-09T19:43:00+00:00

    They need everything except Full Control. Just Read/Write is not enough.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2013-09-09T19:17:47+00:00

    What are the permissions on the back end folder? What are the permissions on the FE folder?

    Both sides are allowing read/write for everyone(temporary basis of course, until i can get things operating period.)

    as for your ideas Gina I will give them a spin and post back here to let you know how it's going.

    Was this answer helpful?

    0 comments