|
|
|
| The staff use MS Access 2000 and XP Home edition
The databases are shared over a Windows 2003 server.
Each database is from 6 to 11 MBs.
Just in the last several months a strange thing is happing.
Staff will enter a date in a date field and several days later
they notice the date is gone. They might enter a date on several records
and a couple of days later all dates they entered on that day are gone.
Any ideas ????????????
| |
| Jerry Whittle 2006-01-26, 5:01 pm |
| In order of likelihood from past experience.
1. They never actually put the data in there in the first place.
2. Someone deleted or changed the data.
3. The data is there but can't be found by the forms, reports, and queries
as they are now written.
4. The database is written badly with something like unbound forms not
saving the data.
5. Users are working in different database files.
6. Actual database corruption; however, you should be seeing other problems.
7. Someone is replacing the database from backup files.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"Rick" wrote:
> The staff use MS Access 2000 and XP Home edition
> The databases are shared over a Windows 2003 server.
> Each database is from 6 to 11 MBs.
> Just in the last several months a strange thing is happing.
> Staff will enter a date in a date field and several days later
> they notice the date is gone. They might enter a date on several records
> and a couple of days later all dates they entered on that day are gone.
> Any ideas ????????????
| |
|
| thanks for you help
"Jerry Whittle" < JerryWhittle@discuss
ions.microsoft.com> wrote in message
news:F40F6997-9FB2-43BB-BE9A- 4FE05C9C3883@microso
ft.com...[color=darkred]
> In order of likelihood from past experience.
>
> 1. They never actually put the data in there in the first place.
>
> 2. Someone deleted or changed the data.
>
> 3. The data is there but can't be found by the forms, reports, and queries
> as they are now written.
>
> 4. The database is written badly with something like unbound forms not
> saving the data.
>
> 5. Users are working in different database files.
>
> 6. Actual database corruption; however, you should be seeing other
> problems.
>
> 7. Someone is replacing the database from backup files.
> --
> Jerry Whittle
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Rick" wrote:
>
| |
| Ian Davies 2006-01-30, 8:25 pm |
| Hello
You say
>Each database is from 6 to 11 MBs.
If you have many databases I suspect there is confusion and your users are
inputting to different databases to each other and possible opening
different databases each time. So data looks like its missing but is infact
on another database.
Question
Can you simplify things by just having one system consisting of a single
back end database storing ALL data and individual front ends on each users
machine. This is the standard approach for multiuser systems
Ian
www.iddsoftware.co.uk
"Rick" < rfidler2004spam@eart
hlink.net> wrote in message
news:%23$zbBzoIGHA.1312@TK2MSFTNGP09.phx.gbl...
> The staff use MS Access 2000 and XP Home edition
> The databases are shared over a Windows 2003 server.
> Each database is from 6 to 11 MBs.
> Just in the last several months a strange thing is happing.
> Staff will enter a date in a date field and several days later
> they notice the date is gone. They might enter a date on several records
> and a couple of days later all dates they entered on that day are gone.
> Any ideas ????????????
>
>
>
>
>
| |
|
| Yes awhile back I had one back end and the front end on the individual
computers.
But now we have several offices so I had to put them together.
We have been using the MS Access 2000 for several years and never had that
problem.
The only thing that has changed is several of our staff now use Dell XP Home
Edition computers and I set them up as limited users.
"Ian Davies" <iandan.dav@virgin.net> wrote in message
news:EjwDf.72837$Dg6.28709@newsfe3-gui.ntli.net...
> Hello
> You say
>
>
> If you have many databases I suspect there is confusion and your users are
> inputting to different databases to each other and possible opening
> different databases each time. So data looks like its missing but is
> infact
> on another database.
>
> Question
> Can you simplify things by just having one system consisting of a single
> back end database storing ALL data and individual front ends on each users
> machine. This is the standard approach for multiuser systems
>
> Ian
> www.iddsoftware.co.uk
>
>
>
> "Rick" < rfidler2004spam@eart
hlink.net> wrote in message
> news:%23$zbBzoIGHA.1312@TK2MSFTNGP09.phx.gbl...
>
>
| |
| Ian Davies 2006-02-03, 1:24 pm |
|
> Yes awhile back I had one back end and the front end on the individual
> computers.
> But now we have several offices so I had to put them together.
Do you now only have one database that all users are using? If so the other
thing that could be causing problems may be the system dates on each
computer. Access uses the system date as the current date so if there are
any calculations using dates etc this could be creating invalid dates which
may result in them not being stored.
Check the system dates to make sure they are set to the current date and
time
> We have been using the MS Access 2000 for several years and never had that
> problem.
Then it must have resulted from a change you made to your database(s)
recently. Retrace your steps undoing each one, one at a time until the
problem goes away. You should then be able to work out what caused it.
> The only thing that has changed is several of our staff now use Dell XP
Home
> Edition computers and I set them up as limited users.
temporarily disconnect them and put in the old pcs if possible to see if the
problem goes away. If it does then you can be certain that the XP home
edition is the problem (or the hardware - but i cant see how). You will then
have to investigate further to see if others have had similar problems with
this combination (I havent heard of anything myself)
Ian
> "Ian Davies" <iandan.dav@virgin.net> wrote in message
> news:EjwDf.72837$Dg6.28709@newsfe3-gui.ntli.net...
are[color=darkred]
users[color=darkred]
records[color=darkre
d]
>
>
| |
|
| Thank Ian
"Ian Davies" <iandan.dav@virgin.net> wrote in message
news:UcNEf.6248$K42.976@newsfe7-win.ntli.net...
>
>
>
>
> Do you now only have one database that all users are using? If so the
> other
> thing that could be causing problems may be the system dates on each
> computer. Access uses the system date as the current date so if there are
> any calculations using dates etc this could be creating invalid dates
> which
> may result in them not being stored.
>
> Check the system dates to make sure they are set to the current date and
> time
>
>
>
> Then it must have resulted from a change you made to your database(s)
> recently. Retrace your steps undoing each one, one at a time until the
> problem goes away. You should then be able to work out what caused it.
>
> Home
>
>
> temporarily disconnect them and put in the old pcs if possible to see if
> the
> problem goes away. If it does then you can be certain that the XP home
> edition is the problem (or the hardware - but i cant see how). You will
> then
> have to investigate further to see if others have had similar problems
> with
> this combination (I havent heard of anything myself)
>
> Ian
>
>
>
>
> are
> users
> records
>
>
|
|
|
|