Avatar billede 4444 Nybegynder
21. februar 2002 - 16:46 Der er 17 kommentarer og
1 løsning

Jet-database motor

Vi forsøgte at lave adresse fletning i Word til en access db 2002, der bl.a. også har vores web data.
Vort web gik død, og da vi forsøgte at åbne databasen fil vi følgende besked i en alert:
Microsoft Jet-databasemotoren har standset processen, fordo du og en anden bruger forsøger at ændre data samtidigt.
Det blev foretaget fra een maskine, og vi kan ikke aktivere noget under "Hjælp" - "Om Microsoft"
Microsoft i DK giver "Naturligvis" ikke support på den type problemer.
Kan nogen hjælpe?
Avatar billede terry Ekspert
21. februar 2002 - 18:37 #1
If your database is on a web server then you will have to copy it to your PC. Then start Access without opening a database. Then go to the Tools+Database Utilities+Compact and repair Database. Then find your database and follow the instructions!
Avatar billede terry Ekspert
21. februar 2002 - 20:02 #2
4444>hows it going?
Avatar billede 4444 Nybegynder
21. februar 2002 - 20:23 #3
It only gives me the possibility to Compress, and when I press that button, I still get the same information as described above, but thank you for your suggestion. I have also tried to convert to 2000 but it wont let me - same message in the alert box again.
Avatar billede terry Ekspert
21. februar 2002 - 20:36 #4
Have you tried to COMPRESS?
Avatar billede 4444 Nybegynder
21. februar 2002 - 20:37 #5
Yes, and it wont let me
Avatar billede 4444 Nybegynder
21. februar 2002 - 20:39 #6
I have the database on my C: drive, and have tried all I could think of, I even tried to "find and correct errors" under "Help", but nothing!
Avatar billede terry Ekspert
21. februar 2002 - 20:44 #7
OK, one last thing, although I dont think its going to help! Make a new database and then import ALL of your objects into the new database.
You can do this from the Files+Get External Data+Import and then follow the instructions. Hope it helps!
Avatar billede 4444 Nybegynder
21. februar 2002 - 20:47 #8
No, I get the same information.
We have also tried to restart the server by the way.
But thank you anyway for your suggestions.
Avatar billede terry Ekspert
21. februar 2002 - 20:55 #9
It will NOT help restarting the server Access is NOT a dB server like SQL Sever!
Avatar billede 4444 Nybegynder
21. februar 2002 - 21:10 #10
Right, but in a tight spot you'll do anything - logical or not.
I am sure, that the error ocurred while trying to reestablish a link from a word document to adress fields in the database. We might have closed the window, and then tried again in another way - and then the database percieved to sessions were trying to do the same thing.
Can that Jet database engine be JUMP STARTED?
Avatar billede terry Ekspert
21. februar 2002 - 21:15 #11
No, sorry! I have heard of PROF. companies able to find the data again, but I have NEVER seen it done and i have been woking with Access a number of years now.

Backup? no! thought so :o(
Avatar billede 4444 Nybegynder
21. februar 2002 - 21:18 #12
Oh yeah, back-up of cause, but that is a day old, and I think we'll have to go by that tomorrow, but still it is worth trying to save it.
Thanks for your suggestions Terry.
Best regards
Peter
Avatar billede terry Ekspert
21. februar 2002 - 21:36 #13
Your welcome, and good luck!
Avatar billede 4444 Nybegynder
22. februar 2002 - 10:32 #14
We have tried everything, the only thing that worked was to install the back-up from thursday morning, and thus our website is working again, and we only lost data from one day!!
Does anyone know how I take this subject out/delete as it is no more relevant ?
Avatar billede terry Ekspert
22. februar 2002 - 10:38 #15
Well there are a couple of ways, you can accept one or more of the answers (help) you have received, or if you dont think you recieved any help, you place an answer yourslef and accept that yourself.
Avatar billede terry Ekspert
26. februar 2002 - 22:32 #16
4444>You can accept my answer and it gets deleted!
Avatar billede terry Ekspert
04. marts 2002 - 22:17 #17
4444>Theres 100 points hanging around here!
Avatar billede terry Ekspert
29. august 2002 - 08:38 #18
thanks :o)
did you find a solution?
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