Upsizing to SQL Server, I lost my forms

[gmazza via AccessMonster.com]

Hi there,
I have an Access 2007 database that has tables, forms, reports etc.
I want to have a Client/Server thing going where I use all the forms in
Access and all the data gets changed, removed, or inserted, in the SQL Server
tables.
I tried upsizing and on the one screen I chose Create a new database, then I
chose Create a new Access client/server application and specified the ADP
file name.
It was all successful and everything is in SQL Server and its all good except
when I open my ADP file in Access, all the forms and reports are gone. What
am I missing here and are there any more steps after this?
Thanks in advance for your help!

 

[Sylvain Lafontaine]

I don't use Access 2007 but I'm surprised to see that your forms didn't get
copied to the ADP project but not that much as the support for ADP in Access
seems to be fading away. However, this is not a big trouble as you can
simply Copy&Paste them from the MDB file to the ADP file.

If you're new at this, you will probably find your life easier if you were
chosing to upsize to a MDB (or ACCDB) database file with ODBC Linked Tables
instead to an ADP project.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)