Search results

You might be able to use the Document Object Model. I gave it a whirl using Access 2003 but it might work in earlier versions. But here's the problem. This xml reader doesn't like your xml text, specifically the phrases where the datatypes are defined as "string". In other words here's what it...

Is this really an Excel file? When I copy and paste the data into a textfile and change the extension to .XLS, I find that Excel 2003 cannot read the file. Maybe Excel 2007 can read it? (I don't have Excel 2007 installed).

Well, today it was slow again, so I took another look at your post. I just tried it and it worked. I'm going to start doing this regularly, hopefully I'll get consistent performance. Thanks !!!

Attached is a sample to get you started. I can't guarantee I'll have more time to work on this, but feel free to post more questions.

Not sure I follow you. The structure of the DBs is the same accross all ten. I only designed one DB, an empty one which I called BlankDB.mdb. Then each time I needed to create a database, I simply copied BlankDb.mdb to the destination folder and then populated it. Therefore all ten DBs were...

Well, you're right (as usual). Turns out I was indeed barking up the wrong tree. At first I thought I was right because the DB was running faster without compacting - but then, after last night's update (i.e. more INSERTs), it got slow again. About a half-hour ago I stumbled across a...

The coding as such is probably fine, since all the DBs underwent compaction successfully at least once. But recently I started compacting nightly and one of the DBs became slow after compaction. I recently tried rebuilding it and then compacting from the Access interface (just for kicks) but...

I deleted the DB last night and then repopulated a new copy of BlankDB.mdb. I did not compact. It's running fast again. This is a pretty strong confirmation of where the problem is - the last two times I rebuilt this DB with compacting it ended up slow, but now without compacting it's fast...

The class oQuery is a fairly long piece of code that adds parameters automatically and, for ease of debugging, reports any discrepancies (for instance if I added too many or too few parameters). This class is well-tested, though (I use it in other programs). Here's why I think the problem...

Both. I use OleDB to insert records. Oledb cannot compact, as far as I know. So I use DAO for that. private bool funcCompact(string pathToDB, bool silently) { object MissingVal = System.Reflection.Missing.Value; if (!File.Exists(pathToDB)) return false; string dir =...

Thanks guys, but I'm not using Access. I'm using VB.Net (well, C#.Net actually). I'm not running MsAccess.Exe. I'm simply using the OledDB provider to populate an .MDB file by running INSERT commands. I currently have ten of these files. (2 for each year starting from 2006). With 9 of the ten...

I'm using C#.Net to populate an .MDB database, and invoke the DAO 3.6 library from C# to compact the file nightly. I'm now having a performance issue, and I'm wondering if the nightly compacting is what triggered it. (I can't remember when I first began the nightly compacting). I've deleted...

Oh, I see. The other thread is here: http://www.access-programmers.co.uk/forums/showthread.php?t=196831

Have you tried: If dteEndDate < dteStartDate Then DatesAreBad = True

What error msg are you getting?

Did you enclose your date in pound signs? #01/05/2010# Also, do a MsgBox(SQL) and then hit Control-C to copy and paste your actual query here for others to examine it.

Thanks Bob, I feel a little silly about missing that. For me, that's par for the course though.

See attached query. The inner SELECT works fine as a standalone query, but when wrapped in the outer SELECT, I get the error "An action query cannot be used as a row source." I'm running this query on an MDB file from C#.Net, but I get the same results if I copy and paste it into Access 2003...

I thought I saved "qryFinal" - guess not. Just paste in the SQL yourself and save it as "qryFinal."

Here's a solution - that took some time ! But I didn't manage to print the summary in numeric order. I used an Order By clause, which almost produced numeric order, but I had to UNION in a totals row, and the UNION engine messed up the numeric order. Maybe someone else can help with that part...