how to convert.mdb to .adp for SQL server

[Rousseau10]

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)

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

 

[Catadmin]

Not having done exactly this before, I'm going to shoot in the dark. (Someone correct me if I'm wrong).

I think you need to set up Access as a Linked Server in SQL or use some sort of Access code with an ODBC connecting to SQL.

Either that, or you could do it the hard way by using DTS to transfer data (and transform it from one datatype to another) from Access to SQL on a regular database.



Catadmin - MCDBA, MCSA
"Just because I'm paranoid doesn't mean the universe *isn't* out to get me!"