Link to home
Start Free TrialLog in
Avatar of rowejd
rowejdFlag for United States of America

asked on

ACT versus Access

I can't seem to find a good source to really help me wrap my mind around ACT in relation to MS Access.  I work a lot with small businesses using databases.  I'm already very well versed in Access but lots of SB's seem to use ACT by default.

I'm particularly curious as to the advantages, differences, etc.  Especially in terms of the Web service.  One problem Access customers complain about (validly) is that Access is great in-house but if they have multiple buildings, it's awful without a terminal server running Windows.

So is this problem circumvented with ACT?  Is the web version scaled down and less customizable?  Do you have to have a Windows Server to build it?  And any other general info/comparisons you have would be great!
ASKER CERTIFIED SOLUTION
Avatar of Mike Lazarus
Mike Lazarus
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rowejd

ASKER

That's some good info, but could you give me a bit more?  I mean is it a relational database?  Is it fully customizable like Access?  Can you give me some examples of comparative features?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rowejd

ASKER

So in my original question when I said:

<<<I'm particularly curious as to the advantages, differences, etc.  Especially in terms of the Web service.  One problem Access customers complain about (validly) is that Access is great in-house but if they have multiple buildings, it's awful without a terminal server running Windows.>>>

I guess my main concern is that I've done some pretty useful stuff with some clients using Access.  For example, I've coded an Access database with a button to auto-copy information right over to their local copy of the Outlook calendar.  The Outlook calendar is connected to an online Microsoft Exchange Server.  So, it syncs the salesperson's cell phone, and this salesman's schedule is shared with all other users.

Pretty sweet stuff...but Access (as you mentioned) is limited in many ways.  You can't really easily share info except with a terminal server ($$$$$).  With ACT web services, I assume you COULD easily share the info across the web, but with most web versions of programs I've seen they're scaled down and not that great, which would be my concern.  But does the web version sync up with Outlook or an exchange server that way?  Is it THAT flexible?  And if it uses MS SQL Server, do you have to go in and start writing SQL code for some things?  Are there functions you can do with it like you can with Access such as send emails, click buttons to export files to pdf / rtf / csv / xls, etc?  This is the kind of thing I can't find any info on online.

Thanks for your help thusfar!
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rowejd

ASKER

What about outlook calendars?  Can either version add appointments to an Outlook calendar?  If so can both or just the local version? That's probably my biggest concern.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rowejd

ASKER

Thanks for your help.