Avatar billede teatertt Nybegynder
05. november 2004 - 17:10 Der er 9 kommentarer og
1 løsning

kan ikke genkende filsystem - Access

jeg har en database på et netværk med tre maskiner der er forbundet til en server med data (Tabel.mdb) .. ca en gang om ugen melder den fejlen "kan ikke genkende filsystem" - så skal man reparere og komprimere Tabel.mdb - er der nogen der kan give et bud på hvad det er der går galt - har snart prøvet alt..

TT
Avatar billede terry Ekspert
06. november 2004 - 10:06 #1
This is a typical problem when a databases is shared over a network.
You should try splitting the database into a backend (tables/queries) and a frontend (forms/reports etc.)
The backend is placed on the server, and users have a copy of the front end on their own PC.
Avatar billede terry Ekspert
06. november 2004 - 10:07 #2
Its also possible to place the fronmtend on the server too, but I prefer this setup.
Ther is  awizard for splitting your database into a frontend backend
Avatar billede terry Ekspert
06. november 2004 - 10:08 #3
awizard = a wizard
Avatar billede terry Ekspert
06. november 2004 - 10:10 #4
If you are opening the database using code in a VB program (for example) then make sure that you close the connections when you are finished with them. Not closing them can corrupt the dB
Avatar billede teatertt Nybegynder
06. november 2004 - 10:11 #5
Hi Terry
I have allready split the database in front/back-end
any other ideas??
Avatar billede terry Ekspert
06. november 2004 - 10:17 #6
Morning! Its important that users close down the application correctly, and dont just turn off their PC, and also if you are using recordsets in VBA code then it is very important the clean up (close) the connections after use. It may also be a problem with the network!
I'm off out for an hour or so, will take a look later.
Avatar billede teatertt Nybegynder
07. november 2004 - 08:23 #7
HI Terry
I have allready changed ex:

    Dim rs As Object

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[KundeID] = " & Str(Me![Kombinationsboks6])
    Me.Bookmark = rs.Bookmark

To:

    Dim rs As Recordset
    Set rs = Me.Recordset.Clone
    rs.FindFirst "[KundeID] = " & Str(Me![Kombinationsboks6])
    Me.Bookmark = rs.Bookmark
    rs.close

and it was running without problems for a while (two weeks) but  suddenly the other day it started again..
Avatar billede terry Ekspert
07. november 2004 - 10:06 #8
your code looks fine, you could add

set rs = Nothing

but its not necessary.

I dont think your database is the problem as long as users are terminating the program correctly, and not for example via the task manager. You could ask them to verify this. So I would take a closer look at the network.

If possible try compacting/repairing the database (backend) once in a while. You could have a job which runs each night do do this.

You could also concider have MSDE (SQL Server) as you backend. Its a cut down version of SQL Server, max 2 Gb data, which is the same as Access and optimized for 5 connections, which should be OK in your case.

This will also help in performance.
Avatar billede teatertt Nybegynder
09. november 2004 - 08:28 #9
I will concider to use MSDE... I will go over my progamkin once more..  Thanks for your advises -
Avatar billede terry Ekspert
09. november 2004 - 19:04 #10
thanks!
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