Help with access errors and corrupt files

[thompson905]

Hello everyone. I will admit I am a novice when it comes to access. But I do have some programming background in Lotus Notes. Now maybe its just me but Access seems to error out ALOT and I keep getting messages like:

-File is not a databse
-A user unexpectedly shut down access
-Some c++ runtime errors


I just dont understand what I am doing wrong. I am saving my work like I would do in anyother program. But at least once a day I have to resort to a backup copy because I keep getting errors like the ones above.

I have created an access 2000 DB and it did the same thing about 2 weeks ago...been doing it at least once a day if not more. I have created new db's and still the same thing. I have even converted it to 2003 and still problems.

For example I created a report and was told I didnt have permission to access the report??....WTF..I am the only user in the db as its in development...I created the db..if I dont have permission WHO does. So I tried to add myself in permissions.....then that when I got the c++ error.

I have been working in Notes DBs for the past 6 years and I have to tell you access doesnt have ANYTHING on notes. I have never had such stupid error out of the blue in any program I have used...I mean just closing the DB is causing an error on some days...

I am so frustrated with this its beyond belief..I have a real hard time turning this crap over to my users when I DONT trust it will be running next week...UGH

Some guidance will be most appreciated as I am about to just drop the project and start from scratch in something else.

 

[KenHigg]

a. Are you developing all on a local machine or are you working from a network? If so then it could be a network thing.

b. Do you have a second pc you could work on for a while to see if you'll get the same errors? If you don't get the same erorr on the second machine then you may need to rebuild your workstation.

 

[Rabbie]

C++ errors have NOTHING to do with Access. Either your installation of Access is corrupt or you are having problems on your network. It might be worthwhile re-installing Access to make sure that is not the problem.

 

[thompson905]

Well I dont know if using Vista is an issue or not but I am using it. The file I am using is on the network. I do have another xp laptop I could use. I will re install office 2003 on the vista machine and see if that works too. Just seems like no matter what I do...I lose part of my work because the db wont open and I have to go back to a backup file.


Rabbie - I am not sure why I would of gotten that c++ run time error in access as it was trying to finish off permissions. It was something like SH_something == OK line 143. I have never seen that one before today..Just happened..so I am not sure wish I would of screenied it for you :/ But I guess I have some things to try. Please tell me my experience is not typical of access development?

 

[Rabbie]

I can truthfully say in 10+ years of using Access I have seen/heard of anything resembling whats happening to you.

Seriously I would re-install Access ASAP

 

[KenHigg]

I'm not 100% on this but I think most Office products are authored in c.