Recent content by PhilippeRG

With regards to Access handling the updates, yes that's exactly what I mean. For the errors, I know the error codes and description from the error handling and whether they occur on the form or sub/function. With regards to your scenario it's possible but actually most of the situations are a...

I just let Access handle the updates, my understanding is that DAO is the default (only?) for ODBC linked tables. The thing is, the errors are being handled by my error handling code, but instead of resuming it crashes. I have tried replicating by disconnecting the network and in this case the...

Hello Lagbolt. I'm using DSN-less connections to the back end SQL Server to create linked tables at runtime. I've experienced one crash with the accdb but I never use it on the live database in a multi-user environment for any length of time. The users report the crashes (maybe 3 a day) and they...

Hello All I have a problem that is reallly stumping me. I am developing an Access Runtime front end, linking to a SQL Server 2005 back end database in the cloud. Everything was working until recently, when users started reporting seemingly random ODBC errors. These manifest by an error message...

Hello All I'm a new member just joined, from Brighton in the UK. I used to be a computer modeller in a previous life, but have been working with SQL Server (db,SSIS,SSAS,SSRS) for the last 6 years in the insurance industry, and Access for 3 years though I've used it in an 'amateur' way for a lot...