Search results

Hi There are a few tables. some of them have abt 700 000 records and some have abt 900 000 records. The data is from SAP so they have header data and line data. I am not familiar with the compact / repair feature. How do I go about using that feature? I have now cut down the size of the data...

Thanks I tried both ways. You are correct that when access creates the primary key its better. I think that Access has a 2GB limit to the data it can store. I have maxed this out and I have not completed the data imports yet. Perhaps I should be using a different database. Any suggesstion? I...

Error Message - The search key cannot be found Hi I am importing using a notepad text file. 1. Right click 2. Select Import File 3 Choose file from drive 4. Set to delimited with Pipe character as the seperator (This is set in the other field) 5. Choose first row as heading 6. Set...

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

Thanks I looked into this but i dont understand why the CPU usage goes down to 0% and MS Access is not Responding. This happens after about 1 min. I also tried increasing the Virtual memory size but that did not help. I am running out of ideas.

Access Not Responding Thanks I have increased the SWAP File but still no luck with the freezing. I also tried a new table but that did not solve the issue. Thanks for that advice though. 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...

Additional Columns The text in notepad is seperated by the pipe symbol - |. when i import data, i use the delimited option with 1st row beign the column headings. I do not have much knowledge of coding so am not sure how to do looping. Thanks

Increase fields Hi When i am importing data, i can only import upto 100 fields and not 255. Is there a way to import data in all 255 fields?

Thanks The count option worked. I grouped all by count the result that = 0 is the columns that do not have any value in it. This is useful as i can maybe exclude these columns when importing from the same tables in the future.

Extra Fields Thanks Do you know how i go about adding these fields on? Can i make it as a default value of fields before i import data into it? ie: every time i import data, it needs to fill all 255 fields.

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 I have tried it but am not getting the correct result. eg below of what i am trying to achieve. Basically, i got 1 table with 2 columns. Table A Column 1 Column 2 Column 1 has lots of data Column 2 has no data The query should show me only column 2 as it has no data in it. 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...

Thanks That works and gives me the correct result. I should have been more aware cause that was staring me in the face.

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...