I have created a program that uses an Access database located in a shared folder. I want to:
1) Make the program check if the Access database exists.
2) If it does, then the program loads. If not, then the user can change the current connection string to reflect where it is. If it exists, the program loads.
I have seen countless forums and guides that show how checking the connection state is done with SQL, but not with Access. The PROVIDER is Microsoft.ACE.OLEDB.12.0.
How can I accomplish all of this?