473,320 Members | 2,083 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Disaster recovery! All forms disappeared

Hi

I was working on MS Access 2003 and clicked save in visual basic I got some error message which I ignored and all the forms have been removed. I restarted and they appeared. After a while it happened again but they didin't appear again. (there are still in VB)

I have done a few changes remotely and the database was not being backed up (only BE was backed up).

I've read on the internet that this happens and found one post where someone says that he/she paid a company to do that. (the db is still big so the forms must be there, the same experienced other people)

Any ideas?
I have the file after the forms were removed. (untouched)

Many thanks in advance.
Emil
May 20 '09 #1
6 5354
Denburt
1,356 Expert 1GB
Lots of things can be going on. First you said you have not backed this up so do so now... I usually back mine up before I start working on it then hourly if not more often and once I have completed working on it I back it up again. I probably back it up way more often than necessary but better to have a backup then not.
Make sure that the database is compiled, then if you haven't try compact and repair database. then you could always try the following:
SaveAsText(acForm,"FormName","FileName")
LoadFromText(acForm,"FormName","FileName")

Hopefully one of these methods will bring them back if not you can try to decompile the database and see if that helps.
May 20 '09 #2
Hi Thanks for the prompt answer.

The file I was working on was used but was a development copy (now replaced by previous version).

I have tried to compile it but I'm getting message boxes saying that the form is misspelled or refers to a form that doesn't exist.

I'm able to export the form in VB but I cannot import it and I also cannot remove a form from VB manually the option is grayed out.

I also tried compact and repair but didn't work.

I think I will just have to make the changes again only about 5-10h and now I know the answers so should be quicker. However I'm very curious if there is a way to do that so I will keep the file and maybe one day I will find out ;) or someone will share his experience with this fatal bug!

Regards
Emil
May 20 '09 #3
Denburt
1,356 Expert 1GB
@IT Couple
MS Access has many fatal bugs. I have 1 report in particular that I work on quite frequently and it bombs out quite frequently so I pull in a back up and off I go. Not to much you can do sometimes.

You say you can export it but not import it. Is that using the commands I used in my previous post or are you doing it some other way? When you try to import it what happens do you get an error or anything?

Many times when things like this happens it is really hit or miss to see what will work to get things back in order. You might also try the decompile option as I mentioned above.

msaccess.exe "drive\path\file name.mdb" /decompile

Let us know if one of these methods works or if you find an alternate method that resolves it for you.
May 20 '09 #4
NeoPa
32,556 Expert Mod 16PB
Sometimes you can import the form into another database. This doesn't help much when the form itself is corrupted, but is worth knowing.

Otherwise, I would always recommend the following (as posted previously) :
It is always a good idea to ensure that variable name checking is enabled, AND your code compiles (at least compilation has been attempted), before submitting a question.

This avoids asking questions which are much more easily resolved on your own PC than on a forum.

To ensure variable name checking is enabled for all new modules, go to - Tools / Options / Editor (from the VBA Editor window) and set Require Variable Declaration to True (checked). For existing modules, ensure that the Option lines at the very top include :
Expand|Select|Wrap|Line Numbers
  1. Option Explicit
To compile your project, select (again from the VBA Editor window) Debug / Compile Project Name.

We ARE generally happy to help with compilation problems too (If you find an error reported and you can't resolve it, let us know), but we do expect members to have tried compiling before submitting a question. That way we have a better idea of the sort of problem we're looking at.
Not all is relevant to your situation, but the compilation bit is certainly so.

Otherwise, the advice to backup regularly is your safety-net for the future.
May 25 '09 #5
Hi

For this project I will just let it go as it was developed by another developer and it will just be easier for me to do my bits again ;)

I've tried compiling the project in vb but it says the form is missing, I will play with at when I have a minute and see if anything else which was mentioend here works.

Many thanks for all the replies!
Emil
May 25 '09 #6
NeoPa
32,556 Expert Mod 16PB
No worries. I recommend compiling frequently, to find and fix problems as soon as they occur.
May 25 '09 #7

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

Similar topics

18
by: Jason Tesser | last post by:
We are evaluating Postgres and would like some input about disaster recovery. I know in MsSQL they have a feature called transactional logs that would enable a database to be put back together...
8
by: Neil Truby | last post by:
There's something clearly missing in my understanding of recovery: I set up a small sample datavase and deleted all the rows from a table. Crucially, I omitted the "commit". I then shut down...
10
by: xixi | last post by:
i have db2 udb v8.1 on windows 64 bit 2003 server, after db2 server start , i found this in the db2diag.log, is this error? 2004-05-05-15.28.30.780000 Instance:DB2 Node:000...
3
by: jignesh shah | last post by:
Hi all, Is there a way to recover a single container if its been corrupted or mark bad without restoring whole tablespace? environment: db28.1/aix5.1/tsm/rs-6000. Regards Jignesh
3
by: Konstantin Andreev | last post by:
Hello, everybody. I've spent a lot of time reading "DB2 Information Center" and Raul Chong's book "Understanding DB2. Learning Visually with Examples", but still unable to answer this simple...
2
by: Racerx | last post by:
Hi All : I use db2 8.1 fixpack 3 on AIX. I recieved the following message in the diaglog ====================================================== ADM7513W Database manager has started. ...
3
by: sureshabi | last post by:
Hello All, I am on a mission critical MS ACCESS database, which has runout of storage space of 2GB. I need to know the following to do a diaster recovery of the existing situation if situation...
2
by: Tin | last post by:
I bought a laptop and burned 4 recovery CDs for recovery purpose. Instead of burning as disc images, I just copied and pasted these 4 CDs to my USB HDD as 4 folders called "RecoveryCD 1",...
0
by: APP1MVF | last post by:
First let me start by saying I am not a DBA nor do I claim to be one, ok with that out of the way I am looking for some help understanding DB2 UDB Recovery after Total Media Failure or Server Loss...
2
by: =?Utf-8?B?c3BhcmtsZWJhbg==?= | last post by:
My recovery disk on vista is almost full. I have performed a back up, deleted all but the most recent recovery point, done a disk clean up and also compressed the recovery disk. It is STILL almost...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.