Results 1 to 6 of 6
  1. #1
    louise is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    112

    Can I have more than one folder for saving databases


    Hello,
    I am working with several different Access databases, and would like to have a different default folder where each of them saves, rather than having the two mixed in the same folder. Is this possible?
    Thanks!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    what do you mean 'saves'? users should not save databases.
    database is already created and put in a folder. (preferably as a network shared folder)
    make as many folders as you like and store the db there, link a shortcut for all users to this db.

  3. #3
    louise is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    112
    Thanks for your quick response (as usual!)

    I don't mean an "extra save", I am asking about where Access puts/stores the dbs.
    I have set the default folder from within one database, but would like a different default folder for the other.

    (This is unrelated to my backup copy on an external harddrive.)

    But, would you tell me what you mean by "link a shortcut."

    thanks

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    The option of where to save is for new db's and it is an application wide setting. Any that exist and are opened do not need 'saving' and whatever you do to/in them becomes current for next time that db is opened (unless maybe there is a crash). So I don't understand what it is you're saying either. If you're creating db's and want them to be in different folders (e.g. for different users) just move them from the default - or as Ranman says, leave them all in the default folder and let users use desktop shortcuts to open them. Of course, that means if I can open mine in that folder, I can open any other.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    louise is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    112
    OK..I think the answer for me lies in Micron's response, that the option of where is to save ..."is an application wide setting."
    I was thinking that a separate folder for each completely separate Access db would be smart (e.g., if you have to hand a whole db over to someone else, have to restore a folder, etc.)
    But, since this doesn't make sense to anyone, I'll drop it and move on.

    Thanks, as always!

  6. #6
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    You can create a db in any folder you wish as below. Also, after a DB is created you can move the .accdb file to any folder you wish. The folder has to be in a Trusted Location.

    Click image for larger version. 

Name:	lou.png 
Views:	12 
Size:	67.6 KB 
ID:	44055

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

Similar Threads

  1. Opening databases and saving object changes
    By Paul G Nottingham in forum Access
    Replies: 6
    Last Post: 04-14-2020, 06:12 AM
  2. Replies: 7
    Last Post: 10-24-2018, 07:29 AM
  3. Replies: 12
    Last Post: 11-14-2016, 07:15 AM
  4. Saving attachment to folder
    By ino_mart in forum Programming
    Replies: 3
    Last Post: 10-29-2015, 07:53 AM
  5. Saving Word in new folder
    By NejcZ in forum Programming
    Replies: 8
    Last Post: 09-10-2014, 11:03 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