I made a hotel software and connected it to a access database created using the visual data manager. The software runs very well but when records in a table for daily stock taking reaches around 2000 the software starts messing up with my table. I am suspecting that the table has a limit as to the number of records. But every book and notes contradict this. Even on entering manually a record at this point , I close the table and on opening, its gone! Wold it help if i use ms access to create a table instead of the visual data manager?pls help!!!!!!