Access Client Server Model Plan

[JMichaelM]

Anyone have a sample front end access interface with back end SQL Server client server model plan template or sample as a guideline or have a resource I can look at?

Thanks

 

[Ranman256]

All you need to do is connect the BE tables via ODBC links.

 

[boerbende]

let Access create an example. take a copy of you access accdb (or mdb) and click on database tools, SQL server. It is a wizard which worked pretty good in my case

 

[JMichaelM]

What about the interface search forms etc?

 

[Minty]

They don't change - all you are doing is moving your data tables to SQL and then your front end database (Access) connects to them as linked tables.