I have a database that is used for approval letters for our company - Every once in a while, I have to update. The database is copied to the users computer and links to a SQL database to pull in general information to populate some of the fields on a form.
The user searches for the record they want and it uses the sql tables and one of my own tables (housed in the database)
The user clicks a button and it runs the letter (just a report) For some reason, after this update, the users cannot see the changes I made on the letter. Also, on the form I have a label that says "last updated on 1/25/06" The users still see the old version.
What is stranger is that I post this database on a shared drive and the users copy it from the shared drive to their computer. When I open up the version on the shared drive I can see the updates. Other uses open the same database from the same place and do not see the updates.
We do have some users with access 97 and some with 2000 - I thought it was just the access 2000 users, however, I just found an access 97 user that can't see the updates.
One other thing that might be a cause - I have both access 97 and access 2000 on my computer
Any help would be greatly appreciated!!!
Fred
The user searches for the record they want and it uses the sql tables and one of my own tables (housed in the database)
The user clicks a button and it runs the letter (just a report) For some reason, after this update, the users cannot see the changes I made on the letter. Also, on the form I have a label that says "last updated on 1/25/06" The users still see the old version.
What is stranger is that I post this database on a shared drive and the users copy it from the shared drive to their computer. When I open up the version on the shared drive I can see the updates. Other uses open the same database from the same place and do not see the updates.
We do have some users with access 97 and some with 2000 - I thought it was just the access 2000 users, however, I just found an access 97 user that can't see the updates.
One other thing that might be a cause - I have both access 97 and access 2000 on my computer
Any help would be greatly appreciated!!!
Fred