Here's the short overview. I am writting a rather complex accounting application which will consist of at least 20 or so different databases, (customers, products, employees, etc). Some of these 'files' will ultimalty be required to hold up to 100,000+ records. I am using VC++ to write the apps. At this point I am using MSAccess to design the databases. (I am not using access to create any forms or reports...just the databases and their field definitions).
The application will be run on networks of up to 10 or so clients off of a server. Now may question... Is Access capable of handling this? Is there a better choice? Can I design the databases in Access and latter 'xfer' the database definitions (tables etc.)from Acess to another database manager?
Any comments or options would be helpful at this point.
The application will be run on networks of up to 10 or so clients off of a server. Now may question... Is Access capable of handling this? Is there a better choice? Can I design the databases in Access and latter 'xfer' the database definitions (tables etc.)from Acess to another database manager?
Any comments or options would be helpful at this point.