Hi all,
I am currently creating a database and have 2 folders. A production folder and real data storage folder and would like to switch between these folders to access tables to test my project and also store real data. I have created a file called config.cfg in notepad and stored that in the production folder and would like to edit the path of either of the folders in this config file when switching between them so that when I open a data entry form, the application should access tables from the path specified in the config.cfg file and store data in the specified path.
What I have done so far, I have only copy of the database in the "real data storage folder" which I named as malcon_slidedatabase in the path "C:\malcon_slidedatabase". And all the forms,codes,reports,etc..and also the copy of the database tables in the folder which I named malcon_microscopy_db in the path "C:\Users\Administrator.Malconpc-PC\Documents\Malcon_microscopy_db".
I know there is a way out but really stuck here.Any start of would greatly be appreciated.
regards,
I am currently creating a database and have 2 folders. A production folder and real data storage folder and would like to switch between these folders to access tables to test my project and also store real data. I have created a file called config.cfg in notepad and stored that in the production folder and would like to edit the path of either of the folders in this config file when switching between them so that when I open a data entry form, the application should access tables from the path specified in the config.cfg file and store data in the specified path.
What I have done so far, I have only copy of the database in the "real data storage folder" which I named as malcon_slidedatabase in the path "C:\malcon_slidedatabase". And all the forms,codes,reports,etc..and also the copy of the database tables in the folder which I named malcon_microscopy_db in the path "C:\Users\Administrator.Malconpc-PC\Documents\Malcon_microscopy_db".
I know there is a way out but really stuck here.Any start of would greatly be appreciated.
regards,