38. (Advanced Programming In Access 2013) Using The Run Time Edition

[@omg2mad4u]

Thanks Steve you are a legend in the past 4 months using your videos I've been able to go from zero knowledge in Visual Basic to having designed a database app in access for my office that is very useful for my clients and colleagues. Thanks for being so generous with your knowledge and time.

[@ProgrammingMadeEZ]

+omg2mad4 I am happy to hear the series has been so helpful.

[@ramzikhouri]

Yet another explanation that saves me hours and hours of running around. After saving my file as accde file i got an error. You're video helped me fix it by showing me how to do the if statement and bypassing the "Nav Hide" cmd when i am in RunToime or ACCDE file . (till the next error...:). THANKS.

[@swapnilwankhede3440]

Hi Steve Excellent Tutorials, Thanks a lot Steve for uploading this videos, it’s really helpful, never found such good videos.

[@flrazvan]

Great video !!! Thanks. Best videos to learn some deep VBA tricks.

[@Rusty6450]

I really enjoyed your video and NEVER included Macros (nasty shortcuts). I have used MS Access since v2.0 (still have the disks) and did develop several user apps through out the years connecting with Oracle and SQL Server databases. Appreciate how the 'references' error gets thrown, I've had many. I am now retired and would like to develop something for senior citizens, like me that do not have MS Access and can run on their computers.

[@Georgios_A_Kounis]

Hello Steve. I wish to thank you very much indeed for the courses that you have upload . I remembered my coding expertise and refreshed my memory in order to create a database for a client of mine since my last action with VBA was since 2005. I am using 2013 access and on the runtime it seems that this last error of runtime error keep coming up all the time. Is there something that has to do with the windows 7 64 bit maybe? I will appreciate your opinion. Thanks again

[@mahmoodsheikh4046]

I"ve created a programme by using access 2010 and now I've installed access 2013 and my programme is not running so do I have to install 2010 run time or 2013? thanks in advance

[@yvettethompson]

Hi Steve. Thank you for everything you do! I have been struggling with this lesson. When I run my "READJSON" I get a "Type Mismatch " error and I am wondering if it has something to do with the extra nest I am delivered with my API request. My Reader.responseText starts out with : {"data":[{"ID": BlahBlahBlah","name":"BlahBlahBlah", Do you think the extra "data" loop is making me error out? I am getting the data correctly in the reader.responseText I have a screen shot - can I submit that somewhere? Can I pay you to help me? So close but yet so far....

[@ProgrammingMadeEZ]

+Yvette Thompson Yes, the extra layer is throwing off the levels for your JSON reader. I'm afraid I am booked up with work and don't have spare time right now to take on any new jobs.

[@brendagutierrez2838]

You forgot to mention that .mde and .accde databases will only run on the architecture that they were compiled.

[@michaeldingee743]

Steve Can you install runtime on a Terminal server ?

[@mannysilva1194]

Hi Steve,Great Video!!!How would you set MS Access 2013 to runtime on 3 Windows/7 PC's and have MsAcces runtime share the same Database. Each PC needs to "TRANSACT" same Database. The 3 PC's will be updating and printing "Reports" on Same Database.Also I need to install a Add-in for UPC-A Barcode do you have any "IDEAS" on barcode Add-in?Thank you again for your Great Videos

[@ProgrammingMadeEZ]

+Manny Silva Well, let me first address your distribution process. The actual database front end file needs to be passed around to those who need to run the reports, enter data, etc. I highly recommend you split your database so that the actual data is either in a separate file on the network, or in a SQL Server. Then the Run-Time version of Access is simply the environment they run the database within. Just like how in order for a .NET application to run on a PC, the person must have .NET installed on their system. Now as for your second issue with barcodes. Barcodes are a font which are readily available for download online. A barcode scanner will read the font and print out the barcode value as text.

[@mannysilva1194]

Thank you Steve, for your help. I had no clue on how this would all come together. And thank you for making great videos!!!

[@rushikantasingh3205]

Sir, How to open password protected database from another database in access runtime environment.

[@Rusty6450]

it is password protected for a reason. Purchase the source code.

[@biro753100]

Hi Steve, how does the Access Runtime connect to the SQL Server? As I understand, the Access Design communicates to the SQL server through ODBC connections. Wouldn't the Access Runtime need to do the same if on a different client computer than the Access Design?

[@ProgrammingMadeEZ]

Yes, you still need the ODBC drivers installed if you're going to connect to a SQL Server.

[@dominicdominic8553]

Hey Steve, I'm wondering. Is there a list of commands in VBA where MS Access Runtime cannot complete? I am experiencing the same run-time error as the one shown in this video. I am try to push my front-end to many different workstations in my firm. I am thinking of using Runtime to serve as my front-end to save cost. Mass-purchase of MS Access license would result in high costs, something I am trying to avoid.

[@ProgrammingMadeEZ]

I have not found a complete list, but you can make sure your version runs under the runtime edition by simply using /runtime in the command line to open your database.

[@dominicdominic8553]

+Programming thanks steve

[@kamleshjain6872]

Sir, thanks for the video. Pl guide me : What if i have to use AutoExec macro ? According to this video, auto exec macro to be deleted. So i cant use run time version with AutoExec macro ? Pl help sir.

[@SAMYTAHER]

√