USING SQL Server back End for MS ACCESS Database Front End
Gents,
i Have data base (MS ACCESS) that will work in home server with more than 250 Users the Size is 84,816 Kb but this will increase to achieve 1 GB i did not finish the project yet
to Avoid data Rupture I Want to use SQL Server for Back end will reside into the server and front End linked to each computer what kind of SQL server Product can I Use and how much does Cost to buy is there a free down load or a trial please i need your help
What function are you looking for?. SQL Management Studio is the tool you have to use to access SQL Express database. It does not provide query or reporting interface like Access, but you can still use Access as front end and SQL Express as backend to store the data.
You need to transfer all your tables from Access to SQL Express using Import wizard in Management studio then create links to those tables in Access.
What function are you looking for?. SQL Management Studio is the tool you have to use to access SQL Express database. It does not provide query or reporting interface like Access, but you can still use Access as front end and SQL Express as backend to store the data.
You need to transfer all your tables from Access to SQL Express using Import wizard in Management studio then create links to those tables in Access.