I have a database that I want to convert to SQL server. I am using Access 2010 and used the Upsizing Wizard but I don't know if I used the right settings. Can anyone tell me the correct way to do this? I don't know if I should leave it connected to the access database in case I need to make changes?? I want to be able to setup users and limit their access to certain parts. I know how to create logins but how do I incorporate them into the database so that when the application is opened it will prompt them for username and password??
Any help will be appreciated.