Access 2000 Database Entry Question
When creating a table is there a way to set the first entry as a drop down menu and the associated entry as a currency entry on the same line? We are trying for an employee database that has several extra jobs that we would like in a drop down menu and then be able [...]

Answer Question   |  November 3, 2010  6:47 PM
Access 2000, Access Database, Access database permissions, Database query

What is wrong with this database search query?
searchStr =|FIELD Form =Form1  & FIELD CallsBeginDate >= | &  Trim(Cdat(doc.DeleteStartDate(0))) &  |  &  FIELD CallsEndDate <= | &  Trim(Cdat(doc.DeleteEndDate(0))) & | & FIELD Team =| & Trim(doc.OnCallTeam(0))&|| I have used with NotesDocumentCollection. Thanks for any feedback  

Answer Question   |  August 3, 2010  6:44 PM
Database query, Lotus Domino, lotus notes 7.2 error, Lotus Notes Database, Lotus Notes Domino

How do I limit access to query libraries?
I have employees who have moved from one division to another and had access to queries in other libraries they should no longer have. How do I limit them to a specific query library to keep the data secure?

Answer Question   |  July 16, 2010  12:22 PM
Database query, Group permissions, I5 security

Reduce the response time when querying the database
I am working on a plain java/J2ee project with Oracle 9 at the backend. The issue comes when I am querying the DB and more than 10000 records are retrieved. I can’t change the business logic much, since the code is developed by some other people and I’m not allowed to do so. Any tuning [...]

Answer Question   |  June 16, 2010  8:06 PM
Database query, Java, Storage in 2010

search a data in database
I want to find the data in a table,but i dont know the table name and column name.All I know is the data and the database name . [strong]Is there a query to find the table and column which contains that data[/strong]

Answer Question   |  June 9, 2010  4:27 AM
Database query, SQL development

Large table in ASE 15.0.3
Hello - I’ve got a process that loads 56million rows daily (via bcp) into a table, maintaining this data for 30days.  Our company is too cheap to pay for semantic partitioning so i’m wondering if anyone has any ideas on how to make queries respond in a semi-timely manner.  There’s one date column, and two other [...]

Answer Question   |  March 19, 2010  8:21 PM
Data Tables, Database, Database query