Search results

thanks i will check it out

will i need a where?

yea is that possible

lol yea :)

no what happens is a user must enroll (enter a desired username and password) this goes into the database, i want to limit the users enrolling to 10. the users that are enrolled will be able to login by entering the username and password they enrolled with.

yep its my program i developed it.

thats what i want to do i was just hoping someone could tell me the SQL statement command that can do this. is this the right forum for this?

users wont be deleted unless absolutely necessary ( the database has 10 users) because they need access to a secured file. i just want a method or function of somekind that can count the amount of users inserted into the database and when it reaches ten to stop

Sorry but that website doesnt help, i have a program which i created in vc++ it's a login app. when users enroll they get put in the database (username and password) i need a sql statement that checks how many users are in a database if there is 10 then no more people can enroll. i need a limit...

hi, i have a database in access with one table, this table has 2 columns username and password. can anyone tell me how i can detect how many people are in the database - and when it reaches 10, to say database is full please contact admin...:confused:

thanks John Big Booty for all your help :)

i know, ok where can i find it? like what is the normal steps to finding it?

sorry i don't know where it is. do you? what is it called? sorry :confused:

could you tell me the steps to do that please? yea i have made my front end ACCDE.

[/LIST]i have done this already. my question really is how do i put the BE on a server, i dont have an SQl server does Access have one? plus is it necessary for me to do that has this is an assignment for college and i wont actually have any users. however i need to show that i can secure the...

how do i go about doing this? what are the necessary steps?

1: is it normal for the FE database not to show the form and table data when i click on them? because when i do it doesnt open it says not a valid password. this is the DB that interacts with my application (enroll and login). 2: and just to be sure the front end database is the one that has...

ok i have successfully split the database i see the arrow, i have set a password for BE. i have set the form so users cant change the data. however, there is no settings for the table so users can alter the data, i am still able to edit data in the table front n back. will this happen if it is...

i only need one table, i dont even think i need a form. the table has two columns username and password. i have decided to just stick with the database encrypted password to secure my DB. i have given my database the "accdb" format, this is called in my program like so...

hi all, i have done the following: Split my Database into FE and BE BE = Table FE = Form i have 1 table and 1 form, is it possible to update my table through my program i have developed in visual studio and it will also update the form aswell? i am confused, when i open the file that...