Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Looking for advice on how to approach a certain scenario

Posted on 2014-10-03
5
Medium Priority
?
102 Views
Last Modified: 2014-10-04
I have a database that is used by people in the office.  Then we have people that work outside the office and they are called field personnel.  Using the "office" database we want to be able to export a record that is being viewed on a form.  In addition to this we want to export another record that is related to that record being viewed on the form.

Then, I believe that the field people need a separate copy of the database with everything removed that they don't need other than the form so they can view the same record when they receive it.  They will edit the record and send it back to the office.

What is the best way to handle the transfer of the record back an forth.  Has anyone done something like this before?  

--Steve
0
Comment
Question by:SteveL13
5 Comments
 
LVL 40

Expert Comment

by:PatHartman
ID: 40359538
Do the field people enter or update data?  Or are they just viewing it?
0
 
LVL 28

Expert Comment

by:omgang
ID: 40359614
I have done something similar years ago with an Access application (Access 2000).  We had four regional locations all using the same inventory control system (Access app).  Every Friday night, three of the offices would FTP their back-end Access db to our home location.   We had another Access app whose sole purpose was to merge the data from the four back-end databases and produce a new 'master' copy that was FtPd back to the other offices.  On Monday, we'd all start with the exact same set of data.
The process was not simple but was 'cheap' and it served its purpose.   We eventually went to a Windows Terminal Services solution where the regional offices all worked on the same app and back-end db via Citrix remote connections to the home office.
All that being said, since you have to get a copy of the 'thin' app to the Field Folks via internet (I'm assuming this is how you plan to distribute), it seems to be you'd be much better off developing a simple web app to allow them to view/update necessary records.  It could be something as simple as a classic ASP web app with an Access back-end or a .NET app with a SQL Server db back-end.  This is the direction I'd pursue.
OM Gang
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40359623
Have you considered using SharePoint?
0
 

Author Comment

by:SteveL13
ID: 40359719
Pat,

The field people will edit the data and return it somehow.  I don't think SharePoint is an option at this time.
0
 
LVL 40

Accepted Solution

by:
PatHartman earned 2000 total points
ID: 40359765
I would use TransferText or TransferSpreadsheet to export a query that contains the selected data.  The user can send that file via email and then the Access app can import the transferred file.

If the data is from a single table, the process is pretty simple but if the data is hierarchical in nature then the export must export using a query rather than a table and the import process needs to apply adds/updates to multiple tables in the master database so it must be done with VBA and can't use a single update/append query.

If you want to automate the process, you can use s special email address or code in the subject line to get the email into a separate folder.  The Access app can read the folder periodically or on demand, process the emails and extract and save the attachments.  Then process the saved files.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question