Can I access SQL database from MS Access

[Khalid_Ghazi]

I have an application developed in MS ACCESS and Visual Basic. Now I want to change the back end database from MS ACCESS to MS SQL sever 7.0. Please tell is there any posibilty to do so without making any major change in the GUI and business logic.

[khawar]

You just import ur Access data base in SQL. and then make DSN with the odbc. this DSN name should be same as ur Access DSN name. then change the properties of ur data access control and link it with ur newly created DSN. it will work fine