MS Access (office 97)

We are using windows 7 laptops with MS Access Office 97.
on the database is on our server.
On 2 of the machines when the form of the database is updated they show the new form.
on the other 2 machines keep showing the old form no matter what we do. The data is up to date but the form is still the old one!

any ideas please
samcoryAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Sounds like your pointing to two different copies of the database, or something within the app displays a specific form based on the station and/or user.

There's nothing in Access itself that would cause that.

Jim.
Dale FyeOwner, Developing Solutions LLCCommented:
New form?  Does that mean that you are still developing in A97?

I agree with Jim, it sounds like the 4 machines are not all using the same front-end.

Maybe it is time to upgrade from Access 97 to something a little newer?  we are now on the seventh (2000, 2002, 2003, 2007, 2010, 2013, 2016) version since A97.  I don't even think there is a good upgrade path for the application at this point.  I think you would have to find a copy of 2003 somewhere and upgrade the front-end from 97 to 2003, then migrate from 2003 to one of the newer versions.

This would not be trivial as all declarations of things like recordsets, tabledefs, querydefs would have to be recoded to use the DAO prefix, but it would catch you up with the times.
samcoryAuthor Commented:
We cannot change the version.


We make changes to the database form on the server  and then copy the .mdb file to each computer



2 of the machines will show the new form.
The other 2 keep using the old form (although the actual tables are up to date)
We have tried deleting the folder and then copying the .mdb file up again but it still shows the old form!
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<We have tried deleting the folder and then copying the .mdb file up again but it still shows the old form!>>

 You must have two copies.....open explorer on one of the stations and do a search of the C drive for *.MDB.

 Bet you find two copies<g>.

JIm.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"We cannot change the version."
The longer you wait. the more difficult it will be in the future - if even possible.
Just sayin' ...
samcoryAuthor Commented:
You were right there was a copy in c:\users\theuser\appdata\virtualStore
Once I deleted it all worked correctly.
Thanks for your help
Sam
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.