I have set up Win2K Termina Server, installed the MS office suite. Users have access to office suite, can access other apps over server fine.
My difficulty is when the local users try to access an access database. I was trying to centralize the database so that anyone making changes would update the database, but permissions keep breaking when a user logs in, they can access the database but all permissions default, then noone can access the database to make changes *except admin of course.*
so i set up a copy of the database in each users profile folder, but i need to link the databases between each profile to update changes across database.
this is where i have difficulty, how do i access the database from each profile so that all changes are made in real time and accounted for across all copies? or is there something i’m missing to have each user access a single database that is centralized on the root drive of the server?
thanks for the help.