Ms Access file Missing
-
I am working in a VB6 Access project in which the DB is password protected. My DB is getting corrupted at the application run time. Anybody have any solution
-
I am working in a VB6 Access project in which the DB is password protected. My DB is getting corrupted at the application run time. Anybody have any solution
-
I am working in a VB6 Access project in which the DB is password protected. My DB is getting corrupted at the application run time. Anybody have any solution
I suppose you are running Access 95 or something, there was a utility that would allow you to clean and compress the database. If you have not been using that then the database will have been deteriorating of the last decade or so and is probably dead by now. You have gone well past the use by date for this application.
Never underestimate the power of human stupidity RAH
-
I am working in a VB6 Access project in which the DB is password protected. My DB is getting corrupted at the application run time. Anybody have any solution
sudheesh kumar s wrote:
My DB is getting corrupted at the application run time.
What does that mean? Do you have a database which is now corrupted? Or you have an uncorrupted database and EVERY time you start the application then it becomes corrupted? And what application (version) on what OS (version) are you using to determine that it is corrupted?
-
I am working in a VB6 Access project in which the DB is password protected. My DB is getting corrupted at the application run time. Anybody have any solution
Are you accessing the database from multiple machines? Access isn't meant as a database-server, it's a "local" database format. Do you still have a non-corrupt version around? Backups? If so, open it in Access, and convert it to Sql-server format. MS Access has a conversion-wizard that can migrate everything in there to Sql Server. Next, you download Sql Server Express 2008, which is a free download. Next, you download Visual Basic Express 2010, which is also a free download. If the app survived this long, there's bound to be some value in it. That would mean that it's probably worth updating the logic to something more modern. All the tools are available for free. Happy programming :)
Bastard Programmer from Hell :suss:
-
I am working in a VB6 Access project in which the DB is password protected. My DB is getting corrupted at the application run time. Anybody have any solution
I have been using MS Access as a backend with VB6 for over a decade. Our software works with Access or SQL Server depending on customer size and usage. 95% of the code base is the same. The only time I have seen Access (2000 or better) become corrupted is when more than about 6 or 7 users might hit it at the same time...combine that with a crappy network and it spells trouble. The bottom line is that Access does not perform will with multiple connections over a network. (permissions can also be a bi*ch since Access has to create a lock file) If the database gets corrupted everytime you start the program, then obviously you will have to solve that issue first.
"Go forth into the source" - Neal Morse