Access 2002 & 2000

[Hagan]

I created an access databse for tracking events by employee. I have an
assistant who is helping me input information which was working fine. I have
Access 2002 and she has 2000, so I converted the DB to 2000. Yesterday, we
found that some of the informaiton that I input is showing up on her side and
that none of the information that she inputs is showing up on mine. This is
the first time that this is happening. Any suggestions? We restared the DBs
and the computers and let it sit overnight.

 

[John W. Vinson]

I created an access databse for tracking events by employee. I have an
assistant who is helping me input information which was working fine. I have
Access 2002 and she has 2000, so I converted the DB to 2000. Yesterday, we
found that some of the informaiton that I input is showing up on her side and
that none of the information that she inputs is showing up on mine. This is
the first time that this is happening. Any suggestions? We restared the DBs
and the computers and let it sit overnight.

Are you certain you're both using the same database? Or is she entering data
into a copy on her computer, and you into one on yours??? (Sometimes the
trivial solution...)

If you're sharing the same database, you really should use a "split database"
- a backend containing the tables on a shared folder, and two frontends with
links to the tables on each of your computers. See
http://www.granite.ab.ca/access/splitapp.htm for a description of the process.

John W. Vinson [MVP]

 

[Hagan]

We are both entering into the same db and for the past 6 months there have
been no problems. This just started this week. I did multiple test to be sure
that we are in the same db and some of my information is transfering to her
and non of hers is transfering to me.

 

[Douglas J. Steele]

If you're using the same database, there's no concept of "transferring" data
between users: it's all in the same table.

Is it possible that you've got a filter on the form that happens to
eliminate certain data? Either that, or is the form's RecordSource a query
that doesn't return all of the data?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

 

[Guest]

It's not completely impossible to have corruption like that,
but it is very unlikely.

Remember that it takes a couple of seconds (5-10) for
stuff that she writes to show up on your PC.

Make a back up copy. Check that all service packs have
been applied to both machines. Make a new 2000 database.
Open the 2000 database and import everything into it from
the old 2000/2002 database. Compact. Move the database
to a different location, on a different pc, or on a different server.

(david)