|
Posted by TonyK on April 11, 2007, 8:42 pm
Please log in for more thread options >
using MS Access to maintain an item list and have a
> > method of synchronizing the data with QuickBooks Enterprise 3.0 (mult-
> > user mode). How can I prevent users in QuickBooks from adding or
> > changing items since the Access database will be used to manage the
> > list of items?
>
> You can't.
>
> Well, at least not and let them still work in the file.
>
> QB permissions system is not all that flexible. User's have access to
> different 'areas' of the program. Giving a specific user access to the
> inventory area, for example,
<SNIP>
Realistically, you have a personnel problem, not a software problem. I
would turn on the dreaded "Audit Tracking" feature, so that you can
confirm which username is misbehaving, and can then be disciplined
appropriately.
If they are making unauthorized/incorrect changes to the database,
this will at least CYA & explain to your boss(es) why you are wasting
so much time fixing things.
Perhaps then, a training class will take place to alleviate your
issues.
Otherwise, as above, you don't have much help for the system.
Good luck,
Tony
|