I was able to copy and paste tables and I get some data loss but at least I
am able to continue invoicing (Whew.. I am in my busy season)... I will
retry using your suggestions.of importing ... But before I do...any idea
what is causing the "automation error" when I compile. Its always at the
same line in the switchboard class module:
Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.
Dim dbs As Database
Dim rst As Recordset
The Dim dbs As Database is highlighted. Maybe if I could get it past that
point I would be ok.
"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:449f4aa7$0$6627$5a62ac22@per-qv1-newsreader-01.iinet.net.au...[color=blue]
> 1. Create a new (blank) database.
>
> 2. Import the tables, or link them if the database is split:
> File | Get External
>
> 3. Close Access. Make a copy of the mdb file. Open again.
>
> 4. Import the other objects (queries, forms, reports, macros, modules.)
>
> 5.Set minimal References under Tools | References (from the code window).
> For help with references, see:
>
http://allenbrowne.com/ser-38.html
>
> 6. Compile (Debug menu, from the code window).
>
> At step 4, you may find that the database fails while importing a
> particular form. If so, note the form, close the database, copy the good
> one (result of step 3), and try the import again without that bad form.
> You may find there are other forms or reports that are corrupt as well,
> but the end result of this process could be a new database that has all
> the data and most of the forms and reports. You may then be able to import
> these last few forms/reports from a backup copy of the database.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users -
http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "advance scout" <ivanhoe@nospam.optonline.net> wrote in message
> news:wRBng.265$V27.24@fe09.lga...[color=green]
>> When I repair... the data is there (the tables can be opened) and tehy
>> look good.... But I get an "automation error" when I run the
>> switchboard
>>
>>
>>
>>
>> "advance scout" <ivanhoe@nospam.optonline.net> wrote in message
>> news:s8Bng.89$9y4.72@fe11.lga...[color=darkred]
>>> HELP! My database is suddenly corrupted. My computer was acting funny
>>> (very sluggish) and was shut down. Access had been already been closed
>>> down but computer was acting very slow , so perhaps it was still open. I
>>> am now getting a "The data base ... is corrupted and needs to be
>>> repaired" error . I have made copies of the corrupted database so that I
>>> could try to repair and still have a corrupted copy available. When I
>>> try to repair , it says that it has repaired the file successfully but
>>> then it comes up as an automation error. Then when I try to restart
>>> the "repaired " database- Access crashes.
>>>
>>> Also in the directory I have a file with a .ldb extension... so
>>> apparently that wasnt deleted as teh program got corrupted.
>>>
>>> PLEASE HELP ... ANY IDEAS???[/color][/color]
>
>[/color]
