Discussion Locked

Other option to ACCESS

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I currently use Access 2000 for my database at work, but it has proven to be slow. I was told to use SQL Server to bring in reports and create queries etc. But I would also like to know if there is another option for creating Reports and Forms as in Access. Is there some kind of SQL Report or Form Writer that is the equivalent to Access, but is much faster? Thank you in advance.

6 replies

by dpskiman

If Access is your database engine, take a serious look at Crystal Reports. I developed an app a few years ago using it, and it worked great. DB was on a server, front-end forms on corporate intranet, users fed new/updated information throughout the day, at 2am, set off some automated batches and we reposted reporting by 3am (covering all activity up through the previous day). Learning it was not too difficult, I figured it out with just a few hours of trial and error.

Crystal Reports, definitely.

by rob.mcewan

If the database is access, then performance is going to be limited reguardless of the reporting tool used. If the database is SQL Server or Oracle, then take a look at Hyperion SQR.

by bschaettle

SQL Server is a relational database "engine" -- it stores, manages and retrieves data, but it doesn't come bundled with tools for creating an end-user interface like MS Access. You'll need to develop the interface with a separate tool like Crystal Reports or 0MS Visual Studio.

Another possibility is to export the existing MS Access tables to SQL Server and link your MS Access database to them.

This discussion is closed to new replies.