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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Change SQL Pass-through in code with app security?
I am using SQL pass-through queries in MS Access 97 to run reports against Oracle databases. The user enters a date range in a form (and potentially other criteria) and clicks a button to preview a report. The button runs a macro that deletes the query and runs code that rebuilds the query...- Kincaco
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
Password aging in MS Access
We have a new directive from above to implement password aging on several of our systems. One of them in written in MS Access 2.0. It is used by our entire company to enter their timesheets. Does anyone know of anyway to implement password aging in MS Access - any version. We've put off...- Kincaco
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
Security 2,000 MDBs
About 3 years ago we gave everyone in the company MS Access a few classes and turned them loose. 3 years later, all nightmares have been realized and now we are trying to get some control. In the next few months, we will be taking all MDBs back under IS control. We want to secure all these...- Kincaco
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
-
GROUP BY with SUM takes too long
In MS Access, I can run this SQL in about 9 minutes. I am trying to convert it to an Oracle view so that users can link to the results instead of having to export it from Access and import it into other applications that don't support SQL. I am having difficulty with... -
table joins - find all hours worked plus employee information
What is the best way to join 2 tables: 1) hours worked, 2) employees - to get employee information (name, supervisor, etc.) for employees who recorded hours worked in a date range (the dates will be in the hours table.)?<br>I don't want to see employees who did not work in that date range.<br>I...
