Updating database from remote location

[Guest]

I have built a database for local squadrons so they can create their status
reports for their boss at the Wing (Navy squadron chain of command). The
program is on the local network for the base and those who need access have
it.

The problem I am running into is that when a squadron deploys overseas they
do not have access to the same network in order to complete their report. I
have tried to replicate my database but the copy is too large to send via
email back to home base so that the Wing can sync it and do their report. I
have also played around with just emailing a certain table in excel format
but when I try to import that data I receive an error.

So, my question is, given that the deployed squadron will have a similarly
built database to work with, how do I have them send just their data back to
home base then have their boss (the Wing) upload the data to the main
database so they can do their own report?

Thanks,

Jeff

 

[Joe Fallon]

Jeff,
This is a fairly common scenario.
To keep it simple they should export the data in a known format.
I recmmoned ASCII Delimited text files. They are the simplest to create and
also to re-import.
You need to do some preliminary work to create the Export Specification,
save it and then re-use it for the import of the data. Create some sample
data and then test your routines. You could create a small form with a
button to laiunch both the import and export routines. Be sure to use
TransferText in your code.

ASCII Delim:
DoCmd.TransferText acImportDelim, strSpecName, strTableName,
Me![txtLocalDir] & Me![txtLocalFileName], True

Good luck!

PS - Long term you could consider adding a Web site and letting people hit
it remotely from anywhere.
Maybe upgrade to SQL Server at some point too.

 

[Guest]

Thanks for the info Joe. I'll take a look at it and mess around with those
suggestions. Eventually, those squadrons that deploy will be able to access
the home base network once every overseas base is upgraded to the new Navy
network so this should work in the short term.

Thanks again,

Jeff

Jeff,
This is a fairly common scenario.
To keep it simple they should export the data in a known format.
I recmmoned ASCII Delimited text files. They are the simplest to create and
also to re-import.
You need to do some preliminary work to create the Export Specification,
save it and then re-use it for the import of the data. Create some sample
data and then test your routines. You could create a small form with a
button to laiunch both the import and export routines. Be sure to use
TransferText in your code.

ASCII Delim:
DoCmd.TransferText acImportDelim, strSpecName, strTableName,
Me![txtLocalDir] & Me![txtLocalFileName], True

Good luck!

PS - Long term you could consider adding a Web site and letting people hit
it remotely from anywhere.
Maybe upgrade to SQL Server at some point too.
--
Joe Fallon
Access MVP

I have built a database for local squadrons so they can create their status
reports for their boss at the Wing (Navy squadron chain of command). The
program is on the local network for the base and those who need access
have
it.

The problem I am running into is that when a squadron deploys overseas
they
do not have access to the same network in order to complete their report.
I
have tried to replicate my database but the copy is too large to send via
email back to home base so that the Wing can sync it and do their report.
I
have also played around with just emailing a certain table in excel format
but when I try to import that data I receive an error.

So, my question is, given that the deployed squadron will have a similarly
built database to work with, how do I have them send just their data back
to
home base then have their boss (the Wing) upload the data to the main
database so they can do their own report?

Thanks,

Jeff