Search results for query: *

I have an Access Database in 2003 format that is locked. The problem is, no one is in the file any files that have linked tables to it. When I try to compact the DB, it states that my computer is the one locking it. I have exited and restarted my computer, but still no change. Any ideas?

Here is the code that I am using. It isn't much quicker (about 2-3 secs) but some time is better than none. If you have any other ideas on speeding it up, I am willing to give it a try. Function GET_ACCESS_DATA(SQLSTRING As String) Dim QD As QueryDef, RS As Recordset, RCD As Long Dim i As...

Thank you for you quick response. I tested this out and the performance is the same. I believe the issue is in the fact that Office has to get to the end of the recordset to load it into the array for the GETROWS command. If you have any more ideas, please let me know. I will post if I find...

When I get the data into the array, I match the first field of the array (which is a SKU number) to a list of numbers (up to 65000) in Excel and "paste" down the rest of the data in the array. So going one record at a time is not an option. Vidar- Thank you for your responses. Unfortunately...

I reposted in forum707. Thanks for I didn't know exactly where to post this question because it falls within 3 Office programs (VBA, Excel and Access). You may be able to help really quick though. Can you work with a recordset the same as an array? Thanks for guiding me in the right...

I have been trying to do this for sometime now. I have code that "works" but it takes too long to come back. I am trying to download a Access query into an array. I cannot take less data than what I am grabbing. Here is my code: Function GET_ACCESS_DATA(SQLSTRING As String) Dim QD As...

I have been trying to do this for sometime now. I have code that "works" but it takes too long to come back. I am trying to download a Access query into an array. I cannot take less data than what I am grabbing. Here is my code: Function GET_ACCESS_DATA(SQLSTRING As String) Dim QD As...

Nevermind, I figured it out. It had to do with the groupings that I had.

For some reason when I put the original code in VB, it highlights every other page. Where would I be going wrong with this?

Thanks for your help PHV. Worked like a charm. Tom

I don't know if this is possible, but this is the place to ask this. I am trying to have a query that can be ran 3 different ways: 1. All records. 2. Records that begins with a prompted string. 3. Records that don't begin with a prompted string. I can do all 3 seperately, but want to do them...

Worked like a charm! Thanks, your help is greatly appreciated! About the numerical column headings, I figured that as long as the system knows what it is looking at, I don't need to put some more arbitrary characters in front of it. I might do that so the next person that looks at the file...

Here is the SQL: PARAMETERS [forms]![frmONORDER]![CAT_SEL] Short, [forms]![frmONORDER]![DEPT_SEL] Short, [forms]![frmONORDER]![CLS_SEL] Short; TRANSFORM Sum(ONORDER.TOTAL) AS SumOfTOTAL SELECT ONORDER.NUM_LT, LOT_MASTER.DES_LT_NUM, LOT_MASTER.CD_SYL, LOT_MASTER.CD_NAR_ALI_SSN_YR...

Hello everyone, I am trying to put together an OnOrder report. In my table I have Lot/Week Ending Date/Quantity as my columns. Because of the way I have the data, I need to use a crosstab query to extract each individual Week Ending Date across the top of the report. I have given the...