Folks,
A few years (5 years) ago, I developed a database for a job shop using Access 97. It managed jobs, generated purchase orders and delivery receipts, maintained inventory, tracked costs ... ect ....
The shop is now growing, and would like me to re-de the database. The shop doesn't have the money to upgrade to a new version of the office package right now (Running '97).
Does it make sense to develop another database using Access 2003 and wrap it with the Access runtime using Microsoft Office Access 2003 Developer Extensions?
Actually, this leads to another two questions...
The only two "Office" packages I use are Frontpage and Access (2002 and 2003 respectively), can I install and use Visual Studio Tools for the Microsoft Office System with only Access 2003 installed, or do I need the entire suite?
Next question is, I've had purchased for me a copy of Visual Studio .net 2003 (lucky guy eh?). Would it make more sense to develop a standalone solution using Visual Studio, or develop using Access 2003? (there will be 25 users accessing the database at any given time, no more than 12 in concurrent sessions)
tia,
A few years (5 years) ago, I developed a database for a job shop using Access 97. It managed jobs, generated purchase orders and delivery receipts, maintained inventory, tracked costs ... ect ....
The shop is now growing, and would like me to re-de the database. The shop doesn't have the money to upgrade to a new version of the office package right now (Running '97).
Does it make sense to develop another database using Access 2003 and wrap it with the Access runtime using Microsoft Office Access 2003 Developer Extensions?
Actually, this leads to another two questions...
The only two "Office" packages I use are Frontpage and Access (2002 and 2003 respectively), can I install and use Visual Studio Tools for the Microsoft Office System with only Access 2003 installed, or do I need the entire suite?
Next question is, I've had purchased for me a copy of Visual Studio .net 2003 (lucky guy eh?). Would it make more sense to develop a standalone solution using Visual Studio, or develop using Access 2003? (there will be 25 users accessing the database at any given time, no more than 12 in concurrent sessions)
tia,