Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581

    Using front end / Compact & Repair

    I have a couple questions:



    1. I have a front end that I have on several computers that are linked to the back end on our server. When I update the front end, I need to go to each computer and replace the old front end with the new one. Is there a way to have the old front end look for an update and replace itself?

    2. Is there a way to have a code in a button that will do a compact and repair without having to go to the menu and find that button?

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    1. Yes. Various methods possible. Some people use scripts to check for a newer version and copy it across.
    I run a starter app that looks like a splash screen and does the same thing.
    If the current version is the latest, the starter app opens that and closes itself
    If a newer version exists it copies the newer file(s) then starts the app and closes itself.

    In either case you need a method of checking the version number of the FE e.g. a record in a settings table or a separate text file

    2. MS removed the ability to compact a running database using code with A2010. This was possibly because compacting can cause corruption in certain situations.
    However you can use code to compact the current database when it closes or compact external databases.
    I would always recommend making a backup first
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    That looks like what I'm trying to do. Could you point me in the right direction? Is there a link you could post to site that I can learn about these?

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    You can get both (free) from my site here: http://forestbyte.com/ms-access-utilities/

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  5. #5
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    I'm forced to use 64 bit. Don't suppose you have one 64 bit?

  6. #6
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    I can update them later this week.
    Happy New Year!
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  7. #7
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Both the launcher and the back end compacter should now be both 32 and 64 bit compatible, please let me know if you have any issues with either of them.

    Cheers.
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  8. #8
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    It's still saying that it needs to be opened in 32 bit

  9. #9
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    Click image for larger version. 

Name:	32 Bit.jpg 
Views:	30 
Size:	23.9 KB 
ID:	40605
    It's still giving me this

  10. #10
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    It is compiled on a 32 bit machine; I need to install 64 bit on another and create another accde file for that. Is the launcher or the back-end compacter that you need first?

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  11. #11
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Updated both to include both 32 and 64 bit versions.

    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  12. #12
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    I appreciate the help. However, the link brings me to the 32 bit only. I keep getting the same error.

  13. #13
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Try to download again, the zip file(s) should contain two accde files, one for 32 and one for 64.
    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  14. #14
    UT227 is offline Expert
    Windows 7 32bit Access 2013 32bit
    Join Date
    Feb 2016
    Posts
    581
    I downloaded it again. This is what came through.
    Click image for larger version. 

Name:	Launcher.jpg 
Views:	21 
Size:	76.0 KB 
ID:	40606

  15. #15
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Are there any other FBA_DB_Launcher(...).zip files in your downloads? Try to sort them by the date, this is what you should see (http://forestbyte.com/ms-access-util...a-db-launcher/):
    Click image for larger version. 

Name:	Launcher.png 
Views:	22 
Size:	51.9 KB 
ID:	40607
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Compact & Repair
    By Kundan in forum Programming
    Replies: 2
    Last Post: 01-31-2019, 01:19 AM
  2. Compact & Repair
    By Kundan in forum Programming
    Replies: 2
    Last Post: 01-13-2019, 10:24 PM
  3. Compact and Repair
    By cwitt11 in forum Access
    Replies: 4
    Last Post: 12-08-2015, 11:52 AM
  4. Compact and repair
    By data808 in forum Access
    Replies: 4
    Last Post: 03-30-2014, 03:22 AM
  5. Compact and Repair
    By Cyberice in forum Access
    Replies: 3
    Last Post: 03-18-2014, 03:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums