how to create users in form

still_rookie

Registered User.
Local time
Tomorrow, 01:16
Joined
Apr 17, 2005
Messages
122
hey guys,

i just needed a guide on how to create a form with different users in it.

also, is there a way in which i can create a button that will open the wizard to create a report ??

[guess wat, no deadline.... but that doesn't mean dont answer ;) ]

hope a reply soon..

thanks in advance.
 
Last edited:
If you mean you want to have different levels of access to certain forms then look up "workgroups"

Why would you want to have a wizard create a report from a button? are you saying you want the users to do this?

Col
 
umm sort of.

wat i want to do is create different levels of users but they all access only 1 form. I have made 1 form, through which the user can access everything, i.e. tables, queries, forms etc. BUT, the thing is that all this information is confidential, so there will be only 1 user, who can access the tables, as they will contain all the records, create new users, etc, and one who can only access the forms and 'create reports'. But as this user will be computer illitrate (sortof, but will know basics of access) he wont know how to create reports in design view. Plus, i want to make it more secure by removing the close, minimise, and maximise button, which ive already managed to figure out. which is why i want to create a user and also will need a button to open report wizard.

thnx.
 
cmon guys.... 48 views, 1 reply ??? u gotta be better than that .... :rolleyes:
 
Your db should be designed so that the users can not access the db objects. The users should not be able to directly open a table or open a form in design view. The users should only be able to access the data through your forms.

You have a lot more work to do with the design of your db so that the user is only able to access the data without accessing the db objects.

Using Access security [workgroups and permissions] will allow you to set the security of your db so that the users can only access what you allow them to.
 
yes ok but i want to know how to create users in the first place :confused:
 
What's wrong with using the Access Help that actually comes with Access?
 
ok this is what is says :

---------------------------------------
CREATE USER or GROUP Statement
Creates one or more new users or groups.

Syntax
Create a user:

CREATE USER user password pid [, user password pid, …]

Create a group:

CREATE GROUP group pid[, group pid, …]

The CREATE USER or GROUP statement has these parts:

Part Description
user The name of a user to be added to the workgroup information file.
group The name of a group to be added to the workgroup information file.
password The password to be associated with the specified user name.
pid The personal id.
---------------------------------------

Now its not clear. It doeesnt tell me where i should add the statement (CREATE GROUP group pid[, group pid, …]) i.e. if it is a statement of VB. And it also doesnt tell me what exactly i should put in....

which is why i asked you guys.... :(
 
U Gizmo - couldn't you just do all that opening the report preview anyway?
 
Something like this in Report Open event works

Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = "SELECT * FROM Table2;"
End Sub

Am I missing something important.

Paul
 
ohkay... i will try to work my way through this now, but will let you know if any problems arrise.

Thanks so much for your time ! :)

(Mods, please don't close this topic as i might return:D )
 
can someone please give me step by step instructions on how to create users in MS access XP ?

Beacuse i don't know visual basic, at all, and whatever you guys say doesn't get into my head, so i have to ask my teacher. So please if some1 can, it would be massively appriciated.

thanks !
 
Securing an Access database with user level security is difficult, and will require significant time and energy on the part of someone who may want to offer you step-by-step assistance. Two things I can offer that might help:
1) Don't be demanding. It's a turn off.
2) Research your own problem. Demonstrate first that you've done a pile of work on something, and people will line up help you push it over the top.
Hope this helps now, and in the long run.
 
demanding ?

what tould you do on a forum when there have been 300 views and no replies ? This is litrally the most unhelpful forum i have ever been to, because :

1. People are more bothered about, lets say, the appreance of the forum, as, some people complain about slang, some of you complain about urgency, instead of actually posting something useful and now you say im demanding, when after looking at my posts several times, you could even say if you understood or you didn't -
but I knew that if I said something it would probably be inappropriate!
Why dont you guys go back and tell me, how much appropriate and USEFUL information has been provided ? Also check my 1st thread -

http://www.access-programmers.co.uk/forums/showthread.php?t=85127

2. Why in god's name would i even come here if i found what i needed in my "research" ????? So think before you post please.

3. Harldy anyone on this forum is polite enough, even the mods are not polite.. Ive been through some posts and the mods are exceptionally rude... This is not the way forums work.

This is very unprofessional stuff, and i can find better access forums on the net. So tell you what.. i think im gonna leave.

BTW, check out the www.invisionize.com if some of you haven't already.... That is the way forums should work. Every post is meaningful. Not talk about peoples attitudes n go off topic. sigh!

:mad:
 
Just had to chime in, even though still_rookie has probably packed the bags and is headed out on whatever forum they feel is polite, even though the tone of their messages have been below par.

Even though my name shows being here since 2001 (because of the move of the forum from one forum program to another back then), I've been here since 1997 and while we do experience the occasional "rude" request or response, I have been completely satisfied with this forum over others.

