Run-time error 3033

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I'm getting this error in an app newly imported into A2003 from A97 when a
guest "read-only" account is used. The error reads "You do not have the
necessary permissions to use the 'MSysDb' object." and it is raised when the
app tries to execute the following line:

db.Properties("AppTitle") = "My Database App"

This all worked fine in A97 and I can't find an object of that name in the
hidden or system tables. Any clues?

Many thanks.
Keith.
 
AppTitle is a user-defined property, not a built-in one. So it must
have been created, through VBA code, at some previous time.

The error suggests that the property was created with the 4th (DDL)
parameter of the CreateProperty method. set to True. In that case, the
only users who can change the value of the property, are members of the
Admins group of the workgroup file which was used to secure the
database (or to create the database, if it isn't secured).

So I suggest that you log on as a member of the Admins group, delete
the property, then re-create it with the 4th (DDL) parameter of the
CreateProperty method set to False, and see if that fixes it.

HTH,
TC
 
PS. Please give the error text (as well as the number) in future - then
we needn't waste time looking it up. (And the text often contains
additional information, such as, the name of a table, or whatever.)

TC
 
TC said:
PS. Please give the error text (as well as the number) in future - then
we needn't waste time looking it up. (And the text often contains
additional information, such as, the name of a table, or whatever.)
Click to expand...
Err ... I did TC. :o)
 
TC said:
AppTitle is a user-defined property, not a built-in one. So it must
have been created, through VBA code, at some previous time.

The error suggests that the property was created with the 4th (DDL)
parameter of the CreateProperty method. set to True. In that case, the
only users who can change the value of the property, are members of the
Admins group of the workgroup file which was used to secure the
database (or to create the database, if it isn't secured).

So I suggest that you log on as a member of the Admins group, delete
the property, then re-create it with the 4th (DDL) parameter of the
CreateProperty method set to False, and see if that fixes it.
Click to expand...
Thanks v much TC, I'll look into that.

Regards,
Keith.
 
Back
Top