Stopping Users Importing Queries into new database

[Guest]

Hi,

I've written an Access database using XP, but converting it to 2000 so my
collegues can use it on older MS versions, and while i want users to add data
to it I don't want them accessing Forms, Queries and reports in Design View.

I've secured the main switchboard by creating a module that stops bypassing
by using the Shift key on entry. My problem lies in that anyone can open a
new database, copy my original and then has access to my queries, forms etc.

I'ver followed the suggestions on both Jack Macdonalds and Joan Wilds
brillaint web pages but in my frustration must have missed some steps. I
have changed ownership of every thing to my "Super User" and tried numerous
attempts at different permissions

Also I found that by stopping all the Users permission they can't get into
the database at all.

I've looked at MDE files (allbeit fleetingly) but can still import queries
into
a new database and have total access.

Any help would be really appreciated

thanks

Annette

 

[Douglas J. Steele]

Already answered in another newsgroup to which you posted the same question.

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)

If you're using Microsoft's web interface to post, I believe that you can
type the names of the various groups into the Newsgroup box. Separate each
newsgroup name with a semicolon.

Note that it's generally consider to be A Bad Thing to cross-post to more
than about 2 or 3 newsgroups. (In fact, at
http://www.microsoft.com/presspass/features/2001/Mar01/Mar27pmvp.asp
Microsoft suggests that "One group will suffice")

See http://www.mvps.org/access/netiquette.htm for more information.