Results 1 to 2 of 2
2003-07-24, 19:59 #1
- Join Date
- Sep 2001
- SC, USA
- Thanked 0 Times in 0 Posts
Query results differ for users (Access 2000)
An employee has created a database on a shared server (He's done this many times with no problems). Now we find that some of the queries that are based on multiple tables, have several columns that display as empty, when viewed on some of the other user's computers. The queries look fine on two computers, but not on three other user's computers. Supposedly our ITS department upgraded all of them to Access 2000 from Access 97, about 6 months ago. My first thought was that some user's were looking at a different mdb file, so on one computer I opened the database and renamed a query. When I asked the users to open the database, they all saw the renamed query, so they are all looking at the same file. How is it possible for three out of five of them to have this problem?
2003-07-25, 12:52 #2
- Join Date
- Jun 2001
- Crystal Beach, FL, Florida, USA
- Thanked 34 Times in 34 Posts
Re: Query results differ for users (Access 2000)
I gather from what you said that this is a single database sitting on the server. It is possible you could be having a references issue. A better alternative is to use a split database schema. Put all the tables and relationships in a backend database that sits on the server, and everything else goes in the frontend database (and give each user a copy to put on their local disks). There is even a Database Splitter Wizard to help in doing this. This way each user's copy will have references set to the various libraries on its computer; plus it solves/prevents a host of other problems.