An alternate Database

[IT_roofer]

I'm working on a project that involves an Excel UserForm that gets it's data
from an Access database. The problem I forsee is on of the sales people being
out in the field with no connection and getting a database connection error
and not be able to fill out the UserForm. I could always plop a copy of the
database on their computer, but that would only serve to lead to other
issues. So... would there be a way to detect connection state and if there
was no connection to my database server then it would ignore trying to
connect to it?

Thanks in advance!

 

[aaron.kempf]

If you had somethnig like Access Data Projects, then it would be easy
and reliable to configure replication for mobile users

 

[Daniel]

simply use the dir() function to check for the db.

Why not use database replication?

 

[IT_roofer]

Well sir, I didn't know about database replication until you mentioned it!
I'm so new to Access the water hasn't dried yet. I'll look into it. Thanks
Daniel.