Avatar billede nyholm Novice
03. juli 2007 - 14:30 Der er 8 kommentarer og
1 løsning

Major problem

Hej alla!
Jag har fått ett stort problem med min db. Problemet uppstod nær jag tog bort en rapport. Under borttagningen gick något fullstændigt fel och access avslutades. Nær jag øppnade db:n igen efterfrågas den borttagna rapporten. I Visual Basic finns rapporten kvar i listan øver projektets klassobjekt, men rapporten ær borta i databasfønstret. Jag har førsøkt att importera alla delar till en ny db, men det fungerar inte på grund av att db:n ær løsenordsskyddad. Æven om jag anger løsenordet i den skadade db:n, får jag meddelandet att db:n ær færsatt i ett læge dær den inte går att øppna eller spara.
Vad gør jag?
Avatar billede terry Ekspert
03. juli 2007 - 14:34 #1
Can you explain in English? :o)
Avatar billede nyholm Novice
03. juli 2007 - 15:15 #2
Hi Terry!
I was deleting a report when something whent wrong and access closed down.
Apperantly the deletng process was not completed, because the report is still existing in the Visual Basic window but has been deleted from the db window. When I open Visual Basic it asks for the missing report, but it can't be recreated. I have tryed to import all objects from this damaged db but it needs to be saved after the password has been given, but it is impossible to save any changes.
What can be done?
Avatar billede terry Ekspert
03. juli 2007 - 15:32 #3
You say that you want to delete the report?

When you import all objects from the damaged db cant you choose which objects you want to import? If partially deleted report is in th elist then de-select it
Avatar billede terry Ekspert
03. juli 2007 - 15:33 #4
Dont you have a Backup?
Avatar billede nyholm Novice
03. juli 2007 - 16:14 #5
The code in the damaged db is passwordprotected and it would'nt be any problem to import all objects from the damaged db if I could remove or give the password, but nothing I do can be saved because then db is damaged.
Yes, I wanted to delete the report but it was in the middel of the deletion that access closed down, with the result that the referens still exists in Visual Basic but the report is gone from the db window.
Avatar billede terry Ekspert
03. juli 2007 - 19:07 #6
Are you saying that you are not allowed to import ainto a new dB and save?
Avatar billede nyholm Novice
03. juli 2007 - 20:27 #7
Exactly. To be able to import from a db where where the project is locked with a password, You first must open the db and unlock it. The problem is that no changes takes effect since the db is damaged. You can't save any changes.
Avatar billede terry Ekspert
04. juli 2007 - 11:10 #8
And you  have tried compact repair?

Maybe a decomåile of the dB might help
http://www.granite.ab.ca/access/decompile.htm
Avatar billede nyholm Novice
21. februar 2008 - 16:58 #9
Stänger frågan
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester