How can I change the default working folder in Access?
To set the default file location in Access, • Click the File menu and then click Options. • Click Popular. • Under Creating databases, in the Default database folder box, type the path of the folder where you want to store Access database files. This only sets the default for Access. You follow similar steps to set the default location in Excel and the other applications in the Office suite.