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!!!!!!
mike4
0
Newbie Poster
Recommended Answers
Jump to Postit might be. but using ms-access directly to create ur db may raise a version confliction problem when you will be trying to connect it from your vb application.
for your kind information, your vb application is unable to access data from any db created in ms-access rather than …
Jump to PostI strongly believe there is no limit for the number of records in access database.
Try to create index on the fields for faster data access.
All 6 Replies
choudhuryshouvi
33
Posting Pro
debasisdas
580
Posting Genius
Featured Poster
mike4
0
Newbie Poster
choudhuryshouvi
33
Posting Pro
mike4
0
Newbie Poster
choudhuryshouvi
33
Posting Pro
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.