Could be the 2003 / 2007 compatibility. Have you tried to Back up database (rather than compact)? I have a database that imports lots of data and then creates 100's of PDF files and even though it is only 200Mb it takes 10 mins per pdf, yet if I backup the database it takes 10 secs per pdf.
Second attempt!
Add this line to your Excel code:
'Run Code
oApp.Application.Run "Test_Message", strN, dteN
I previously assigned name and date to strN and dteN
Create a module in Access with the following code:
Function Test_Message(strName as string, dteStart as date)
MsgBox...
Use a form with a textbox where you type in the date. In the criteria of the query use in the date field: Between Forms![Form Name]!ControlName AND (dateadd("m",1,Forms![Form Name]!ControlName)-1) This will give you a months worth of data.
Am trying to delete info from tblA that exists in qryB.
SQL: DELETE tblA.*
FROM tblA INNER JOIN qryB ON (tblA.fld1 = qryB.fld1) AND (tblA.fld2 = qryB.fld2);
I view the results in design view. Shows the 42 records that I want to remove.
Run the query: "Could not delete from specified...
The reason for this is that in 97 you code with DAO and over 2k you use ADO. Convert the database ignore the warnings and when you have got the new 2002 version of the database:
1/ click on the Module tab
2/ Open a module so that the VBA editor screen is showing
3/ From the toolbar select...
Would have done it the other way and had the script on the network db, with that db forcing the data to the server. This script can be launched through windows scheduler calling a macro within the database by using the /X switch
eg "c:\program files\microsoft office\office\msaccess.exe"...
The following code will look through all subfolders, returning mdb files to a table. Amend, play etc!
Set rstMDB = CurrentDb.OpenRecordset("Found", dbOpenDynaset)
With Application.FileSearch
.NewSearch
.LookIn = "k:\"
.SearchSubFolders = True
.FileName = ""...
Create a new table with 2 columns and 24 rows. Hours in 1 column and group name in the other ie:
Hr GN
00 0-3
01 0-3
02 0-3
03 0-3
04 4-7
05 4-7
etc.
Now in query design link Hr with HourInterval from your current summary and use GN in your new query and group on that.
HTH