Search results for query: *

Andy Baldwin, Thanks - I'll consider that route. I want to stick to DAO if I can though, as once I go down the route of ADO I will have a lot of work to convert... and I am happy in principal with DAO (but that's another thread!)... Cheers.

JimmyBlogs, Yes, I think it is in the Edit Loop. I am using .update after every .edit, but this has worked fine in Access 97 for a number of years. What alternative could you suggest? Due to the way the edited data is compiled, it would be difficult (but not impossible) to convert to a SQL...

Hi - just one recordset - working through all the records in one table - making an edit to each one. If, instead of editing each record in the recordset, I set set the code to write the changed data to a new table (.addnew .update - DAO), the problem disappears. So it is something to do...

Hi thanks for the advice. Unfortunately, the option is already set as you describe and, whilst compacting would shrink the file, the problem is the routine bloats it so much (from 30MB to 2GB in under 60 seconds!), you don't even get a chance to do this. Cheers anyway.

Hi all, My company has just converted from Access 97 to Access 2003. After years of largely trouble free 97 databases , I am now experiences a wierd issue with 2003. My VBA using DAO 3.6, simply runs through each record of a table, and makes an edit to them all using standard .Edit and...

Hi, I connect to the Internet on my fairly standard Windows 2000 PC via an ADSL modem. It always connects first time, but recently browsing all websites has become problematic. I see the old "Cannot find server or DNS Error" in IE6 frequently, but hit refresh a few times (perhaps 5 - 20...

Hi RamziSaab, Yes, sorry, forgot to mention -- Have already checked MS Knowledge Base -- all suggestions there have been tried to no avail. Cheers.

We have a Laptop which comes up with the following error message each time Excel 97 is launched: Excel Initializing the VBA Libraries(2) Macros seems to work OK, and under Tools, References all looks OK. Any ideas -- perhaps a missing file or setting? The (2) bit of message is a possible...

Hi - a few months after your original post, but found this after a quick search, gave up and then found a solution. If you want to allow users to select entries via data validation list and then protect the sheet so that no further entries can be selected in the validated cells, then you need...

CajunCenturion - thanks, that it just what I was looking for... couldn't for the life of me remember if this functionality was available in VBA.

Hi, I have a table which contains a text field populated with formulas: For example: "4*4 + (7*10)" "5 * 1.175" I am looping through this formula table and would like to assign the *answers* to the formulas into an array. This is fine if I want to store the actual text...

Bill -- thanks, it worked a treat. Ed.

All, I'm using Access 97 and I need to build a routine that deletes objects (in this case, tables) according to a wildcard specification. The table names all start the same way (tblx...), and there are almost 400 of them, so what I want to do is delete them all without having to specify their...

Using Excel 97 sr2 and NT 4.0.1381 Getting problems with complete application crash (NT Error No 87) when dragging a data series on simple spread sheets. Anyone got any ideas why this might be happening. Other PCs in the company with same config don't seem to have the problem, but a colleague...

We have an Access database application. which shared by approx. 8 users. Part of the application deletes data from a table (less than 1000 records) and this has been fine for the last 6 months, but we are now getting the following error message: RunTime Error 3218 - "Couldn't Update...