I haven't looked at Access for a long time, but I'd say Bento is a closer match to MS Access. They were both designed more as personal database programs. While you can easily use Filemaker to create small personal database projects (I do all the time), it's really a much more robust, enterprise level tool.
__________________
Entropy isn't what it used to be
Yes, it's like Microsoft Access in that they are both database creation tools. FileMaker Pro is supposed to be easier to use than Access, I find them about the same (but I know MS and VBA inside out). FileMaker is cross platform and can publish to the web; Access is NOT cross platform, and (last version I used) could not publish to the web as FIleMaker can. On the Windows platform, if you are a developer, Access is more powerful.
__________________ Apple Certified Macintosh Technician (ACMT) / Support Professional (ACSP) MacBook Air (13-inch, Mid 2012) 8GB RAM, 256GB Flash Storage Mac mini (Late 2012) 16GB RAM, Fusion Drive (128GB SSD/750GB 7200RPM) iPad mini 16GB, iPhone 4S 16GB
I haven't looked at Access for a long time, but I'd say Bento is a closer match to MS Access. They were both designed more as personal database programs. While you can easily use Filemaker to create small personal database projects (I do all the time), it's really a much more robust, enterprise level tool.
I've seen Access used in many, MANY enterprise deployments successfully. I've heard FIleMaker Pro (not Server) allows 250 connections and Access allows 256, so I'd say they are on par.
__________________ Apple Certified Macintosh Technician (ACMT) / Support Professional (ACSP) MacBook Air (13-inch, Mid 2012) 8GB RAM, 256GB Flash Storage Mac mini (Late 2012) 16GB RAM, Fusion Drive (128GB SSD/750GB 7200RPM) iPad mini 16GB, iPhone 4S 16GB
Ya Access is used heavily in business. That is why it hasn't gone not matter Microsoft attempts at discontinuing it. I used to develop on it.
I used to develop for it too...
__________________ Apple Certified Macintosh Technician (ACMT) / Support Professional (ACSP) MacBook Air (13-inch, Mid 2012) 8GB RAM, 256GB Flash Storage Mac mini (Late 2012) 16GB RAM, Fusion Drive (128GB SSD/750GB 7200RPM) iPad mini 16GB, iPhone 4S 16GB
I've seen Access used in many, MANY enterprise deployments successfully. I've heard FIleMaker Pro (not Server) allows 250 connections and Access allows 256, so I'd say they are on par.
Sorry, my regular brain is in the shop. I was meaning FM Pro Server when I said that. To me, if it isn't in a server room, it ain't enterprise.
__________________
Entropy isn't what it used to be
Sorry, my regular brain is in the shop. I was meaning FM Pro Server when I said that. To me, if it isn't in a server room, it ain't enterprise.
Yup, Access is alive and well in many server rooms too... just look at what is done on an enterprise level with Access and Sharepoint. I know at least 2 major companies with tens of billions of assets who rely on MS Access at an enterprise level.
Of course, Access is scalable to MS SQL Server as well.
__________________ Apple Certified Macintosh Technician (ACMT) / Support Professional (ACSP) MacBook Air (13-inch, Mid 2012) 8GB RAM, 256GB Flash Storage Mac mini (Late 2012) 16GB RAM, Fusion Drive (128GB SSD/750GB 7200RPM) iPad mini 16GB, iPhone 4S 16GB
Location: Markham - Soon to be Mississauga, Ontario
Posts: 3,698
Quote:
Originally Posted by g-mo
yup, access is alive and well in many server rooms too... Just look at what is done on an enterprise level with access and sharepoint. I know at least 2 major companies with tens of billions of assets who rely on ms access at an enterprise level.
Of course, access is scalable to ms sql server as well.