>>>>I know there has been a lot of discussion recently of Access' 30,000 record limit. Does the same limit apply to Visual Basic as well?
>>>Visual Basic does not have a native data engine. Therefore, it uses either the Jet engine or an ODBC driver.
>>
>>and if you use the jet engine, you're just using access...
>
>Thanks Dave. I missed that point.
Thanks for the info. My company designed an application to track applicant information. When it first was proposed I said Access wouldn't be able to handle the workload. My prediction came true after a couple of months. Now they want to redesign it using Visual Basic. I believe they will use the jet engine again believing that Visual Basic is going to make a difference. Guess it's time to put my physic ability to work again.
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!