Using Access as Front end & SQL server 2003 as back end

[premMS143]

Hi,

I want to create a new MS Access file as Front end & SQL Server 2003 as back end. This server is located in somewhere in a network. User can retrieve data from Server in Access, view it, print it & for any modifications i.e. to update/save in Server, user credentials are required.

Anyone guide me regarding this please...


regards,
Prem

[vb5prgrmr]

File>Get External Data>Link Tables... You will however have to create an ODBC DSN to the SQL server instance...



Good Luck