Absolutely desperate plz help really simple EZ points.

Hi I have been making a program using visual basic that interacts with a micosoft access database. unfortunately it has stopped saving for some unknown reason. It saved fine for ages then stopped. I think it is something to do with the file property "archive" being selected as when I uncheck this it usually works again (but this sucks as a solution as I have to do it each time the prog starts up).


Will accept solution or easy work around as I only have 30mins tommorow morning to put it right before I have to go into work and present the program !!!
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Post your code for saving
Stoned_elfAuthor Commented:
coming up
Stoned_elfAuthor Commented:
the database interaction was all done using the data class. The database file name is passed to the form that deal with it through a variable and loads fine then all the text boxes on the form are linked to the fields so changing them should automatically change the database.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Stoned_elfAuthor Commented:
Okay I have to go offline now I will check back for any solutions in the morning.

Thanks for any help you can provide.

I don't know why the Archive flag should be causing you a problem, but in view of the urgency of your problem, get your VB app to turn off the Archive flag, rather than doing it manually...

SetAttr "name of Access mdb file", vbNormal

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
have you tried a compact & repair on the database?
Stoned_elfAuthor Commented:
Thanks Robertlees u r a life saver. Still dunno why it was doing it but why treat the problem when I can treat the symptom.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.