Using Access to Create SQL Server Databases
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
In Microsoft® Access, you can create an Access data project (ADP) that connects to a database residing in Microsoft® SQL Server™. When you are in an ADP, the Access database window shows information about views, database diagrams, and stored procedures that are available in the SQL Server database.
**Note **If you have an existing Access database you want to use for a workflow application, you must use the Access Upsizing wizard to convert it to a SQL Server database. Then, you can use the Workflow Designer to add workflow and row-level security to your application.
To create a SQL Server database using Access
Open Access.
Select Project (New Data) from the New File window.
Give your project a name, click Create, and follow the steps in the wizard.
**Note **To complete the wizard, you must specify a SQL Server. If you do not have Database Creator permissions on that SQL Server, the wizard will not be able to connect and create a database.
When the wizard finishes, you can add tables to complete the design of your schema in the Access Database window.
See Also
Creating Workflow Applications from Databases | Creating SQL Server Database Tables