Access - Error on Saving

[drow1212]

I cant get past this error, it happens when i try to save the data in a table.

Your AutoCorrect file C:\Documents and Setting\HP_Administrator\Application Data\Microsoft\Office\MSO1033.acl, could not be saved.
The file may be read-only , or you may not have permission to modify the file.

I am a HP_Administrator on my computer and the read-only box is not checked.
So I really have no clue what to do.

[MMcCarthy]

I cant get past this error, it happens when i try to save the data in a table.

Your AutoCorrect file C:\Documents and Setting\HP_Administrator\Application Data\Microsoft\Office\MSO1033.acl, could not be saved.
The file may be read-only , or you may not have permission to modify the file.

I am a HP_Administrator on my computer and the read-only box is not checked.
So I really have no clue what to do.

This is a new one to me. I would check the references library. Go to the VBA editor and in tools references look at the ticked libraries, is any of them marked as missing?

Mary

[drow1212]

Your AutoCorrect file C:\Documents and Setting\HP_Administrator\Application Data\Microsoft\Office\MSO1033.acl, could not be saved.

Please I really need to known who to save because it won't save any data entries I put in.

You guys meant have answered this before, but after looking through 15 pages I am pretty sure it's not there or it's buried to far back to find it.

I am using a Windows XP(SP2) OS with Microsoft Office 2007.

[drow1212]

Okay I found the other thread. However I don't known about the VBA is or how you get there.

I need a little bit more clarity on that part.

[drow1212]

I don't think any are missing.

[MMcCarthy]

I don't think any are missing.

I have merged both these threads and asked some of the other experts to have a look.

Mary

[NeoPa]

I cant get past this error, it happens when i try to save the data in a table.

Your AutoCorrect file C:\Documents and Setting\HP_Administrator\Application Data\Microsoft\Office\MSO1033.acl, could not be saved.
The file may be read-only , or you may not have permission to modify the file.

I am a HP_Administrator on my computer and the read-only box is not checked.
So I really have no clue what to do.

Does anyone else log in as HP_Administrator on your PC while you're logged on (Terminal Services / Remote Desktop)?
Does your C: drive use FAT32 or NTFS?

[pks00]

Have u read this? http://forums.techarena.in/showthread.php?t=182109

Now in that case its a write permission problem. In your case could it be the parent folder being readonly? Could it be that some process has that file locked so you cant edit it? There is this brilliant tool called Unlocker which tells you what processes have what files locked and u have the option of killing it.
Just a possiblity that something may of locked it.

[Denburt]

If you take a look at this Microsoft article I am sure you will understand everything much better.

http://office.microsoft.com/en-us/ac...345661033.aspx

If you want to check and see if it is enabled or you want to disable it the link is in the lower portion of the article.

[Denburt]

You stated that this was an Autocorrect issue when I look for the file MSO1033.acl I see a date over a month old and i am constantly changing records I have added and removed items from Autocorrect and that file doesn't seem to change. Could be a server trying to control this file.
The only other thing I would say is to check for right permissions for the file

The Help file from VBA states that there is also an Autocorrect on each text box and or Combo Box

The AutoCorrect object represents the AutoCorrect functionality of TextBox and ComboBox objects.

Using the AutoCorrect Object
To return an AutoCorrect object, use the AutoCorrect property.

To enable or disable the display of the AutoCorrect Options button, use the DisplayAutoCorrectOptions property.

To enable or disable AutoCorrect functionality for a particular TextBox or ComboBox object, use the AllowAutoCorrect property.

[Denburt]

Sorry I am always in the VBA portion of Access here is the help file from the MS Access window try turning it off then on and see if that has an effect.

http://office.microsoft.com/assistan...&respos=9&rt=2

[drow1212]

I went to the VBA and looked in the tools, but I don't see how you can turn off AutoCorrect or how to access. Where exactly is this AutoCorrect option?. My C drive is NTFS.

[drow1212]

The unlocker didn't turn up with anything, and I am pretty sure no-one else is accessing my computer through a terminal.

