Unanswered: locking issues, access 2k3 w/ win2k3 server
I'm seeing some strange things here, since we upgraded our file servers from win2K server to win2k3 server.
Databases that were once usable by multiple users (3-5), without any locking conflicts, seem to experience constant locking conflicts.
Even a project of my own, which is only usd by 2users aside myself, has locking issus. As if the entire database is locked rather than the individual table or record.
Queries are - as always - primarily optimistic / dynamic, and haven't been changed for ages.. so I'm really in a fuzz here.
Most of the databases are all very small, (< 2 mb).
Any ideas / suggestions?
IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....