Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DATE BETWEEN causes exception
SQLBill, In Access I displayed the Data Link Properties. I selected the second login option and provided a SQL username and password. Also, as a test I selected Windows NT Integrated security login type. I logged in as the general user and then attempted to run the report. Here's the...- EdSwartz
- Post #5
- Forum: Microsoft SQL Server: Programming
-
DATE BETWEEN causes exception
NiceArms, Per your suggestion I converted the DATE BETWEEN style to using the >= <= operators. I still get the exception. Ed- EdSwartz
- Post #4
- Forum: Microsoft SQL Server: Programming
-
DATE BETWEEN causes exception
SQL 2008 10.0.2531 Access 2007 When I run a report in Access 2007 which executes a stored procedure Access generates an exception. The cause appears to be DATE BETWEEN elements in a WHERE clause in a table-valued function. The general sequence is: - Access Report -- Stored Procedure ---...- EdSwartz
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Programming
