Results 1 to 12 of 12
  1. #1
    Join Date
    Oct 2022
    Posts
    24

    Deliver my application

    I made a Access application for my customer. How can I transfer the application to the computer of my customer? He has Access.


    Thnx

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Email a zip file? Download from a file share site?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Join Date
    Oct 2022
    Posts
    24

    Thnx

    Quote Originally Posted by June7 View Post
    Email a zip file? Download from a file share site?
    OK. What has my customer to do with the zip file to get the content of the file in his Access-application?

    Greetings,

    Hans van Heertum
    Amsterdam - NL

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    What exactly are you trying to send customer - an empty db application for them to add data or data they need to import or an application with data? What does your customer have?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Join Date
    Oct 2022
    Posts
    24
    Quote Originally Posted by June7 View Post
    What exactly are you trying to send customer - an empty db application for them to add data or data they need to import or an application with data? What does your customer have?
    It is an invoicing solution with some global tables allready filled with standard information and a number of tables that will be filled by the customer. My customer has Access in use or just bought Access.

    Hans van Heertum
    Amsterdam - NL

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    If you will be providing updates to this application, it should be split design. Frontend is GUI which has queries, forms, reports, code and links to backend tables. Backend has tables for customer data. Opening frontend first time needs to include process for setting table links for user's system. When you provide revised frontend, user data is not impacted, unless there are modifications to table structure and that is another aspect of your service altogether.

    If it is not split and just an all-in-one db, user just needs to extract from Zip folder to working folder of their choice.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    Join Date
    Oct 2022
    Posts
    24
    Quote Originally Posted by June7 View Post
    If you will be providing updates to this application, it should be split design. Frontend is GUI which has queries, forms, reports, code and links to backend tables. Backend has tables for customer data. Opening frontend first time needs to include process for setting table links for user's system. When you provide revised frontend, user data is not impacted, unless there are modifications to table structure and that is another aspect of your service altogether.

    If it is not split and just an all-in-one db, user just needs to extract from Zip folder to working folder of their choice.
    Thnx. What does this mean / what have I to do for "Opening frontend first time needs to include process for setting table links for user's system."? How do I set table links for user's system?

    Hans van Heertum
    Amsterdam - NL

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    That only applies if you provide a split database. You can either instruct client to manually re-set links with Linked Table Manager or you can write VBA procedure to do it. This is a fairly common topic.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    Join Date
    Oct 2022
    Posts
    24
    Quote Originally Posted by June7 View Post
    That only applies if you provide a split database. You can either instruct client to manually re-set links with Linked Table Manager or you can write VBA procedure to do it. This is a fairly common topic.
    Thnx again. I choose for a split database for future updates of the software. My customer has no knowledge of Linked Table Manager so I have to write a VBA procedure. Where can I find an example?

    Hans van Heertum
    Amsterdam - NL

  10. #10
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    It is a common topic. Do a forum or web search.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  11. #11
    Join Date
    Oct 2022
    Posts
    24
    Quote Originally Posted by June7 View Post
    It is a common topic. Do a forum or web search.
    Thank you so much. When you ever might visite Amsterdam let me know so we can meet.

    hansvanheertum@xs4all.nl

  12. #12
    Join Date
    Oct 2022
    Posts
    24

    Exclamation Openi file does not show a choice to open exclusive, open does niet show any dropdown

    How to open an database exclusive without the possibility in the open screen?

    Quote Originally Posted by HansvanhEERTUM View Post
    Thank you so much. When you ever might visite Amsterdam let me know so we can meet.

    hansvanheertum@xs4all.nl

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-27-2016, 10:59 AM
  2. Replies: 1
    Last Post: 08-27-2015, 06:05 AM
  3. Replies: 4
    Last Post: 01-05-2014, 02:09 PM
  4. Replies: 7
    Last Post: 10-15-2013, 08:05 AM
  5. Access application to Web based application
    By admaldo in forum Access
    Replies: 0
    Last Post: 06-12-2008, 06:22 AM

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