View Single Post
  #2 (permalink)  
Old May 9th, 2007, 16:51
TheSealPortalTeam's Avatar
TheSealPortalTeam TheSealPortalTeam is offline
User of Users

SuperMember
Join Date: May 2007
Location: Buffalo
Posts: 271
Blog Entries: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Multi user support for SQL Server Express 2005

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.
Reply With Quote