how to convert.mdb to .adp for SQL server 1

[Rousseau10]

how to convert.mdb to .adp for SQL server

I want to use access as front end app for SQL server.

can someone explain how to set this up. I took a class and the instructor showed this and I could see in access how the datatype of the table turned from text (access data type) to varchar (sql data type).

Now I need to do it 4 real
TANX

 

[PHV]

The migration to SQL Sever wizard ?
menu Tools -> Database Utilities ->

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Rousseau10]

your the wizard!!
Tanx!

I was the first American Soldier to put a basketball hoop up in Iraq, only to have it stolen by a soldier from different camp. Newbee - Adam