Can Access be used as Front End

Hi,

Can i use access as front end and connecting with the Mssql database.

Any help?

Thanks

Yes you can. You will need to link the backend tables to your frontend. This can be done by right clicking in the database window and selecting Link Tables or navigating to File-->Get External Data-->Link Tables. There are numerous techniques that you could apply to refresh links (using code or manually), which needs to happen if the table structure changes, but this will at least get you started.