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

 

[Uncle Gizmo]

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 found the "Andrew Couch" book very useful regarding SQL Server and many other things, indeed it's an excellent book!

Microsoft® Access® 2010 VBA Programming Inside Out
Publisher: Microsoft Press
Release Date: July 2011
ISBN: 9780735661639


This is one chapter on SQL Server there are several:- https://learning.oreilly.com/librar...9780735661639/ch12.html#linking_to_sql_server

You can read the book online on a Riley, and I understand you can sign up for free for a limited time which will probably be enough to get what you want from the book. Mind you it's an excellent website, and I highly recommend having a subscription.