In Access 2003 I could create an Access PROJECT as a front end to a SQL
database.

How do I do this in Access 2007 ?

Here's how:

1. Click the Blank Database button in the middle of the Getting Started screen.

2. Access displays the Blank Database task pane where you enter a name for your new database in the
File Name text box.

3. To create a new Access project file, click the Browse button icon.

4. In the File New Database dialog box that appears, select the drive and folder you want by
clicking the links on the left side and browsing to your destination folder.

5. Select Microsoft Office Access Projects from the Save As Type drop-down list to have Access
create an Access project instead of the default .accdb database file.

6. Next, go to the File Name text box and type the name of your new Access project (if you haven't
already). Access appends an .adp extension to the file name for you.

7. Click OK to return to the Getting Started screen.

8. Finally, click the Create button to create your project file.

9. Access displays a message box asking if you want to connect to an existing SQL Server database.
If you click Yes, Access displays a Data Link Properties dialog box where you enter the connection
information for your existing SQL Server database. If you click No, Access creates the project for
you and opens it. For a new project, the Microsoft SQL Server Database Wizard opens and asks you
what SQL Server you want to connect to and what you want to name your new database.

You're on your way!
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conrad...essjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

"Michael Tissington" wrote in message:
news:(E-Mail Removed)...

> In Access 2003 I could create an Access PROJECT as a front end to a SQL database.
>
> How do I do this in Access 2007 ?