Access will no longer allow me to save records

[jaitken0308]

Hi,

First, I wish I had more details as to what happened, but I'm at a loss.

The short of it is that my forms will no longer allow me to add/edit records. It gives me this error:

You can't save this record at this time.
Microsoft Access may have encountered an error while trying to save a record.  
If you close this object now, the data changes you made will be lost.  
Do you want to close the database object anyway?

I can edit directly from the table all day, but my forms, that did work at one time, will not allow changes to be made to the table anymore.



Over the past few days, I have made some changes, but I can't find which one caused this. Here's what I've done over the past few days with the help of this forum and others:

• Disabled Access hotkeys, and the shift bypass.
• Set user security levels - if they aren't me, they don't have access to the navigation pane or the ribbon.
• Attempted to use Allen Browne's method of setting up temp audit tables to track user activity. I say attempted because it doesn't work yet.

That's all I've done, but like I said, I can't seem to find anything I did that changed the capability of my forms to save.

I know this isn't alot to go on, but does anyone have any suggestions? They would be greatly appreciated!

 

[jdraw]

Is this a multi-user environment? If so is the database split?

 

[jaitken0308]

To answer. .. yes for the first, no for the second.

 

[jdraw]

I suggest you search for msaccess database splitter and read the info asap.

[URL1="http://www.fmsinc.com/microsoftaccess/performance/linkeddatabase.html"]This one too[/URL].

Copy of Frontend on each user's PC
Instance of Back end on server.

 

[jaitken0308]

So, I found the culprit. I was using Allen Browne's method for logging user activity found here. It tells you to create 4 events for your form in the Before Update, After Update, On Delete, and After Delete Confirm fields in the properties. I removed those events and now everything works again.

Wonder what I did wrong using his method. He explained it clearly and I followed it, but I couldn't get it to work. Maybe I just won't worry about logging activity.

Anyways, thanks for the help!

 

[jdraw]

If you are multi-user and are working with an unsplit database, you should research splitting and why.
You may be courting disaster.

You have been fore-warned.

 

[Minty]

I think until you split the database out to a front end / back end you will struggle with any form of auditing.
A shared front end is a recipe for problems now and total grind to a halt later when it or your user base grows.

 

[jaitken0308]

I will look into splitting. I haven't done that yet since this is a small DB. There are 20ish of us that can use it, but only 3 or 4 use it regularlly, and it isn't a daily usage - maybe several times a month.

But, I will take your advice and do it. Thanks!