2. (Advanced Programming In Access 2013) An Overview of Moving To Microsoft SQL Server

An Overview of Moving To Microsoft SQL Server in "Advanced Programming in Microsoft Access 2013". Hosted by Steve Bishop. In this free advanced video tutorial series Steve will be going over Database Migration, creating a better User Interface, using external data sources, complex Visual Basic For Applications (VBA) concepts and distributing your application.

Click here for the full playlist of "Advanced Programming in Access 2013":

Click here for the Work Files of this series:

[johnclark]

Steve, my organization just “upgraded” from Win7/Office 2010 to Win 10/Office 2013. All of my Access application no longer would hold a connection to Sharepoint which made life very hard for our remote locations in Spain and Bahrain. As a fix, I was offered an instance on our SQL Server, which intimidated me to no end. We have no DBA and the skill set of our IT department in regards to Access and SQL Server were severely lacking.

This series were a life saver and I cannot thank you enough!

[sebastiaooliveira]

In my notes I just wrote: "THE BEST and elegant too", Thanks Sir

[HarveyFrench]

That was very useful and I also found the comments and replies below useful.  Thanks.

[martinniewiall]

Muchas gracias Steve!! Excelente curso, es justo lo que estaba buscando.
Saludos desde Argentina.

[haydarm.al-samawe]

i really get real good information can help me in my work, thank you for that

[maibamikheilen]

Very interesting and benefited to my project. But I want to know more about the display OLE object in the report.

[mertexdrive]

Hello Mr Stive have agood day i want to ask you if you can tell me how i can control and select a specific TextBox in a continue form by using vba loop coding because as you know you will have a textbox data source like a meter or product name and i want to give a color to the line that i move to or sum a field or count it using vba .

[completelystupid]

Cannot thank you enough, this is exactly what I'm looking for, keep up with the good work. Please help me with a small question below. .

My boss is complaining that the split database is too slow for users to use. My company is a manufacturing company, so the IT brain power is not so great. Also, the cost of the project is a big thing. So, What do we need to invest to upgrade our access database to a SQL server? Is it a one time buy (soft and hardware) or monthly, or what? Does all of my data locate on the internet after the upgrade? Again, we just want to speed up our database, what is the best move?

Have a great Thanksgiving with family

[סםבדיחי]

I am writing an Access program for myself - i.e. it will run on a single PC. It is about to hold a lot of data though I am not sure it will ever be more than 2G. Nevertheless, as it involves a lot of calculations of aggregate data, it is already taking some time to run (with only half year worth of data).
My question is: Is there any benefit in installing a Microsoft SQL Express Server on my own PC? Will it make processing the data more deficient in a way that my program will run faster?

[amirhosseinrezaei]

hi
my English is not good & subtitle can help me please if you can put it

[davsAlmanac]

You could not come up with a advanced enough coarse I only have 3 types of fields time date degrees numeric expressiing of altitude direction azimuth i don't know how I am supposed to build forms I never use a wizard I stuff so many fields in a form in Access break every rule I am the village idiot