bradyboyy88
Well-known Member
- Joined
- Feb 25, 2015
- Messages
- 562
Hi,
I have an application built from an excel userform where users connect to an access database to pull and write data. However, now we have a decent amount of users using this program I want to keep track who is in the program. The best way I could think of was to create a second database which basically the users connect to with a seperate connection string which I can then monitor from using openschema() . What are the issues with this type of approach? Also is there a way to ensure if the connection goes stale for some reason it will reconnect automatically?
Thanks
I have an application built from an excel userform where users connect to an access database to pull and write data. However, now we have a decent amount of users using this program I want to keep track who is in the program. The best way I could think of was to create a second database which basically the users connect to with a seperate connection string which I can then monitor from using openschema() . What are the issues with this type of approach? Also is there a way to ensure if the connection goes stale for some reason it will reconnect automatically?
Thanks
