Upsizing

[broadcast]

Hi everyone,,
i just moved to work in a new company, this company is using access
based databased, I want to upsize the access data base to a SQL server
, and i did that and it working fine, now my problem is, how can i get
the users to access the database on SQL by using an access designed
form, i don't want them to edit tables directly as it doesn't look good
and useful for them,
if anyone can help me i would be very thankful

[ZRexRider]

If you are using MS Access 2000 or greater - create and Access Data
Project (File - New - Project using Existing Data

After you give your new project a name it will prompt you for
connection information.

Fill this information it to access your new SQL database.

Now you are using basically the same Access development tool but the
data and queries are stored on SQL server. As you develop forms and
queries they will be based on this data.

HTH