I have been spending a lot of time trying to find out why some of the code used to insert new records into a linked SQL Server table would systematically fail with an error: Run-time Error ‘3155’ ODBC–insert on a linked table failed It was driving me mad. I could insert a simple record using... » read more
In the perspective of upsizing my current Access 2007 application, I have been trying to understand a bit more about the possible performance impact of various choices of Primary Keys. My problem is that currently, the Access application uses autoincrement numbers as surrogate Primary Keys (PK). Since I will need to synchronise the data over... » read more
I’ve just lost 2 days going completely bananas over a performance issue that I could not explain. I’ve got this [Dell R300][1] rack server that runs Windows Server 2008 that I dedicate to running IIS and SQL Server 2008, mostly for development purposes. ![Dell PowerEdge R300 Rack servers][dellr300] In my [previous blog entry][2], I was... » read more
When you start building an Access application, it’s tempting to just think about today’s problem and not worry at all about the future. If your application is successful, people will want more out of it and, over time, you’ll be faced with the task of moving the back-end database to a more robust system like... » read more