I am upgrading a database from Access 2010 to Office 365. The issue is the code from Access 97 Developer’s Handbook by Litwin, Getz, and Gilbert (Sybex) Copyright 1997 which has been used since the database was first developed in Access 97 to obtain file and folder information no longer works.
A little additional context. I retired from coding at least 6 years ago so am somewhat rusty and not upto date, however I have been asked to upgrade the database as I am the only one who knows anything about how it operates from the code side.
My problem is that I need to recode so that a user can either select an existing database file or name a new one with one dialog box as it used to work in Access 2010 and prior versions. IF the file was previously created by the database this name should appear in the dialog box but the user should be able to overwrite it and with a new name, ie the decision is the user’s not the coder’s.