Re: Permissions to allow creation of forms etc?

"JZ" <jj@xxxxxxxxxxxxx> wrote in message
news:P5Gdna5AVsjzRUjeRVnytw@xxxxxxxxxxxx
> Hi,
>
> Thanks so much for your help.
>
> I'm not using the admin account.
> I've limited the admin user and admins group.
> Created a new database from the logged in super user.
> Then as the super user / database owner from the new database removed most
> permissions.
> This was based on the instructions from SecFaq.
>
> This works fine if I'm access the database from a VB program, where I just
> have tables etc.
>
> But I'm trying to provide some user security for access developers.
> (I guess I'll also need to add a normal user without privileges too.)
> So I'm adding as few permissions as possible.
>
> I looked and I already can see system objects.
> When I open any of the system tables I can see the records, values but I
> can alter any of the data.
> I'm guess this must be the problem?
> What permission do I need for that?
>
> Best regards,
>
> Jules.

Try this as a test, reenable the Admin account and/or permissions and rerun
your code. Since your using Jet, the workspace object may still be using
the Admin user (just a guess, but the test should bere this out).
If your still not able to do this then you need to make sure that your
workgroup (.mdw) is being used with the code.

What does your connection string look like?

--
============
Frank Hickman
Microsoft MVP
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.



.

Relevant Pages