Search results

Hi guys An Access 2003 append query is failing due to 'key violations'. It is meant to append data from a linked csv file to a linked table in a SQL Server Database. The error message reads: "MS Access...didn't add 1329 records to the table due to key violations.." There are exactly 1329...

Hi, I have a form with many slow and cumbersome dLookup formulae in textboxes. I want to replace it with a neat and dynamic query subform. For this I need to add the numerical results of two queries in something analagous to an inner join. But inner joins only exist for tables, and you can't...

Hi All I know the multiple users issue is extensively documented in this forum and elsewhere, but I've been unable to achieve what I need yet. Background: I have an Excel application. This reads/writes to an Access DB, using SQL strings in VBA, via DAO. Works fine. Requirement: I need to...

Hi All I joined a few weeks ago, already had somereally helpful tips on here. My educational background is more maths & econometrics, but in the real world I now find myself needing databases and SQL more and more.. Am doing an internship where I am, rather alarmingly, in charge of various...

Hi all. Intro: I'm a DB/Access novice, doing an internship at a firm with no real in-house IT expertise, so I'd be very grateful for any advice on optimising this query. Am I doing something wrong, or is is this the best possible performance? Background: I've made an Excel Application for...