Ms Access - SQL

[pekajo]

Hi,
I am thinking of splitting my ms access so I have a ms access front end and sql on the back end, is this possible, and if so can anyone direct me to a youtube or web that explain how to do it in simple terms.
I have my own hosting and know my way around it.
Thanks for amy help.
Peter

 

[Isaac]

Hi,
I am thinking of splitting my ms access so I have a ms access front end and sql on the back end, is this possible, and if so can anyone direct me to a youtube or web that explain how to do it in simple terms.
I have my own hosting and know my way around it.
Thanks for amy help.
Peter

well the first step is to create the tables in SQL server appropriately and migrate data. See this link for some tips.

Move Access backend database tables to SQL

I have an Access application that is linked to some tables in an existing SQL database plus another 148 local tables in a separate backend Access databasae. I would like to move the backend Access tables to the SQL database and then link them back to my application in the hope that the SQL...

www.access-programmers.co.uk