Search results

Hi all, I have an interesting issue and I was wondering if anyone has seen the same thing. We have an access database which has an oracle ODBC linked table. It is a large table with ~2.9 million records. A few days ago the table was working fine, opened instantly in Access. The DBAs have...

Hi folks, I have noticed this issue a couple of time and I know the solution but have no idea how it happens. Just wondering if anyone has seen this before? On a couple of users computers, not all users and not a the same time, users have been been getting errors in VBA where the Microsoft...

Hey, was hoping somebody could help me. I hope this has not been answered somewhere before but I could not find it. Our office is stuck using access 97. For obvious reasons I would like to follow the rest of the world into this century and move to 2010. Problem is that over the years many...

Hey, Does anybody know of a way in Access 97 to trap an error thrown by a macro. The macro is been called in vba by docmd.runmacro so I presumed that the error thrown by the macro would be caught by VBA error handling but it is not. Any ideas? Ps. I know this is easier in the newest versions...

Hi! Can anybody help please? I have a form frmCompany and a subform fsubCompanyRole in an ms access front end. They are bound by tables tblCompany and tblCompanyRole and linked by lngCompanyId in an ms access backend. I want to stop users deleting all records from fsubCompanyRole for any...