Link table on ISP FP server

K

Kathy MacAthur

Wondering if someone with more FP / link table/ ISP experience might help.
We're using FP on an ISPs server and trying create a link table - linking
our online DB with an excel spreadsheet that we update with shipping info.
The DB is in the FPDB folder and we link this DB with the excel
spreadsheet - we can do it on our local system but it appears there's some
security issues or FP issues when trying to create the link via the ISP.
Our ISP does not have Access on the server so we are unable to have them
create the link. Once the link is created we are in good shape and will run
an update query to update the server DB with tracking info.

We create the link locally by using Access - file/get external then linking
to the Excel Spreadsheet, but once again, we can't duplicate this within the
FP ISP system.

Any suggestions? Thanks!!
 
T

Thomas A. Rowe

When you use the Access database on the web, you are not using the Access application. You need to
create a ASP/VBScript update query that can read the uploaded Excel Spreadsheet (or .csv file) and
then update the online database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
K

Kathy MacAthur

Thanks!..

Thomas A. Rowe said:
When you use the Access database on the web, you are not using the Access
application. You need to create a ASP/VBScript update query that can read
the uploaded Excel Spreadsheet (or .csv file) and then update the online
database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
S

Stefan B Rusynko

You could also try using Excel as a Data Source
(not generally recommended if you can use Access since Excel is single user)
See http://support.microsoft.com/default.aspx?scid=268948

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Thanks!..
|
| | > When you use the Access database on the web, you are not using the Access
| > application. You need to create a ASP/VBScript update query that can read
| > the uploaded Excel Spreadsheet (or .csv file) and then update the online
| > database.
| >
| > --
| > ==============================================
| > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > ==============================================
| > If you feel your current issue is a results of installing
| > a Service Pack or security update, please contact
| > Microsoft Product Support Services:
| > http://support.microsoft.com
| > If the problem can be shown to have been caused by a
| > security update, then there is usually no charge for the call.
| > ==============================================
| >
| > | >> Wondering if someone with more FP / link table/ ISP experience might
| >> help. We're using FP on an ISPs server and trying create a link table -
| >> linking our online DB with an excel spreadsheet that we update with
| >> shipping info. The DB is in the FPDB folder and we link this DB with the
| >> excel spreadsheet - we can do it on our local system but it appears
| >> there's some security issues or FP issues when trying to create the link
| >> via the ISP. Our ISP does not have Access on the server so we are unable
| >> to have them create the link. Once the link is created we are in good
| >> shape and will run an update query to update the server DB with tracking
| >> info.
| >>
| >> We create the link locally by using Access - file/get external then
| >> linking to the Excel Spreadsheet, but once again, we can't duplicate this
| >> within the FP ISP system.
| >>
| >> Any suggestions? Thanks!!
| >>
| >
| >
|
|
 

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

Top