MacroScope
Programmer
I have a 25 station Access 2007/SQL Server 2012 db that has developed an annoying glitch. One particular table, called Processors, which holds name, user name, phone numbers, and other data for processors on the floor is intermittently changing the name of a processor from the correct name to another name on the list. Of course I know the table isn't doing that, but somewhere something is telling it to write over the name of person A with that of person B.
The problem is that it is extremely intermittent (sometimes a week or 10 days can go by between occurrences), and therefore it's very difficult to track down where it might be coming from. Someone tries to access their name from a list, finds it isn't there, and then I get a phone call. I thought of a work around that I believe will solve the problem quickly and effectively without hours of searching.
The only time that table is supposed to be written to is when the AddProcessor form is open. It seems a relatively simple task (for someone who knows how) to write code that makes the table writable on opening the form, and then run other code that makes it read-only again when the form is closed. If I get error messages when the problem code runs, that's fine, because it will direct me to where to look to solve it.
Can someone suggest a way to accomplish this thru VBA?
As always, thanks in advance for your help.
The problem is that it is extremely intermittent (sometimes a week or 10 days can go by between occurrences), and therefore it's very difficult to track down where it might be coming from. Someone tries to access their name from a list, finds it isn't there, and then I get a phone call. I thought of a work around that I believe will solve the problem quickly and effectively without hours of searching.
The only time that table is supposed to be written to is when the AddProcessor form is open. It seems a relatively simple task (for someone who knows how) to write code that makes the table writable on opening the form, and then run other code that makes it read-only again when the form is closed. If I get error messages when the problem code runs, that's fine, because it will direct me to where to look to solve it.
Can someone suggest a way to accomplish this thru VBA?
As always, thanks in advance for your help.