Upload a file to the server

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a split database. The backend is on a file server and the frontend
is on each user computer. The user is required to create a record and
supply the report to the server on a form. What is normal way to accomplish
it?

Thanks,

Scott
 
You don't need to do anything special. The frontend contains linked tables,
linked to the backend on the server. Whatever changes/additions they make
will automatically be stored in the backend.
 
Joan,

Thanks for your response. I did say the entered record but the submitted
report file. I need the user to submit his/her report file to the server
like something of attachment in web mail. I always use it but unsure how to
do it in Access. Any idea?

Scott
 
You're still not being clear. Assuming you mean that they have an Access
report that they wish to save as an external file, what format is that file?

If it's an Excel file, you can use the TransferSpreadsheet or the OutputTo
methods. You can also save a report as a snapshot file and those without
Access can view it using the snapshop viewer. Stephen Lebans has a utility
to convert a report to a pdf file http://www.lebans.com/reporttopdf.htm
 
Joan,

May I explain my request again. My colleagues complete reports in word file
format and fill in some details about the report in the database file for
future retrieval by other co-workers using the database. The database is
used as an interface for the co-workers to find the reports required. The
database does not need to store the report contents but some parameters for
use in search purpose.

As long as the further completes the report, fill some parameters into the
database and submit the report. The database will create the link to the
report. Once the user searches the report, he/she can click a button to
open the report for reading. Hope this helps to clear it up.

Thanks,

Scott
 
I 'think' I understand. They create a Word document and save it on the
server.

They open the database to enter some details about this report(Word
document), and you want the database to also hold a link to where the report
is located.

You can use the code at
http://www.mvps.org/access/api/api0001.htm
that will allow the user to select the location of a file. You can then
store that path in a field and later use it to open the file.
 
Back
Top