• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Microsoft Access Question

S

six_storm

[H]ard|Gawd
Joined
Mar 29, 2005
Messages
1,251
So me and a group of people are making an Access program using forms and whatnot. What we are trying to accomplish is when you run the database, you are prompted to enter a user name and password. This not only gives access to the database, but certain accounts get access to certain information. How would we go about this? It's hard to search for something like this on Google so I thought I would ask here.

Any help would be appreciated.
 
six_storm said:
So me and a group of people are making an Access program using forms and whatnot. What we are trying to accomplish is when you run the database, you are prompted to enter a user name and password. This not only gives access to the database, but certain accounts get access to certain information. How would we go about this? It's hard to search for something like this on Google so I thought I would ask here.

Any help would be appreciated.
Click to expand...

I have to ask, how many people will be using the DB? How big will the DB potentially get? How will they access the DB?

If the answers include "More than 5", "Over 75mb-100mb", and "via a network share", then Access will not be your friend. Access will start to choke and get very slow. SQL is a far superior option. You can get SQL 2005 Express and VB Express for free from MS. It's easy to start with this option than to migrate later.
 
MorfiusX said:
I have to ask, how many people will be using the DB? How big will the DB potentially get? How will they access the DB?

If the answers include "More than 5", "Over 75mb-100mb", and "via a network share", then Access will not be your friend. Access will start to choke and get very slow. SQL is a far superior option. You can get SQL 2005 Express and VB Express for free from MS. It's easy to start with this option than to migrate later.
Click to expand...

...unless you split the db and have a separate front end and back end. Access does support multi-user mdb access, its just not very easy to setup and maintain.

That said, I agree with your that SE2005 is a much better solution of centrally stored mdbs.
 
You must log in or register to reply here.
Back
Top