By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,041 Members | 1,734 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,041 IT Pros & Developers. It's quick & easy.

Questions about Login system

blyxx86
100+
P: 256
Is setting up a username/password system very difficult?

What is the code, like Environ(), but specific for the username used to log into the database?

We are going to be using my database at work, and currently I am the only one who uses it, but now the other people want to start using it as well, so I'm thinking of setting up a login system to differentiate each data entry from one person to the other. Will there be sharing issues if we have 15 or so people entering data into the same database? (I would think not, but I have to ask.) Also, is there a way for them to just access one form, almost like a seperate application for the database?

If this goes smoothly, I plan on using the database for other tasks around here that are hefty on paperwork and having them input it directly to a database system.

I am still relatively new to Access, but would like to know which would be better for generating weekly reports based on the information input by the 15 technicians here. Having individual tables for each tech, or changing report or query filter and criteria, respectively.

I am using Access 2000.
Nov 22 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Check out the 'Links to useful sites' thread at the top of the Access forum. There is a very good site there on Access Security.



Is setting up a username/password system very difficult?

What is the code, like Environ(), but specific for the username used to log into the database?

We are going to be using my database at work, and currently I am the only one who uses it, but now the other people want to start using it as well, so I'm thinking of setting up a login system to differentiate each data entry from one person to the other. Will there be sharing issues if we have 15 or so people entering data into the same database? (I would think not, but I have to ask.) Also, is there a way for them to just access one form, almost like a seperate application for the database?

If this goes smoothly, I plan on using the database for other tasks around here that are hefty on paperwork and having them input it directly to a database system.

I am still relatively new to Access, but would like to know which would be better for generating weekly reports based on the information input by the 15 technicians here. Having individual tables for each tech, or changing report or query filter and criteria, respectively.

I am using Access 2000.
Nov 23 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.