Yes there is a restriction. You probally overlooked it which many people around the Internet do. Its called Microshit (A.K.A. Microsoft) see they put restrictions on everything they can to be the "Better" source, so basically they want you to upgrade to MSQL. Which is not half bad. Access is actually terrible because it can substain very minimal record sets. Connections MUST be closed before a new one can be opened in almost all Acess databases around the world. There is however one way around this... Which is the best solution. Get MySQL! It is free and is very easy to set up and maintain. Just install and rip the knob off! Though if you MUST have everything still in Access (due to company policy) then you might want to do this... make a connection... show first 110 and then stop the connection and open another and have it start with 111 and go to 220 then close and then open and go from 221 to 330... and so on. That way Access wouldn't get all confused (which it does quite often) and everyone will be happy. But the best solution I can see (given I hate Microshit) is to go with MySQL or Oracle. MySQL is free and Oracle is another story. This will hopefully give you some idea of what do do and how to run a successful site. Thank you very much for your time and have a great day!
Chad R. Smith
www.brokenformula.com
