If i set up a web page that alows users to set up their own accounts on and i do it using an access database, will i be limitted to how many users i can have or some other tipe of limitation? if so, what will be the limit?
2007-01-30 14:26:43 · 3 answers · asked by Steven B 1 in Computers & Internet ➔ Programming & Design
Not really. The only limitations is that each field size can be no more than 255 characters (ie a username or password could not be longer than 255 characters).
As far as records, unless you get into thousands of records, then Access is fine. More than 1000, you might want to use SQL server. But I have a couple of Access databases with 6800 + records already.
You'd need 1 record per user, with field names like Username, Password, etc.
2007-01-30 22:46:25 · answer #1 · answered by SharpGuy 6 · 0⤊ 1⤋
Access is not the best type of database to use for web access, as there are limitations to the number of concurrent users, I believe around 10. You're better off using something like MySQL to create your database.
2007-01-30 22:36:21 · answer #2 · answered by MamaBean 3 · 0⤊ 0⤋
It is possible, but then you will need a programmer to write .dll files as the second tier of a 3 tier application.
The website would access the .dll file and the .dll file would be the only connection to the database. In that way, the number of users is almost limitless.
2007-01-30 23:50:50 · answer #3 · answered by AJ 7 · 0⤊ 2⤋