[NeoPa]

In view of the answers to these two questions, I cannot see why you would have this file locked (which would stop it from updating) or even security restricted (same problem). NTFS can handle file level security but it would be very unusual for restrictive security to be set up on your own profile area (Where this is found, going by its address).
Have you asked your technical support people if they can help?

[drow1212]

I will try that and get back to you guys.

[drow1212]

oh, I don't known if this is imporant, but my dad installed his copy on my computer. Also I need explanation on turning off AutoCorrect.

[Denburt]

oh, I don't known if this is imporant, but my dad installed his copy on my computer. Also I need explanation on turning off AutoCorrect.

You will probably want to compare versions you may need to uninstall and reinstall.

Starting in MS Access 2000 there are two types of AutoCorrect in MS Access "Autocorrect" (corrects mispelling in controls or fields) and "Name AutoCorrect" (tracks field names or properties and tries to update tables, queries, forms, etc.).
The article that I posted the link for earlier stated the following(in the access window):

1. On the Tools menu, click Options.
2. On the General tab, do one or more of the following:
* To have Microsoft Access maintain the information it needs to run Name AutoCorrect, but not take any action, select the Track name AutoCorrect info check box.
* To have Access run Name AutoCorrect as name changes occur in the database, select the Perform name AutoCorrect check box.
* To have Access keep a log of the changes it makes each time it runs Name AutoCorrect, select the Log name AutoCorrect changes check box. Access saves the changes in a table called Name AutoCorrect Log. Each change is a record in the Name AutoCorrect Log table.
3. To enable Name AutoCorrect for a table, query, form or report that already exists in the Access database, open it in Design view, save it, and close it.

[drow1212]

Were both using 2007.
Now are u talking about the tools menu in the VBA macro?
[IMG][IMG]Screen01[/IMG][/IMG]

[drow1212]

I hate that time limit of 5 minutes to edit posts.

Well I guess the pic isn't going be useful probably.

[drow1212]

Well I ran out of time again.

Click on the thumbnail to see it correctly.

I fell really dumb triple posting because of time limit and now I probably look very noobish. Sorry.

[NeoPa]

Well I ran out of time again.

Click on the thumbnail to see it correctly.

I fell really dumb triple posting because of time limit and now I probably look very noobish. Sorry.

Don't worry about that. It's understood to be a problem. Site design changes are afoot but need thorough testing before rolling out.
Clicking on the image shown gives a clearer and easily recognisable picture so this is good :)

[Denburt]

(in the access window)

Not the VBA window but in the MS Access application.

[Denburt]

Here is another thread where this was recently discussed and may help:

http://www.thescripts.com/forum/thread633454.html

[drow1212]

I found the options. However it still does it after turning off Name AutoCorrcet, disable almost all options for AutoCorrcet, having the exclusive and no locks on it. Still bring up the errors. Good thing you can have thumbnails.

[Denburt]

I found several articles that reffered to the file in question. They all mentioned a macro so I searched Microsoft and found the macro. It is for a word document in Word 2000 however it should still be the same file and hopefully you can utilize this to fix the file in question. Since it is a macro for 2000 there may be some errors try it out and see then let us know.

http://www.microsoft.com/downloads/d...displaylang=EN

[drow1212]

I downloaded the macro and installed it like you said. However it didn't really do anything. Below will be several thumbnails shed new light.

[drow1212]

here's the last two.
There's sort of a play-through there.
Yeah I like my Stepmania among other things.

[Denburt]

O.K. I was afraid that would be the case but thought it was worth a try.

1. In the MS Access window under options i noticed that you had the default open mode is set to exclusive. Try changing that to shared.

2. Did you actually highlight the file in question and check out the properties just to be sure that read only isn't ticked?

3. What is your Operating system? If WinXP do you have fast user switching on and is anyone else logged into the P.C. I have watched files that locked due to this in the past with other files/programs.

4. Go to the task manager and under the processes tab do you see your log in name. Do you see anything with unknown in it?

