ASP.NET, SQL Server, WPF, C#, VB.NET

I'm trying to convert a complex .MDB database into .ADP.  This is all new to 
 
me so I'm learning.  I have read here that ADp files don't have data.  If 
 
this is so, where is the data?  Currently all my data resides on an MDB file 
 
(I long ago split the code from the data).  What do I have to do to get those 
 
tables onto the SQL server so my MDP front end can see/connect to them? 
 
Please be very clear with your answer as this is all very new to me. 
 
Thanks,

You're familiar with the concept of splitting the database. Well, an ADP is 
 
the same kind of architecture, except the backend is SQL Server, instead of 
 
Access. In an ADP, the tables (and data), and views (queries) are in SQL 
 
Server. You will also have access to stored procedures (which are not 
 
present in Access), and database diagrams (although Access offers a single 
 
relationships diagram, SQL Server allows you to create many more of them). 
 
To get your data into SQL Server, it's probably easiest to import your 
 
backend tables to your frontend, then use the Upsizing Wizard (Tools | 
 
Database Utilities | Upsizing Wizard) to get them into SQL Server. 
 
Regards, 
 
Graham R Seach 
 
Microsoft Access MVP 
 
Sydney, Australia 
 
--------------------------- 
 
"RoyS29" <RoyS29@discussions.microsoft.com> wrote in message 
 
news:32D4C8B8-DBB2-4881-BFFA-5514F961635C@microsoft.com...