Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

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).


I NEED A QUICK SOLUTION AS THE PROG IS NEEDED FOR TOMMOROW :-(

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 !!!
0
Stoned_elf
Asked:
Stoned_elf
1 Solution
 
AzraSoundCommented:
Post your code for saving
0
 
Stoned_elfAuthor Commented:
coming up
0
 
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.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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.

Elf
0
 
robertleesCommented:
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
0
 
vinnyd79Commented:
have you tried a compact & repair on the database?
0
 
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.

Elf.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now