little more on FE with access
Posted on 2009-05-07
talking with my boss, and trying to explain the down side of server FEs and multi users. i think i might have the ok for doing FEs on local machines instead of folders on a server. hes gonna talk it over with the higher ups and get back with me with an answer. so that brings me more questions.
1. with FEs on local machines, do i ever have a problem with record locking on the shared BE? the way i have it now doesnt seem to have much problem so i dont think so.
2. with FEs on local machines, what would be the best way to set FE and BE options like record locking and exclusive? i dont want people to see popups saying they cant use the thing.
3. if i cant use outside software to update the local machine FEs what would be the best way to handle updates? i thought maybe FE local table with version number that can be compared to a table on the BE that i could place a current version number in. any thoughts?
well lets just start there, im sure ill have more questions later if this goes through. i just want to get this going the best i can and take some time off. thanks....