4. (Advanced Programming In Access 2013) Migrating Access Data To SQL Server

[@ethelyulianatejadarojas363]

Great videos. Thanks

[@MaherTalip]

Am really appreciate and respect that your efforts in bringing the idea to us and help us thank u.

[@swapnilwankhede3440]

Thanks a lot for uploading these videos.

[@TheToeFungi]

Thank you so much man. Annoyingly thorough video :P But you got my program working and I am incredibly grateful!

[@ProgrammingMadeEZ]

+TheToeFungi I'm trying to make my C# course much less annoyingly thorough. :D

[@thewilliam2594]

Thank you for this series. These videos are very helpful to me :)

[@MGernot1]

This was very helpful! Thanks a lot!

[@serkancolak872]

Thank you so much, everyting works well as you explained. Very good video.

[@kawtarmar4147]

Thank you so much is very useful

[@joeit]

Does Steve still do Videos?

[@yulic97]

Hi! Thank you for making this series of video. It really helps for my thesis. I have a question, btw. I have Office 2010 (32 bit) in my Windows 2007 (64 bit) -- well some technician reinstalled my Windows and upgraded it to 64 without my permission -- which makes me have to download Ms. Access 2010 Runtime instead of the 2013 version (32 bit). But after I finished installing, there is no "Microsoft Access (Microsoft Access Database Engine" or something like that in my data source. Would you tell me if there is something I miss? Thank you!

[@ragubirsingh2854]

HI...Steve...thanks for the wonderful video....i have question when i will give my data source file name i received error message that "The operation could not be completed. Additional information: Unrecognized database format 'C:\address of the database (Microsoft JET Database Engine) please guide me...thanks...

[@parthdattani31]

i want import access data to sql server or sqlite database table please share code?

[@dipakpokhrel4585]

I do not have server PC .How can i migrate access data to microsoft sql server ?

[@uniQue_XL]

Thank you so much for the video. very halpful! I have one issue that does not work.... on SQL Server Import and Export Wizert part, I do not have the so called: Access database Engine , on dropdwon list, as you show on your video. as far as I found, this works in 64-bit only. could not figure out how to do this process with 32-bitI have WIN 8 with Office 2013 - 32-bit Any idea how to solve this ?

[@ProgrammingMadeEZ]

TheExcelStudio Take a look at my how to video on using SSMA.

[@marounsader318]

hi steve im wondering after migrating the access data, if the user used the forms to add data, will it be migrated directly to SQL database?

[@richardlbutler4287]

You probably are aware that Access applications that ran previously without issue started crashing when being run on Windows 10 build 1803 machines (see DevHut blog) around June of this year. MS has issued a workaround which suggests disabling LeasingLock on the server housing the back-end. Clients are reluctant to do this apparently because it degrades network performance. Another suggestion is that the back-end should be ported to SQL Server. Pleas from developers to Microsoft asking for some action on this issue have fallen on deaf ears. Can you share your perspective and suggest what is the best way to deal with this?

[@phoneyjoe]

I'm limited to Access 2010 at work. Can I apply these techniques to that version? I downloaded the Access Runtime 2010 version and will give it a go, but if I'd be wasting my time, i.e. the procedures are different than with 2013 discussed here, I won't pursue it.

[@ProgrammingMadeEZ]

Yes they work in 2010 as well.

[@coaching_engineer]

Hey Steve. I did not get a warning on my validating in the import/export wizard. Any idea why that could be?

[@ProgrammingMadeEZ]

Jaz Isom Not really sure.

[@vinceperlas563]

Hi Steve, I want to thank you for all your great video tutorials and can help me a lot. I have questions for you, how can i change the datatype date permanently because its showing in my forms like this(2017-05-31) change already into date datatype) and connected into sql server, same as i select the data and also when i generate all the reports. I want to change permanently and become like this (31-May-17). Any possible command or process i go through to make this happen? Thank you in advance.

[@ProgrammingMadeEZ]

You should change it in the format of the form, not the format of the data.

[@vinceperlas563]

Thank you very much and appreciated.

[@mohammedalsarraj9963]

Hi, how we can convert SQL Server DB to Access DB. Thanks for your supporting

[@ProgrammingMadeEZ]

Heh.. why would you want to? You can use the SQL Server Import-Export utility to connect to an Access database and do basically the same process I show here, just with the sources swapped.

[@marcelagarcia3779]

Hello, I do not have the option to export ODBC what I do?

[@ProgrammingMadeEZ]

I don't understand.

[@marcelagarcia3779]

Look, I do not see the option to make the ODBC connection enabled

[@martinniewiall]

Hi Steve, first of all i want to thank you for these videos, and i want to excuse for my english (im from argentina). I wanna ask you if there is a way to make this process but in a database that has been separated in back-end and front-end. I tried to do it from the front end, and the import was succesful but it only recognize the queries, not the tables (beacuse there were only the links to the back-end).. And if i do it with de back end, it wouldn't import the queries... So, do you know if there is a solution for this case? Or do i have to put the parts of the database together? (I don't remember how to put them together)

[@ProgrammingMadeEZ]

+Martin Niewial You shouldn't be importing queries to your SQL Server. The queries should stay on your front end file and only your tables should be on the back end.

[@martinniewiall]

+Programming thank you for answear! Ok, so i keep the database separate and do this process just for the back end? Because i thought that in the nor thwind database example you use it the database together without separate it and when you selected "tables and queries to export" you selected all. That's my doubt

[@ProgrammingMadeEZ]

The Northwind example doesn't come out of the box split. Since your database is already split, then yes you will need to migrate your access tables from the back end file to SQL Server.

[@martinniewiall]

+Programming Perfect! i would do that way. Thank you very much Steve for your answear

[@ruisantiago2476]

Thank you so fucking much!! :D

[@SAMYTAHER]

√

[@squanderer-pm7bu]

lol bro said BING search