Yes we can ping the web server OK. When we try to get access to the web server, a login window is displayed but no User/password will give us access and vice versa when we try to get access to the NT server from the Web Server.
I have an NT Server which is working fine. I have recently setup a Web Server with IIS and that works fine, In that I can access the Web Pages over the Internet browser. But I cannot see the Web Server from the NT Server and vice versa. The login script is displayed but no Domain/User and...
From Peter,
No, that does not make any difference.
Further investigation shows with a sql query (auto generated by the remote view designer) as follows :
SELECT *;
FROM "Daily ODP Detail" Daily_odp_detail;
WHERE Daily_odp_detail."Employee Id" = ?mEmp;
AND...
When I create a remote view (MS Access) with a parameter filter (ie ?mParameter), the remote view works correctly, but I am unable to subsequently modify the remote view. An error message informs me there is a 'Syntax Error'. There is no error message when I do not use a filter.
Any suggestions...
The question was 'How does one update an access database table with a field name of date using Remote Views'
For completeness of this thread and in answer to thread 184-89215 (which was never answered because the developer was in a position to modify the field name), this is what my research...
The use of square brackets works in VB and SQL Server, but does not work in VFP. This is proving to be quite a problem since I does not have the ability to modify the Access database being third party software.
This is not a MS Access Question
I am trying to update/insert a record in a third party MS Access Database table from VFP using remote views. Unfortunately two of the field names are 'Date' and 'Type', which prevents the insert command working. The replace / append command works, but I cannot update or change the data in those...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.