Reflex_ht
Registered User.
- Local time
- Yesterday, 23:25
- Joined
- Sep 11, 2012
- Messages
- 64
Hallo,
In the last Weeks we have a huge Problem with our Access DB and I can´t figure out what is wrong
In a Form (Splitform) that displays data from a Table (it is not linked to another; the recrodsource changes depending on a value in a combo box) records sudently started to disapear. With time it is becoming worse
The BE is on a Shared Driver X:\ and the FE also but in seperate Folders for each user.
IT IS NO USER ERROR! I was there when some of the Records just got the value "DELETED" and after a refresh they where not there.
My working on the solution:
1. I was thinking that it is beacuse one user blocks another or overwrites the data of the other so Today we tryed that just one user is working on one table. Stil records are disapearing.
2. Later i Split the 2 Tables for each user on the Local drivers. They are stil working alone in each table and records don´t disapear anymore but because the tables are saved on a local drive no one else can work with them :banghead:
Ofcourse I can´t leav it like this. My question here is:
Is this a Problem in my Access DB and VBA code or Table/Form Settings for multiple users or is it a Network Problem?
The BE was corrupt (especialy the Tables where records disapear). On Fridey I cleaned it up. The tables are not more corrupt but more and more records disapear. Currious is that only recendly added records disapear. Beacuse of that we thing that it could be a network issue witch don´t let access save the data in the BE.
Does someone else had something like this and how could i determinate where the issue is?
THX
In the last Weeks we have a huge Problem with our Access DB and I can´t figure out what is wrong
In a Form (Splitform) that displays data from a Table (it is not linked to another; the recrodsource changes depending on a value in a combo box) records sudently started to disapear. With time it is becoming worse
The BE is on a Shared Driver X:\ and the FE also but in seperate Folders for each user.
IT IS NO USER ERROR! I was there when some of the Records just got the value "DELETED" and after a refresh they where not there.
My working on the solution:
1. I was thinking that it is beacuse one user blocks another or overwrites the data of the other so Today we tryed that just one user is working on one table. Stil records are disapearing.
2. Later i Split the 2 Tables for each user on the Local drivers. They are stil working alone in each table and records don´t disapear anymore but because the tables are saved on a local drive no one else can work with them :banghead:
Ofcourse I can´t leav it like this. My question here is:
Is this a Problem in my Access DB and VBA code or Table/Form Settings for multiple users or is it a Network Problem?
The BE was corrupt (especialy the Tables where records disapear). On Fridey I cleaned it up. The tables are not more corrupt but more and more records disapear. Currious is that only recendly added records disapear. Beacuse of that we thing that it could be a network issue witch don´t let access save the data in the BE.
Does someone else had something like this and how could i determinate where the issue is?
THX