When we have resources such as Pat Hartman, who always amazes me at how many questions she answers and still does work, I am very thankful and appreciative. As in the post in the General Section on how to ask questions the smart way (http://www.access-programmers.co.uk/forums/showthread.php?t=85042), it amazes me how many people try to use the wrong way of asking for help. It DOES NOT MATTER that 300 people viewed a post and didn't respond. That should either tell you that it's likely that the question is extremely difficult or that it was not asked properly to begin with. So, not everyone here is an "expert" on Access. But, we do our best to share our experiences with others , so that may require some "experimenting" and for someone to come expecting that we will just drop everything we do to answer their question is ludicrous.

So, hopefully still_rookie finds what they are looking for, but as for this forum, I will not be sad to see the smee HEE go.
 
still_rookie said:
what tould you do on a forum when there have been 300 views and no replies ?

This is a perfect example of why using (as near to) perfect English as possible is the best method of communication on a forum where the common language is English. I have no idea what that question is asking. Is tould supposed to be told or could?

Also, not every user of an English speaking forum is a native English speaker. Using slang, text speak, and colloquial phrases mean nothing to them or don't translate correctly so it should be avoided. Why shun the help of a native Spaniard or Dutchman if you use British slang which isn't taught in ESOL (English for Speakers of an Other Language) textbooks.

1. People are more bothered about, lets say, the appreance of the forum, as, some people complain about slang, some of you complain about urgency, instead of actually posting something useful and now you say im demanding, when after looking at my posts several times, you could even say if you understood or you didn't

Let's address these one by one:

People are more bothered about, lets say, the appearance of the forum

I don't know what you mean here but there are certain things which are beneficial upon a forum when done right. Asking a question: it's important to ensure that you get as much detail about your problem into the title of the thread rather than just typing something unhelpful as urgent, help needed. The reasons?

1) Most people will look at threads that interest them. They might see a thread called Looping Through A Recordset with ADO and decide to read it because ADO is something they know they can help with. Using urgent as the title says nothing about the problem and means that people have to open the thread to see what the hell it is about - and this is also one of the reasons for the high views, low replies. ;) Another reason is that bots indexing the forum for their respective search engines view each thread as they spider through the forum - these bots, who obviously can't help, add to the total of views.

2) The forum is not just about helping one person with their problems. It's about helping everyone. It's a well known fact that people run into similar problems when using tools such as Access and the good forum user knows to search the forum's archive (and the web) to see if the problem has been solved before. The search function, though, is only as good as the title of the threads. It's this that most searches are performed upon so while many might search on looping+ADO+recordset you won't find too many (or any) that use urgent as their search keyword.

2. Why in god's name would i even come here if i found what i needed in my "research" ????? So think before you post please.

But what "research" have you actually done? You are more likley to get help if you can demonstrate what you understand about the problem, what you have tried, what results that you have got and why they are wrong. This demonstrates that you are actually trying to solve your problem and not just expecting an answer to something you can't be bothered either doing or learning. The more information you can offer then the more accurate and authoritative the information that can be returned.

3. Harldy anyone on this forum is polite enough, even the mods are not polite.. Ive been through some posts and the mods are exceptionally rude...

The forum has been online for a number of years and there is a great feeling of community here - some people have even taken the time to meet up in "real life". It is full of professional people with jobs who still come here when they can to help others and what precious time they offer is a godsend. I, and others, give of a great deal of our time to help people on this forum and your initial post asking for a response "by Friday" did nothing but belittle the efforts given. You are looking for free advice so that means there's no guarantee you will get any and you certainly can't expect any or give orders.

So, you think the mods are rude. I assume you are referring to me since I think I'm the only mod that has dealt with your posts. I don't consider myself rude - only blunt. I'm busy; I don't have time to pander to people.

This is not the way forums work.

Since you don't know how to express yourself on a technical forum and how a technical forum should work - technical, not some random chat forum - I can consider this a pointless comment.

This is very unprofessional stuff, and i can find better access forums on the net.

Go find them then. You'll probably find me and many others here on them too. Small world, eh? ;)

BTW, check out the www.invisionize.com if some of you haven't already.... That is the way forums should work. Every post is meaningful. Not talk about peoples attitudes n go off topic. sigh!

Ok, I've checked out Invisionize and I fail to see your point. They have their own list of guidelines (see here) for posting which you obviously haven't read. Funnily enough they suggest you explain your requests with as much detail as possible. So, to get all syllogistic: that forum requires detail to get answers/replies, this forum requires detail to get answers/replies, so that must mean that this forum works just the same as that forum.

Talking about people's attitudes is important as it's accepted (n)etiquette - we're busy people. We don't need crap from people who treat the forum's community as a resource solely for them. See my previous comments about every question being for every user of the forum - even those that are yet to join or know the forum even exists.

I hope you get your answers - Access security, as has been stated, is a very big subject. I suggest finding information about it from the Microsoft Knowledge Base*, reading the information and coming back with specific questions and showing some proof of using your initiative to solve your problem.

Personally, I don't use Access Security. I prefer to create a table of users, their username, and a field for password, and use the Environ function as the database opens to validate them as a user. How does this method sound? It's a lot easier than getting bogged down in Access Security.

* If I remember correctly, there is a downloadable document somewhere in the Knowledge Base that takes you through some security information/tutorials.
 

Users who are viewing this thread

Back
Top Bottom