E
Epilepsie Montreal Metropolitain
To whom it may interest:
I have a DAO module that implements a sort of autonumber routine
by opening a Table in the same database as the subform, retrieving
the value in the field, and then incrementing it. It was all working
well before I implemented the database security: retrieving an
incremented receipt number each time the subform had a new
record created in it. Now that I have implemented the security
features (just two users, an administrator and a general user), the
subform gives a ...'3033: You don't have authority required to use
the object 'C:\Database Path\DatabaseName.mdb''...
I'm also getting a messagebox from one of the functions in the VBA
module that's causing the problem. (The new database record is
created but there is no receipt number in it's place!)
Could someone tell what is going wrong here, the error is occuring
both for the administrator account as well as for the general user
account.
thanks in advance
Dave H
I have a DAO module that implements a sort of autonumber routine
by opening a Table in the same database as the subform, retrieving
the value in the field, and then incrementing it. It was all working
well before I implemented the database security: retrieving an
incremented receipt number each time the subform had a new
record created in it. Now that I have implemented the security
features (just two users, an administrator and a general user), the
subform gives a ...'3033: You don't have authority required to use
the object 'C:\Database Path\DatabaseName.mdb''...
I'm also getting a messagebox from one of the functions in the VBA
module that's causing the problem. (The new database record is
created but there is no receipt number in it's place!)
Could someone tell what is going wrong here, the error is occuring
both for the administrator account as well as for the general user
account.
thanks in advance
Dave H