By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,282 Members | 1,526 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,282 IT Pros & Developers. It's quick & easy.

Detect adp connection state before opening

P: n/a
Does anyone know if this is possible?

We are running Access XP with Windows XP Prof.. We have an ADP file we are
using to print custom reports for a client. It's opened and conntrolled
through automation, and we've had cases when the file was shut down
unexpectedly and our normal disconnection code doesn't run. The next time
the calling app tries to open the file, the connection dialog pops up. Users
can't even click it away or enter a password for some reason, they have to
end the process. So we'd like to write some code that checks the conenction
state of the file before opening and copies a new one from the server if it
is not disconnected.

We could store a custom property in the calling application that indicates
whether the last call to open the file did manage to close it successfully,
but I wonder if their is a better way that we might be able to extend to a
generic VB utility to launch adps Probably asking the impossible here but
code that could check the connection state without opening the file would be
very helpful.
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.