Search results for query: *

Hi. We are working with SQL server 2000. We have developed an interface in Excel (VBA) that returns a record set to a worksheet then moves that data into memory. What we actually want to do is return the record set directly to memory. Can anyone help with the most straight foward way to achieve...

Hi, we would like to secure the tables and queries data and design from viewing by particular group of people by assigning permissions. We have a form that queries the tables and display the results in a grid control. However instead of looking into the tables, we would like them to only be...

Would anyone know how well Access can handle large number of tables and handling the queries? Perhaps it's not the best database design, but I have with me a database that stores values for 42 variables (x dimension) by 267 variables (y dimension) by 8 units of time (z dimension). I need to run...

I have a query that queries multiple tables, and contains a calculated field. I am hoping to find a way where I can: 1. Change the forecolor of the field IF the calculated field = yes 2. Calculate the queried field by multiplying it by 10 3. After making these changes to the query, display the...

We are trying to query an access 2000 database for records belonging to two different primary key values for the same record in the result.