I hope someone can help. I have a database that had been running for years and it is sick. Here is what is happening. When user 1 logs in to the database it works fine but when user 2 logs in , the database just sits there and when access finally starts then the table become corrupt. If user 1 logs off then user 2 access starts immediately.This started when we went thru an upgrade with our server and Access. We were running XP office 2007 on Dell server with Windows OS 2006. We are now running Windows7 pro with new Dell server.
I have a FE on desktops of user 1 and 2 with client settings set to shared. I have a BE on the network folder set to full privileges. I have tested with simple form and simple table with same results.
Any Ideas ?