Microsoft Access Split Databases: Automatically Re-Link

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 ธ.ค. 2024

ความคิดเห็น • 40

  • @Bernard-lu6we
    @Bernard-lu6we ปีที่แล้ว +1

    Thanks so much for this clear and thought through approach! Just to add my voice to the plea to make (again?) the code available on the indicated (broken?) link. Many thanks for the effort of producing this video!

  • @JonCompass
    @JonCompass 4 ปีที่แล้ว +1

    I was about to write a similar code, having not found any a while back, so thanks very for this. One question, if the FE links to two BE databases, have you looked at modifying the code to get around that?

  • @jaironaranjo3654
    @jaironaranjo3654 2 ปีที่แล้ว

    Sir what an amazing videos you are definitely the best!

  • @JWinAus
    @JWinAus 2 ปีที่แล้ว

    This is awesome, thank you for this video. May I ask, in a split DB scenario, is there an automated way to make changes to the back-end database? it does not happen often, but sometimes it is necessary to eg. add a column to an existing table, or even add a table to the backend DB. Is there a way to code this and roll out during an upgrade distribution?

  • @RossAWaddell
    @RossAWaddell 8 ปีที่แล้ว +1

    I'm using Access 2016 and after I link a table (whether creating a new link or refreshing the connection info on an existing linked table) it shows up as read-only when I open up the table. Programmatically, I appear to be able to update/insert but not through the standard table view. Intermittently, a linked table will open normally and show the (new) record at the bottom of the table, but not frequently. Any ideas?

    • @Accessjitsu
      @Accessjitsu  8 ปีที่แล้ว +1

      I've never had this happen to me. It's the intermittent that gets me. If it were all the time, I'd suggest checking folder permissions. Any chance somebody else, or another instance of Access has the backend opened exclusively when this happens? Check the default record locking in the Access Options - maybe "All Records" is checked and somebody else is editing the table at the time?

    • @RossAWaddell
      @RossAWaddell 8 ปีที่แล้ว

      Thank you for replying so quickly. I did some more tests last night and I think it boils down to using Dropbox for my development environment. After installing my app to a local C: drive, all links behave as normal. The intermittent problem with the read-only linked tables when saved on Dropbox might also tie in to the other issue I had when Repairing and Compacting the db; occasionally, it can't rename the newly compacted db ("database.mdb") back to the original file name, so it might be due to the syncing mechanism back to the cloud.

    • @thanetenjoy
      @thanetenjoy 4 ปีที่แล้ว +1

      I have the same with OneDrive folders. Any solution?

    • @RossAWaddell
      @RossAWaddell 4 ปีที่แล้ว +1

      @@thanetenjoy When I need to relink tables or do repair/compact, I copy the client file to a non-cloud drive folder (i.e. c:\temp) and do it there, then copy it back. I think this is just the nature of cloud drives and their syncing.

    • @thanetenjoy
      @thanetenjoy 4 ปีที่แล้ว

      @@RossAWaddell ok let me try it today and I will update the results soon. Thank for your support

  • @vicsplace
    @vicsplace 8 ปีที่แล้ว +1

    Great job, Thank you for your clear descriptions of the process of the code. There are many great sources out there but none that i have found explain and teach me the way your videos do. again great job and keep it up. one question though, can this code pull the text file information from within the front end say from a table so that i don't have a text file that end user could possible see and alter?

    • @Accessjitsu
      @Accessjitsu  8 ปีที่แล้ว +1

      +vic k Yes, you can store a path in a front-end table. You just have to remember to change the file name there when you deploy. When the front-end is on your development machine, I assume you would have the file name of your back-end. When you copy that front-end to your customer's machine, you'll need to change the file name and path to theirs.

  • @wadestarks610
    @wadestarks610 4 ปีที่แล้ว

    How long does this auto-relink process take to complete?

  • @lizimorley7703
    @lizimorley7703 3 ปีที่แล้ว

    Thanks for this helpful video! One question: Is it a problem that my backend doesn't have a password? I have been debugging and am getting errors in the "RefreshLinks" function. Furthermore, the file dialog box doesn't automatically pop up when the path is not found, it only pops up when I step into that line of code in the debugger. Thanks!

  • @waqarshah9651
    @waqarshah9651 6 ปีที่แล้ว

    If I have two separate split databases with different tables however now I need to link to one table on the second database as it is a large table and needs to be up to date all the time is this possible?

  • @lozzamoore
    @lozzamoore 3 ปีที่แล้ว

    The web link above to accessjitsu to get the code here is not found. That's a shame as the video is very good, and I am trying to achieve exactly this. Has the code been deliberately removed or is this a bug please?

  • @wsitech
    @wsitech 3 ปีที่แล้ว

    Very very interesting video. I have this problem with clients ALL THE TIME when we do repairs or maintenance on the front end, and it goes back and we have to manually reconnect. We do have a procedure that goes through in AutoExec and automatically relink the tables, but this looks like it can be more generic in nature, less hard-coding needed, i.e. the way I have it now hardcodes one of several strings, commenting out the ones we aren't using. This looks more flexible, albeit far more complex I'll probably have to watch it 2-3 times and step through the code.

  • @akokohjoel9854
    @akokohjoel9854 2 ปีที่แล้ว

    Pls can you show us Link to the VB code to relink backend

  • @LuisCruz-os2dy
    @LuisCruz-os2dy 8 ปีที่แล้ว

    question away from the topic
    how can i reset the autonumber from my tables.
    i know there is a a vba code or any other way
    please help

    • @Accessjitsu
      @Accessjitsu  8 ปีที่แล้ว

      The only way I know to reset an autonumber is to empty the table and compact and repair. If you renumber while there are already records in the table, you risk creating a collision later, so I don't think Access will let you do it with data in the table.

    • @LuisCruz-os2dy
      @LuisCruz-os2dy 8 ปีที่แล้ว

      thank you

  • @janezklun
    @janezklun 9 ปีที่แล้ว

    Just great approach, excelent, thank you

  • @anupamdebnath6821
    @anupamdebnath6821 ปีที่แล้ว

    GetFileFolder("file", "Choose the Access database holding your tables (the backend)")
    not work.

  • @annarocha6161
    @annarocha6161 7 ปีที่แล้ว

    Hello,Thank you for this very useful video. I need to open a login form after the splash screen runs but can't seem to make that happen. Would you mind pointing me in the right direction?

    • @Accessjitsu
      @Accessjitsu  7 ปีที่แล้ว +1

      right before closing your splash screen use the docmd.OpenForm method.

  • @HatemEsmat
    @HatemEsmat 3 ปีที่แล้ว

    Great video, thanks 👍
    Can you please send me the code
    The link is broken, have nothing in the Page
    Thank you

  • @azashukri5322
    @azashukri5322 7 ปีที่แล้ว

    What a fantastic video.

  • @annarocha6161
    @annarocha6161 7 ปีที่แล้ว

    Thank you so much, I figured that out. I added it to my login form. I can't seem to make this work for any other machine. I've tried on different computers and it will only work on mine. Is there away we can talk. I'd be more than happy to compensate you for your time.

    • @Accessjitsu
      @Accessjitsu  7 ปีที่แล้ว +1

      Are you clicking the "enable" button when it asks you if you want to run
      macros, and are you trusting the database on the other machines?

  • @sappraku
    @sappraku 8 ปีที่แล้ว

    Thanks very much for this tutorial.
    Sad news for me, after i tried i get the message "Relink successful "when both front and back-ends are in the same folder
    But I get the error "modRefreshlinks/Checkbackend error : o ="
    Please what could be the problem ?

    • @Accessjitsu
      @Accessjitsu  8 ปีที่แล้ว +1

      That error code of zero isn't telling us much, or rather anything. Are you able to step through the code in the debugger to determine which statement it is failing on?

    • @sappraku
      @sappraku 8 ปีที่แล้ว

      Thanks a million for your response. Sorry but the pop-up box appears with the error modRefreshlinks/Checkbackend error :
      o =
      the only option i get is ok, then after clicking ok nothing happens.
      I think the dialog box is failing to open for me to search or locate the backend.
      I copied everything from accessjitsu.com/2016/01/10/microsoft-access-split-databases-automatically-re-link-broken-table-links/
      Is it also possible to replace the startup form with my login form since i want the login form to open first.
      Thank very much

    • @Accessjitsu
      @Accessjitsu  8 ปีที่แล้ว

      You can make your login form open first, you can put my startup code in your login form or have the login form open the startup form. Whichever you like. You need to know which line of code is failing. you need to set a breakpoint at the top of the code and then run the code. Step through the code one line at a time using F8, until you find the error. When you are debugging like this, when you hover your mouse over a variable, it will tell you the value, so you can get a better idea of what is happening.

  • @hassankadhum4127
    @hassankadhum4127 7 ปีที่แล้ว

    Thank u sir for nice video i will test this thanks

  • @johnwatkins39
    @johnwatkins39 8 ปีที่แล้ว

    im kinda a noob to access databases, i have built a couple previously, but now i wanna split the databases. i understand some vba code but would like it broke down a little further pls thx for the great video

    • @Accessjitsu
      @Accessjitsu  8 ปีที่แล้ว

      Here's a video on how to split: th-cam.com/video/_kMcaAEDu4o/w-d-xo.html

  • @vfxmastersthailand9330
    @vfxmastersthailand9330 7 ปีที่แล้ว

    great video but could i ask for a txt of the codes please

    • @vfxmastersthailand9330
      @vfxmastersthailand9330 7 ปีที่แล้ว

      thank you so much, but now i have another problem I've made a appointment form that automatically update the outlook calendar everything work but now for some reason it stopped working its saying it has done it but when you open outlook there noting there, i really want it to go on my SharePoint calendar so all my phones get updated

    • @vfxmastersthailand9330
      @vfxmastersthailand9330 7 ปีที่แล้ว

      i got it to work oooooohhhhhhh lol

  • @sharathAlive
    @sharathAlive 7 ปีที่แล้ว

    Sir, i honestly am very happy to see this code. i have got it to work i guess upto 50% i have a error kindly guide me.
    i have a "modrefreshlinks/checkbackend error:0 = " Dont know were its going wrong :( im a newbie so please help?