How is Access front end?

  • Thread starter Thread starter Brett
  • Start date Start date
B

Brett

I'm not sure if Access is what I need. I want to develop a financial
application that does simple math. It will install for single person
use. There isn't any need for it to run over the Internet. I'm sure
the database side of Access will work fine. How do most of you like
the front side of Access? Is it powerful or limited? What is an
alternative?

Also, if I write the application in Office 2002, what happens for
people still running Office 2000?

Thanks,
Brett
 
For most applications, the Access front-end works great.
The reporting capabilites are strong, and if Office is
already installed, then there is no need for an
installation program. Just copy the Database and go.

Access 2002 (XP) uses the Access 2000 database format by
default. The only thing is you can't use any new features
(Printers collection, for example).

Alternatives would be Visual Basic, .Net, FoxPro, etc.


Chris
 
Chris,

I have a form developed in Excel and want to connect Access to it.
This will allow me to have a history and run graphs from it. In this
case, is there any reason to use the Access front end?

Thanks,
Brett
 
If it's already done in Excel, then I wouldn't switch.
Using ADO/DAO, you can pull the data very easily from a
Access back-end. I don't see a compelling reason to
switch.


Chris
 
Back
Top