Very Interesting. Thank you very much for this great tutorial.
@599CD4 жыл бұрын
You are welcome!
@quaggledoo4 жыл бұрын
Finding out about random autonumber blew my mind for a second.
@599CD4 жыл бұрын
Yeah, I've known about them for years, but I really haven't had a need to teach them or show them in a video.
@abdulhamidalhaddadi22553 жыл бұрын
GREAT LESSON 100%
@599CD3 жыл бұрын
Thanks
@notureaveragemiss3 жыл бұрын
you should be able to "push" from the main by appending to the remote table. Maybe because you are using links, try just adding the table from the top ribbon
@599CD3 жыл бұрын
Huh?
@factreact38872 жыл бұрын
Great video as always. I have a database with over 40 tables that need to be updated in the same manner. Is there a way to do all of them at once without making 40 queries?
@599CD2 жыл бұрын
Yeah... you could write it all using VBA, make a function you can send the table name to and it will loop thru the fields in the table. You could manually list the tables or even use a loop to run thru the TableDefs collection. It's advanced stuff, but it could be done, sure.
@yousefalhendi26383 жыл бұрын
Dear Dr ... I am pharmacist, l have used Access since 10 and have debase program .... it is for drug dispensing in my pharmacy..... the program after 10 years used .... it is very very slow... it contains more than one million record... can you help me to solve this problem!
@599CD3 жыл бұрын
You probably don't need all of those older historical records. You can probably archive some of it to another database to speed up your primary tables. I cover that in this Extended Cut video: kzbin.info/www/bejne/eYvRh5aJp8-Zgdk - either that, or you could upgrade your back-end to SQL Server which is much better at handling large volumes of data. A million records is a lot for Access, especially if it's not properly optimized.
@ijofewioiojfew81152 жыл бұрын
I have a question regarding this. Can you link the remote and main databases onto Microsoft Azure? This works perfectly for what I want, however the data must be in the cloud.
@599CD2 жыл бұрын
Sure can: 599cd.com/AccessSQL
@ammumma1appuppa3 жыл бұрын
Hi the sync is adding duplicate values how to stop duplication?
@599CD3 жыл бұрын
It shouldn't be. Did you follow my instructions exactly?
@ammumma1appuppa3 жыл бұрын
@@599CD yes I cross referred and checked.. Its same.. I added database from external data. Then in query I appended from linked to table.. There are 4 records in server copy.. I added new record in remote copy. When I click sync in server.. Its adding 5 records.. 4 already available and 1 new record. So now is server I hav 9 records where 4 of them are duplicate.. I checked in properties.. Don't find to disable duplicate option.
@fernandovilchez7362 жыл бұрын
That's it's nice but if you delete some record?
@599CD2 жыл бұрын
Yep. You'd need a solution for that.
@joelgarcia62873 жыл бұрын
What if you want to use Access on a tablet in an area without internet connection? Would this still work?
@599CD3 жыл бұрын
Nope. Only way you can use Access on a tablet is via a remote PC connection. There is no tablet-based version of Access.
@melalama86933 жыл бұрын
can I do the same with the split database (with the front end)? I have distributed front end to my users and if they want to update the database from remote location, can they do the same with their front end.
@599CD3 жыл бұрын
Sure
@knr18333 жыл бұрын
Is this synchronize method will work in access 2016, actually remote access database saved in E drive this consider as a Lan path, Local access database in c drive, i have linked the E drive path tables into local access database, after that i have created one button synchronize, while click on synchronize button it must be updated in local to remote and remote to Local. please can you provide the VBA code
@599CD3 жыл бұрын
All the code is provided in the Extended Cut for Members
@knr18333 жыл бұрын
@@599CD I am member of this group
@nadspombo71604 жыл бұрын
Good day to you Sir Richard. I just want to ask something... how can I customize the Custumers number (Autonumber) when I want to include like first three letters of his Firstname, Lastname and the first letter of his Middlename? Thank you in advance Sir!
@599CD4 жыл бұрын
You're not going to change the AutoNumber. You can create your own custom Customer Code though: kzbin.info/www/bejne/gJSWeWOdpMikp6s
@599CD4 жыл бұрын
You can use basic string functions and concatenation to create your own Custom Codes: kzbin.info/www/bejne/iKWykmaie7CDd6s
@DaviGouveadosSantos3 жыл бұрын
In case I had changed by editing a register, Can I use such a sync?