05. november 2004 - 17:10Der 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..
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.
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
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
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.
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.
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.