Search results

Hi I am trying to import a table from a notepad doc and i get an error message " The search key was not found" Please can someone explain to me what this is about and if there is a solution for it. Does this have anything to do with size of the database beign too large? Thanks Avi

Hi Does anyone know how to overcome MS Access not responding error. I am trying to change a Data Type on Access 2003 but the data is large and stops responding. There are about 550 000 records in one of my tables and when i try to change the data type after importing the data, it crashes. I...

Hi Is there any way i can increase the amount of columns in a table before importing data? I am importing data from a notepad doc that needs abt 300 columns but i can only get abt 100 columns. Thanks for any help

Hi Can someone help me with this query below. Is there a way to list all columns in a table that contain Null Values. I have imported data into a new table but not all columns contain data. I need to write a query to list all the columns that have null values. The result needs to give me a...

Hi I am trying to compare data in two different tables and list the data that does not match. Not sure if this is possible. Details below Table 1 xyz - A1 - Do not use ABC - A4 - Use Table 2 123 - A1 The result of the query should show me A4 (as this does not appear in table 2 I am...