469,289 Members | 2,090 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,289 developers. It's quick & easy.

Access - Error on Saving

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.
Apr 13 '07 #1
47 7405
MMcCarthy
14,534 Expert Mod 8TB
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
Apr 13 '07 #2
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.
Apr 15 '07 #3
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.
Apr 15 '07 #4
I don't think any are missing.
Apr 15 '07 #5
MMcCarthy
14,534 Expert Mod 8TB
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
Apr 16 '07 #6
NeoPa
32,173 Expert Mod 16PB
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?
Apr 16 '07 #7
pks00
280 Expert 100+
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.
Apr 16 '07 #8
Denburt
1,356 Expert 1GB
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.
Apr 16 '07 #9
Denburt
1,356 Expert 1GB
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.
Apr 16 '07 #10
Denburt
1,356 Expert 1GB
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
Apr 16 '07 #11
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.
Apr 16 '07 #12
The unlocker didn't turn up with anything, and I am pretty sure no-one else is accessing my computer through a terminal.
Apr 16 '07 #13
NeoPa
32,173 Expert Mod 16PB
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?
Apr 17 '07 #14
I will try that and get back to you guys.
Apr 17 '07 #15
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.
Apr 17 '07 #16
Denburt
1,356 Expert 1GB
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.
Apr 17 '07 #17
Were both using 2007.
Now are u talking about the tools menu in the VBA macro?
[IMG][IMG]Screen01[/IMG][/IMG]
Apr 17 '07 #18
I hate that time limit of 5 minutes to edit posts.

Well I guess the pic isn't going be useful probably.
Attached Images
File Type: jpg Screen03.JPG (89.3 KB, 528 views)
Apr 17 '07 #19
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.
Apr 17 '07 #20
NeoPa
32,173 Expert Mod 16PB
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 :)
Apr 18 '07 #21
Denburt
1,356 Expert 1GB
(in the access window)
Not the VBA window but in the MS Access application.
Attached Images
File Type: jpg Options.JPG (46.6 KB, 486 views)
Apr 18 '07 #22
Denburt
1,356 Expert 1GB
Here is another thread where this was recently discussed and may help:

http://www.thescripts.com/forum/thread633454.html
Apr 18 '07 #23
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.
Apr 19 '07 #24
Denburt
1,356 Expert 1GB
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
Apr 19 '07 #25
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.
Attached Images
File Type: jpg Screen01.JPG (51.8 KB, 222 views)
File Type: jpg Screen05.JPG (44.8 KB, 371 views)
File Type: jpg Screen02.JPG (53.4 KB, 403 views)
File Type: jpg Screen03.JPG (51.3 KB, 196 views)
File Type: jpg Screen04.JPG (32.3 KB, 361 views)
Apr 19 '07 #26
here's the last two.
There's sort of a play-through there.
Yeah I like my Stepmania among other things.
Attached Images
File Type: jpg Screen06.JPG (93.1 KB, 397 views)
File Type: jpg Screen07.JPG (52.1 KB, 232 views)
Apr 19 '07 #27
Denburt
1,356 Expert 1GB
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.
Apr 19 '07 #28
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?
May 23 '07 #29
NeoPa
32,173 Expert Mod 16PB
Two ways :
  1. Run TaskMgr
  2. Ctrl-Alt-Delete, then select Task Manager.
May 23 '07 #30
Denburt
1,356 Expert 1GB
3. Right Click on the bar next to the start menu even a right click on the clock if it's shown. :)
May 24 '07 #31
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.
May 27 '07 #32
NeoPa
32,173 Expert Mod 16PB
Task Manager disappears after 5 seconds?
May 27 '07 #33
Denburt
1,356 Expert 1GB
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
May 29 '07 #34
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.
Jun 2 '07 #35
not a registry issue.
Jun 4 '07 #36
Denburt
1,356 Expert 1GB
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.
Jun 4 '07 #37
I can save now however i still get error message though, those tools meant help.
Jun 7 '07 #38
NeoPa
32,173 Expert Mod 16PB
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.
Jun 7 '07 #39
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.
Jun 7 '07 #40
NeoPa
32,173 Expert Mod 16PB
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.
Jun 7 '07 #41
I uninstalled the microsoft office. Deleted folders and removed files from registry, but its still messed up.
Jun 23 '07 #42
NeoPa
32,173 Expert Mod 16PB
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.
Jun 23 '07 #43
Denburt
1,356 Expert 1GB
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?
Jul 2 '07 #44
i am scanning now, when it is finished i will report back to you guys.
Jul 4 '07 #45
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.
Aug 19 '07 #46
I almost forgot thanks for all your help guys.
Aug 19 '07 #47
NeoPa
32,173 Expert Mod 16PB
I almost forgot thanks for all your help guys.
No problem, just glad you got your solution in the end :)
Aug 20 '07 #48

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Peter Frost | last post: by
3 posts views Thread by Tlaker | last post: by
2 posts views Thread by Carpe Diem | last post: by
5 posts views Thread by rn5a | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.