Multi user support for SQL Server Express 2005

ish · Apr 27th, 2007, 19:32

Hi m8

I would like to use Microsoft SQL Server Express 2005 for my web base application. This system would asp base and will be used my about 25 users.

I have concern, will Microsoft SQL Server Express 2005 support mutliple access, ie more then one users can access data for Insert, update and delete.

many thank

TheSealPortalTeam · May 9th, 2007, 16:51

I just use one user 'default' and have a that user be used to access the username table which contains the passwords and user neame.

I say:: appCode().sqlsvr(127.0.0.1,default,**password**,sq lString)
then:: ('select * from users where username=' & txtusername.text.tostring & "'")

So just have one user that has a all the user information inside the database, you'll find that the easist way of doing it. If you want the appCode() I use to access sql simple and fast just PM me, also I can help you in a lot of ways with SQL, eg shortcuts.