An alternate Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
If you had somethnig like Access Data Projects, then it would be easy
and reliable to configure replication for mobile users
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I invoice a cost to a custom built MS Access Accounting Database? 0
Insert data into access database from excel userform 1
Connecting from asp to a microsoft access database. 15
Does Microsoft recommend databases or projects to connect to SQL s 1
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
ODBC Connection with Windows 7 2
Remote Database and Office Database 15
File in Use Error 2

Back
Top