Update Existing Data in Access Database. Excel to Access Automation using VBA - 4

[@GaganDeep-mj5hi]

Very informative and helpful keep up the good work

[@VBAA2Z]

Glad it was helpful!

[@nayankumarsurepalli3692]

Hello, I am in need of some help, I have an Excel user form, I wrote a code to update a specific information in access database table. it is working good when a single user uses it.However the Excel user form is used my multiple users at the same time almost around 150 users. How do i tackle this situation, if i had got some error i could have added some error handling code, but the thing is it does not give an error, it just skips and does not update is the when two or more user form try. Please help

[@harinatrajan3237]

Hi Sir, when multiple people access the database on same time like this video, it will work ?

[@VBAA2Z]

Yes it will be ok. Place some handlers if user write / uploads to same record.

[@harinatrajan3237]

@@VBAA2Z Thank you so much sir

[@kylem2779]

nice work buddy. Looking forward to for new videos

[@onoonowee]

Hi, your blog spot is unavailable currently. same as Supareli question I ha to make many user to access database.

[@kinwiliu999]

Great tutorial. Thanks for sharing

[@axelamoe]

Can I use this with access 97? I have a .dat file being generated by a program and I am trying to update that file but it only opens with the the old access

[@VBAA2Z]

Do try it out and let me know how it goes. The connection string might need to be updated accordingly.

[@levelupexcelskill]

Thank you so much. I have query can we update RS![Column Name] dynamically like refer some other range instead of hard code RS![Employee Name] instead of RS!range how can we do this, please suggest.

[@VBAA2Z]

if you have a field name in excel range try below. rs.fields(range("A1").text) = "Hello world"

[@levelupexcelskill]

@@VBAA2Z Thank you, it is not working showing error , I want to update existing data in Access but I want to make dynamic name as per your video you have written rs!EmpName = cells(i,2) rs!DOB= cells(i,3) rs!EmpNumber = cells(i,4) rs!Designation= cells(i,5) instead of hard code I want to do this via loop. I having problem while writing a code - rs.fields(range("A1").text)

[@levelupexcelskill]

rs.fields(range("A" &i).text)=sheet("Data").range("B" & i) is not working ,

[@VBAA2Z]

@@levelupexcelskill you'll have to update field name reference. does range("A" &i).text holder field name?

[@levelupexcelskill]

@@VBAA2Z yes

[@justynastoparczyk9059]

thank you for you work, it helped me a lot :)

[@VBAA2Z]

Glad to hear that!

[@qwertyuiop102345]

That is really helpful. Please keep making more videos.

[@VBAA2Z]

Thanks for your appreciation Maxim, please subscribe and support! KZbin.com/VbaA2z Facebook.com/VbaA2z

[@saqlainshaikh9936]

Dear sir please help how to update bulk records from worksheets to access

[@VBAA2Z]

Hi Saqlain, please follow this tutorial and let me know if you face any issue. kzbin.info/www/bejne/mWrNnH5slreKpLM

[@VBAA2Z]

@Mielkew Hi, thanks for the suggestion. I can certainly add more videos to the VBA Access Automation Series.

[@JuribSunn]

keep making more video Sir.

[@VBAA2Z]

Keep watching

[@Rahul-sn1wn]

Yeh awesome. thanks buddy

[@riteshtandon8056]

How to update multiple records in one go? Using loop

[@VBAA2Z]

please check kzbin.info/www/bejne/bmOskpWNasSgl9E

[@swapnilpawar13]

can you share the code file?

[@nancymui745]

Worked perfectly!

[@sharon4578]

Many thanks dear GURU can you please add some video about import DATA from Access

[@VBAA2Z]

Hi, thanks for your comments. please refer to this video and let me know if you need any help. cheers! kzbin.info/www/bejne/iKm7lJV_h62mgK8

[@nani3775]

Nice information.... Could you please help me to open pw protected access file using excel vba. I tried multiple ways Eventhough am getting.. Can you please

[@VBAA2Z]

Share your code and error message.

[@susilsxzen-ff1zn]

Thank you so much

[@VBAA2Z]

You're most welcome!

[@akhapamai8135]

Great thanks

[@VBAA2Z]

welcome