wvrotorhead
MIS
Thanks in advance for any advice folks! Here is my problem:
I am writing a web application as data access pages in Microsoft Access 2000 which will allow our customers access to reports and other data pertainant only to them. My proposed method of doing this is to send a text file to my customer containing only his customer name and customer number which will be used for filtering data on the web-based back end.
When mister customer connects to our web app, a query looks for the text file, which has been set up as a linked table in the database. The very nature of this filtering also provides security by preventing this customer from viewing other customer's data.
The problem is, when accessing the page remotely, the obvious occurs, the back end is unable to find the table, as it doesn't exist on the webserver's local C: Drive.
How can I make the query, which is sitting in the access database on the web server, use the file sitting on the customers C: drive?
I am writing a web application as data access pages in Microsoft Access 2000 which will allow our customers access to reports and other data pertainant only to them. My proposed method of doing this is to send a text file to my customer containing only his customer name and customer number which will be used for filtering data on the web-based back end.
When mister customer connects to our web app, a query looks for the text file, which has been set up as a linked table in the database. The very nature of this filtering also provides security by preventing this customer from viewing other customer's data.
The problem is, when accessing the page remotely, the obvious occurs, the back end is unable to find the table, as it doesn't exist on the webserver's local C: Drive.
How can I make the query, which is sitting in the access database on the web server, use the file sitting on the customers C: drive?