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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
need help with queryies
It sounds like to you want to base your report on a query that has both tables and uses the time field from the second table. Hope this helps.- Kincaco
- Post #2
- Forum: Microsoft: Access Other topics
-
Change SQL Pass-through in code with app security?
I have the code working with no security. I am in the 'hunt and peck' process of applying/removing security to try and find the right combination. I was hoping someone could spare me some trial and error. Thanks!- Kincaco
- Post #3
- Forum: Microsoft: Access Other topics
-
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
Currently we are using Access 2.0 and the default SYSTEM.MDA has been setup with multiple user ID's. However that is not written in stone. If it would work better to update to Access 97 or 2000, not a problem. We could also use a custom security file (and probably should for many reasons)...- Kincaco
- Post #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
-
Growing mdb file ! ! !
I have fought the battle of compacting MDBs since version 2. As others have stated, it the nature of the beast to need user cleanup. However yours does seem to be growing uncommonly fast. I have had success with creating an icon to do the compact and giving it to a specific user as part of...- Kincaco
- Post #11
- 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... -
MOTIVATING YOUR TECHNICAL STAFF
Make sure each technical person gets the training and experience they need to grow in technical skills. Both the company and the employee benefit from this. <br><br>Also, scheduling blocks of 'do not disturb' time when critical projects are being worked on. That...- Kincaco
- Post #5
- Forum: My own development as a professional
-
table joins - find all hours worked plus employee information
Thanks carp. That join worked. The problem (which I failed to mention originally) is that I want to append this data to an Access table for temporary processing. Eventually I will be pulling information from 4 or 5 tables into one data set for... -
Deleting SQL table records using MS Access
You have to have delete permissions on the table that you are trying to delete records from. Can you delete the records using SQL Plus? If not, it is probably a permissions problem. Otherwise, check the query properties in Access. Make sure it is... -
SQL VIEWS IN ACCESS
I work with Oracle views in MS Access frequently. We first create the view in Oracle, then attach to it in MS Access the same as any Oracle table. The view needs to have permissions, etc. the same as any new table. The basic syntax for creating an Oracle view... -
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...
