Hi Mariostg and thanks for your quick reply!

I must confess that I'm new to working with Access and databases in general so asking about the query builder was a good thing! After having learnt how it works I realised that I had written the wrong columns in the query. This was solved by changing

strSQLLinkSpeci fic = "SELECT KEY_LinkSpecifi c FROM subTbl_LinkSpec ific, [Hazard List Bridge] WHERE ID_LinkSpecific = SpecifikOrGener al"...

Hello everyone.

I'm trying to construct a database in Microsoft Access 2003. The first person that is going to use the database wishes to do all her work in Excel and then the database is supposed to be updated by importing the Excel document into my Access database. This means that I will have a big table that is imported from Excel. Since I'm pretty sure that later users will want to be able to update things directly in the database,...