Salim,

There are several datetime functions that will provide you with the ability to count time in HH MM SS using quires if that what your trying to do.  DatePart() and...

Stephen,

Check the login permissions and ensure the SQL views have been granted rights.  Both Tables and Views should be available as long as SQL permits access.

If you have a session...

atif saeed khan,

I find converting the true date to a varchar helps when searching for date with between function.  Typically your as to find dates between mm/dd/yyyy without time. ...

I have worked with Access 97 and 2000 over the last few years and found that Access Linked table to SQL is fast approach to solving business needs especially when Scope...