Search results

Re: Cannot open Access 2003 - error "...communicating with OLE Server or ActiveX cont The machine doesn't have Norton on, it has Symantec, and there wasn't an update. There was an Adobe update immediately before the time when I couldn't open Access. Most of the online suggestions of what causes...

Re: Cannot open Access 2003 - error "...communicating with OLE Server or ActiveX cont JHB: a re-install of Access is what cured it in the end. Gina: I could not have sent you images of Forms or any other objects as I couldn't even open Access. Somehow MSAccess itself got corrupted, and I'm...

Cannot open Access 2003 - error "...communicating with OLE Server or ActiveX control" Hi all I've been working with Access for nigh on 20 years and I've never encountered anything as frustrating as this. I've been unable to do any work this week because every time I try and open Acc2003 in Win...

The simplest way is that T2 has a primary key that is made up of 2 fields, PatientID and SessionID, where SessionID is between 1 and 4. You might also want a simple counter field in T2 also, Indexed-NoDuplicates, just so you can keep track of how many sessions there have been overall. It...

Success ! on Pat's suggestion I ran almost a million update queries, rather than using Recordet.Edit statements, and it worked perfectly. The database increased in size only by about 7mb, which is just fine. No unexpected massive file-size growth. Thanks again.:D

Hi Pat AcID is just a variable long integer that starts at 1 and increments by 1 in each loop iteration, and by the time it gets to the 360,000th record, it's at 360,000. I will try your suggestion of an update query and see if the database doesn't expand dramatically as it has been doing. There...

I have a fairly simple procedure (using recordsets) that is editing one field in one table, on each of a million or so records. Don't get upset by the number of records, the database works fine, multi-user, with all those records. The single field is a Number, size Long (4 bytes), and when I add...

Hi 20-years or so experience with Access database/application design/development. Never got past Acc2003 though due to work constraints. Fairly good with code..I hope !