Way to interact with database from multiple locations

[erick-flores]

Hello all

I have multiple forms that are attached to a MS Access db. I want to
send the form with the database to my customers, so they can have their
own records of what they have sent so far. The problem is that the
database will lost the connection source, because obviously the
database connection is pointing to a source in my computer. So my
question is, is there a way to setup the database to its own source or
soemthing like that, so when I send the forms with the database this
kind of problem will not happend. Maybe put everything together and
compile it as one file...I really do not know how this can be done, is
it even possible?

PLeaseeeee helppp, thank you

 

[Kalyan Reddy]

Hello,

You send the Database and also the form to the customers. Now Open the Form
in the design mode and go to Tools|Dataconnections and select the
dataconnection and click on modify and then follow the instructions there of.
In this way you can set the location of the database to its new location.

I hope this will help you.

 

[erick-flores]

Thank for your reply Kalyan

I know this is the way to do it, but I was just wondering if there is
another way so set that up front somehow, because there are like 20
forms and I do not want to take the customer through that process, you
know some people just do not know how to work with computer very well.
Also if i want my forms to be secure the customers will not be even
allow to switch to design view. But anyways thank you and if somebody
have a suggestion or comment please let me know

 

[Esther]

It sounds like you might do better exporting these from a Crystal report -
you can send the data with the forms themselves, or even push them out to a
website to view. Have you used this program before? It does an excellent job
with things like this. It's not a microsoft product, but if you have this as
an option it is well worth it.
-Esther

 

[Kalyan Reddy]

Hello,
Also please take a look at the link below.
http://www.qdabra.com/proddetail.asp?prod=QDeployment