Archive Records: Archiving Old Data in your Microsoft Access Database

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

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

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

    Thanks for the clear, step by step video !

    • @599CD
      @599CD  2 ปีที่แล้ว

      You are welcome!

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

    Hi Richard this video is excellent. I was wondering can you archive a full database to remove several years of orders customer etc is this possible. I am back home from hospital all your videos kept me said stopped me being very board Steve b

    • @599CD
      @599CD  ปีที่แล้ว

      Glad you're home. You can remove as much or as little data as you want.

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

    Would you archive old customers? Of course I would not delete them but are these steps the same with customers?

    • @599CD
      @599CD  ปีที่แล้ว

      Sure... the type of record doesn't matter.

  • @theamazingreviews5830
    @theamazingreviews5830 7 หลายเดือนก่อน

    Hi, thanks so much for the video. I am creating an archive for my company's personnel files (about 6000 employees), and each file has various documents scanned and added. I would then like to share this database with colleagues. My problem is pdf files. If I link the pdf file from a shared folder on the server, all colleagues will be able to see everything, not just the record they need (there will be user levels etc.), so I thought about attaching all the files to each record so as to have more control over every single record, except that this way I will soon reach the 2GB limit. I'll try to follow your tutorial and do the split, see if I can do it.

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

    Need a little help. Followed your tutorial to the letter and it worked. Office manager wanted the achieve to be in a different location on the computer. In doing so it messed it up. I've since started over using the same database with the append and delete Q's. Copied main, renamed, deleted and linked as you showed and I accomplised before but now it gives and error that it can't output to my table. Any ideas?

    • @599CD
      @599CD  ปีที่แล้ว

      599cd.com/trouble

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

    Oh appreciate, but many videos are special so that can't get any idea from it.
    So how i can become a member, and how much is it for permanently...
    Regards

    • @599CD
      @599CD  ปีที่แล้ว

      599cd.com/THM

  • @ballaomer6738
    @ballaomer6738 10 หลายเดือนก่อน

    hi , Im gold member but i cant see the switch button on the downloaded file?

    • @599CD
      @599CD  10 หลายเดือนก่อน

      I'm not exactly sure what you mean but post this in the Forum on the website and I'm sure the guys will help you out 599cd.com/AF

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

    Large db can occur from not compact and repair.

    • @599CD
      @599CD  ปีที่แล้ว

      Yep

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

    I noticed you're not a user of RubberDuck a very useful free VBA developer tool.

    • @599CD
      @599CD  ปีที่แล้ว

      Nope. Never needed it.

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

    thanks

    • @599CD
      @599CD  2 ปีที่แล้ว

      Welcome

  • @revision_classesTM
    @revision_classesTM 11 หลายเดือนก่อน

    👌👌👌👌

    • @599CD
      @599CD  11 หลายเดือนก่อน

      :)