Running out of options before suggesting an uninstall reinstall, I will keep thinking on it.

[drow1212]

O.K. I was afraid that would be the case but thought it was worth a try.

1. In the MS Access window under options i noticed that you had the default open mode is set to exclusive. Try changing that to shared.

2. Did you actually highlight the file in question and check out the properties just to be sure that read only isn't ticked?

3. What is your Operating system? If WinXP do you have fast user switching on and is anyone else logged into the P.C. I have watched files that locked due to this in the past with other files/programs.

4. Go to the task manager and under the processes tab do you see your log in name. Do you see anything with unknown in it?

Running out of options before suggesting an uninstall reinstall, I will keep thinking on it.

The Read-Only wasn't ticked. I am running MS Windows XP(SP2). I changed it to shared and it didn't work. How do you get to the Task Manager?

[NeoPa]

Two ways :

1. Run TaskMgr
2. Ctrl-Alt-Delete, then select Task Manager.

[Denburt]

3. Right Click on the bar next to the start menu even a right click on the clock if it's shown. :)

[drow1212]

Okay I got to the Task Manager , but after 5 seconds it disappears. It seems like its just started doing it today because I just noticed it.

[NeoPa]

Task Manager disappears after 5 seconds?

[Denburt]

Task Manager disappears after 5 seconds?

dmn mobile is messing with me for the third time I would say my first instinct is that it's a virus. Try the typical fixs and if all else fails this link may help. Iwould use caution I haven't checked it out or the tools they mention but it may help.
http://windowsxp.mvps.org/ToolsQuit.htm

[drow1212]

Okay the task manager is fixed now. k, I figured out something new, it lets me save now however the error does still pop up. Now i am thinking its a registry issue however I dont known any realiable registry programs. I have run both spyware doctor and sweeper. Also briefly used NOD32.

[drow1212]

not a registry issue.

[Denburt]

I figured out something new

What is this and what was the original problem?

I am under the impression that you have or had a virus and they can corrupt so many Microsoft system files you might be stuck with a reinstall or rollback to before the problems started. Microsoft has some tools to replace corrupted system files yet I would need to review the procedures before I can guide you in that area.

[drow1212]

I can save now however i still get error message though, those tools meant help.

[NeoPa]

I can save now however i still get error message though, those tools meant help.

Perhaps you'd like to repost this one. Unfortunately this post makes little (if any) sense.

[drow1212]

It saves, however it still gives me the error. It is really annoying to have it pop up every time I start MS office. A clean install or the tools that were mentioned meant work , however I don't knon how to do them.

[NeoPa]

It saves, however it still gives me the error. It is really annoying to have it pop up every time I start MS office. A clean install or the tools that were mentioned might work , however I don't know how to do them.

OK, have you tried installing Office over your current install. It should give you an option to replace corrupted install files or something similar.
Otherwise I think Denburt was going to check out the tools for you.
Good luck.

PS. Check out the install over the top option and let us know how that goes. If it works that will save Denburt the trouble of digging up the extra info.

[drow1212]

I uninstalled the microsoft office. Deleted folders and removed files from registry, but its still messed up.

[NeoPa]

In that case I really don't know the answer. Perhaps Denburt knows and may provide some more suggestions.
Sorry I couldn't be more help.

[Denburt]

Pardon my delay in responding I have had some P.C. issues myself lately. Have you checked your P.C. for Viruses and or Malware? Post #35 you stated you found something and made some headway just exactly what did you find and or do?

[drow1212]

i am scanning now, when it is finished i will report back to you guys.

[drow1212]

Well I did a destructive system restore. deleted all of Microsft word and works and some other stuff. Re-installed Ms Office and now it works without any errors. Such a simple solution too, just in case someone else has these problems you should add this to a FAQ or something.

[drow1212]

I almost forgot thanks for all your help guys.

[NeoPa]

I almost forgot thanks for all your help guys.

No problem, just glad you got your solution in the end :)