If you are going to use Access with ASP then use the MS Jet OLE DB driver instead of the usual ODBC driver, this will return SQL-queries 35 times faster. I think ASP and Access will still be acceptable with 10 simultanious users, you have to decide whether 10 user are going to use the database at the same time. Even with 300 workstations it is very unlikely that exactly 10 users are accessing the database. Use a log to check out!
Frank,<BR> Not to familiar with implementing the Jet OLE DB Driver for Access as you mentioned. How do you reference the driver in your connection string. I am using a DSN-less connection. I am currently using the ODBC, but any performance helps would be great!<BR><BR>Thanks,<BR>Curtis<BR><BR>