>You can use sp_grantlogin system stored procedure to grant permission to other domain users. example: sp_grantlogin 'DOMAIN_NAME\username'. You can use it through sqlexec() function of VFP.
>
>By the way you can customize your MSDE installation to use SQL Authentication during installation by putting this entry on the "Setup.ini": SECURITYMODE=SQL. For more information about customizing MSDE installation please go to this link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp. Note that you need to use "sp_addlogin" system stored procedure if you want create a user with SQL Server authentication. If you want you can create a utility to manage permission of your MSDE database.


Thank you so much. When I installed the MSDE there was so much information in the setup instructions that I did not really understand everything and missed this. So now I uninstalled MSDE and reinstalled with that option and it worked fine. Note that a simple uninstall/reinstall did not work. I ended up manually deleteing the database files and also the registry settings before it would accept a reinstall.