or Connect
AppleInsider › Forums › Software › Mac Software › Filemaker Pro versus MS Access
New Posts  All Forums:Forum Nav:

Filemaker Pro versus MS Access

post #1 of 27
Thread Starter 
Does anyone know if Filemaker Pro files can be imported to MS Access?
And I'd also like to hear comparisons of the two databases...

[ 03-02-2003: Message edited by: O-Mac ]</p>
post #2 of 27
Not even the PC loving computing dept. in our school have a good word to say about Access <img src="graemlins/lol.gif" border="0" alt="[Laughing]" />
My computer worked yesterday,
Today it isn't working.
Windows is like that.
Reply
My computer worked yesterday,
Today it isn't working.
Windows is like that.
Reply
post #3 of 27
well, can you even run Access databases on a mac? Things that aren't cross platform kill me....

I can sync FileMaker Pro databases with my plam, so I'm a big FMPro fan...
post #4 of 27
No Access is PC only.

Non cross platform DB makes no sense really. If I had my druthers I'd be going FMPRO.
He's a mod so he has a few extra vBulletin privileges. That doesn't mean he should stop posting or should start acting like Digital Jesus.
- SolipsismX
Reply
He's a mod so he has a few extra vBulletin privileges. That doesn't mean he should stop posting or should start acting like Digital Jesus.
- SolipsismX
Reply
post #5 of 27
To answer the question: no. You might be able to import the data from an Access DB, but not the scripts/structure/layout. You'd be better off making a new FM DB, exporting the Access data to Tab-Delimited Text, and importing it to FM.
post #6 of 27
My dad is a FileMaker developer and has been for years. I don't know a whole lot about them but he does tell me that FileMaker is basically the exact same on the Mac and on Windows. He also says that FileMaker is easy enough to use that a clever individual can make databases on their own. The problem is, they often do, so when he is hired by a company he often has to either scrap or overhaul their old database because it's a thrown-together mess. The other problem is that FileMaker doesn't allow for multi-user applications... there are limitations built into it to prevent you from making a killer database, binding it, and selling it. You can do that but only if it's going to be used on just one computer. Not sure exactly how that works, he just told me that one day.
post #7 of 27
All depends on what you need. You can get to Access databases via ODBC.

[quote]Originally posted by M3D Jack:
<strong>well, can you even run Access databases on a mac? Things that aren't cross platform kill me....

I can sync FileMaker Pro databases with my plam, so I'm a big FMPro fan...</strong><hr></blockquote>
post #8 of 27
It appears that your school's PC department is useless. Access is way better than FileMaker Pro. I am not trolling. I am just stating a simple fact.

[quote]Originally posted by jimdad:
<strong>Not even the PC loving computing dept. in our school have a good word to say about Access <img src="graemlins/lol.gif" border="0" alt="[Laughing]" /> </strong><hr></blockquote>
post #9 of 27
Thread Starter 
I think Apple would definately thrive in the databse business if they could find a way to easily cross-platform MS Access to the Mac.

With MAC OS X's stability don't you think a great database software would kick butt?
post #10 of 27
FMP is a subsidiary of Apple (or whatever you call it)
125/51041 (top .2449%)-Amie Street - awesome independent DRM-free music
People really have got to stop thinking there is only one operating system, one economic system, one religion, and one...
Reply
125/51041 (top .2449%)-Amie Street - awesome independent DRM-free music
People really have got to stop thinking there is only one operating system, one economic system, one religion, and one...
Reply
post #11 of 27
[quote]Originally posted by Dave K.:
<strong>It appears that your school's PC department is useless. Access is way better than FileMaker Pro. I am not trolling. I am just stating a simple fact.

</strong><hr></blockquote>

Well it's more powerful, but compared to the real big DB systems, it's just awful.
post #12 of 27
FileMaker Pro is made by FileMaker Inc, which used to be called Claris until Apple got all of Claris's stuff other than FileMaker. Actually I'm not sure exactly how it happened, but it used to be Claris FileMaker Pro and now it's just FileMaker Pro.
post #13 of 27
Access is more powerful than FM Pro, but I'd say that FM Pro is more useful simply because it's easier to set up and build applications with.

In the grand scheme of things, they're both toys, but we've had terrible problems with Access databases in particular (in other people's products) losing and corrupting data. We've also had some serious performance issues with Access. So we neither use it ourselves nor recommend it for anything. If the database can't even store data reliably, what's the point?

Nevertheless, and alas, there's a huge stable of applications built on Access, and some of them are even sold for money.
"...within intervention's distance of the embassy." - CvB

Original music:
The Mayflies - Black earth Americana. Now on iTMS!
Becca Sutlive - Iowa Fried Rock 'n Roll - now on iTMS!
Reply
"...within intervention's distance of the embassy." - CvB

Original music:
The Mayflies - Black earth Americana. Now on iTMS!
Becca Sutlive - Iowa Fried Rock 'n Roll - now on iTMS!
Reply
post #14 of 27
[quote]Originally posted by Dave K.:
<strong>It appears that your school's PC department is useless. Access is way better than FileMaker Pro. I am not trolling. I am just stating a simple fact.

</strong><hr></blockquote>

No, trolling or not, that's an opinion, not a fact. And I'm not sure what you are basing you opinion on -- why do you think it is better?

I've just finished moving yet another database from that Access to FileMaker Pro. I can't see why anyone in there right mind would use Access with elegant solutions such as FileMaker Pro and the fast and powerful open source SQL variants available.

The only reason that it ever became popular was its inclusion with MS office.
The only thing necessary for the triumph of evil is for good men to do nothing
Reply
The only thing necessary for the triumph of evil is for good men to do nothing
Reply
post #15 of 27
Thread Starter 
I'd like to know what the BEST database software product is out there...mainstream that is..
post #16 of 27
There is no one database program that is perfect for every situation.

I use FileMaker Pro for most projects because it is cross platform (it even has a mobile version for PDAs). It is also easy to set up and more then powerful enough for most jobs.

For web databases I use PosgreSQL or MySQL. That is one of the many reasons I love OSX -- I have an apache web server complete with a MySQL database running all the time on my powerbook to test out my scripts and websites. Talk about a time saver.

The only time I use Access anymore is when I'm trying to port it to something else. Which can be done using ODBC, but it still a lot of work.

If you trying to figure out which database program is best for a particular project we can probably help you if you give us a description of it.
The only thing necessary for the triumph of evil is for good men to do nothing
Reply
The only thing necessary for the triumph of evil is for good men to do nothing
Reply
post #17 of 27
Thread Starter 
Coming from a PC background I thought everything used a MS Access databases in some way or form...A lot of applications I see have Access as their main database in the background. I actually never really knew what Filemaker was until a little while ago.

But now after looking at Filmaker's website it looks like lots of places don't use Access. I mean, there are a zillion books in hte bookstore on Access and only a few for Filemaker...
post #18 of 27
Res&gt;

A relative of yours?

"I've learned there's more to life than being really, really, really, really, really, really, ridiculously good-looking. :-x" - Zoolander
~:My scraps:~
Reply
"I've learned there's more to life than being really, really, really, really, really, really, ridiculously good-looking. :-x" - Zoolander
~:My scraps:~
Reply
post #19 of 27
[quote]Originally posted by Dave K.:
<strong>It appears that your school's PC department is useless. Access is way better than FileMaker Pro. I am not trolling. I am just stating a simple fact.

</strong><hr></blockquote>


No, you're stating a simple opinion.

My opinion is that Access is crap. I have formed my opinion based on having been using it for the past academic year in my computer science coursework.

Amorya
post #20 of 27
[quote]Originally posted by Dave K.:
<strong>It appears that your school's PC department is useless. Access is way better than FileMaker Pro. I am not trolling. I am just stating a simple fact.

</strong><hr></blockquote>

That'll be why its not even part of Office for the Mac? <img src="graemlins/oyvey.gif" border="0" alt="[oyvey]" />
My computer worked yesterday,
Today it isn't working.
Windows is like that.
Reply
My computer worked yesterday,
Today it isn't working.
Windows is like that.
Reply
post #21 of 27
Thread Starter 
Wow...I may have to start deprogramming myself form thinking MS Access is any good...I have the Filemaker Pro demo and I'm going to try it out...

If there are people out there who have horror stories about Access I'd like to hear them...
post #22 of 27
My own recent experience of Access isn't that good. The Windows software we develop at work normally uses a Sybase or Oracle database, but in order to distribute evaluation systems without having to worry about licencing issues, I recently had to convert a system over to use Access, in addition to Sybase. The main problem was that differences seemed to exist even in the Access version by itself, depending on whether the Access database was accessed via the JetEngine or ODBC. In fact, I found I had to use the JetEngine in order to specify any referential integrity constraints at all. Access also seems to implement security features in a slightly non standard way, by means of a workgroup information file, that can be a pain to maintain if the database needs to be password protected. Anyway, to cut a long story short, I found Access to be quite noddy compared to Sybase or Oracle, although it does have its uses. For example, it's handy that Access itself doesn't actually have to be present on the machine, so an Access database and Windows application can be distributed to potential clients, and should work so long as the relevant version of the JetEngine has been installed with Windows. For live systems though, we'll be sticking with Sybase.

[ 03-03-2003: Message edited by: RodUK ]</p>
post #23 of 27
Want multiple users to connect to a database at the same time? Get FileMaker Pro. My company depends on this.

Do you have PCs and Macs that need to access a database? Get FileMaker Pro.

Which is cheaper? FileMaker Pro.

What has a WAY better front end? FileMaker Pro.

Wanna publish a database as a web page? Get FileMaker Pro.

I even merge data in Word and Excel 2001 (Mac) with FileMaker Pro. Sweet. And I don't export to text first. One stop shopping...

Guess what the #1 selling database app for the PC is? Access. Duh. But seriously, the biggest selling (non-MS) database for the PC is FileMaker Pro! You gotta remember that MS bundles Access with other MS products sometimes.

[ 03-03-2003: Message edited by: dstranathan ]</p>
A friend will help you move, but a REAL FRIEND will help you move a body.
Reply
A friend will help you move, but a REAL FRIEND will help you move a body.
Reply
post #24 of 27
isn't Filemaker supposed to be an Apple product??? <img src="graemlins/lol.gif" border="0" alt="[Laughing]" /> <a href="http://photos.yahoo.com/bc/doxxdesign/vwp?.dir=/odd&.src=ph&.dnm=filemaker.jpg&.view=t&.done=http% 3a//photos.yahoo.com/bc/doxxdesign/lst%3f%26.dir=/odd%26.src=ph%26.view=t" target="_blank">filemaker store</a>

[ 03-03-2003: Message edited by: doxx ]</p>
never touch a running system
Reply
never touch a running system
Reply
post #25 of 27
Thread Starter 
Apple is associated with Filemaker Pro but the company also makes a Windows version of it's product.
post #26 of 27
Filemaker is a great system to develop for small buisness. It's flexible, fast, not too hard to learn, and can run multi-user applications easily.

Now, if you want to sell your systems, that's another ballgame. FM Developer will let you compile your system into a working application, but it's single-user only. If you want a multi-user app, you're better off leaving it in raw database format and putting it onto a server.

I've coded a full scheduling/maintenance database for a college Motorpool department in FMP. Took quite a while (as I was learning FMP at the same time, and also doing tech support work at the school), but in the end we had a decent little application that could be accessed by the entire MP department as necessary.

With a little work, we could've tied it into the web server, but there's no need for outside access in this case.
post #27 of 27
I think Access is great. I've used it for 5 years and still haven't hit a wall on features. No corruption issues, ever, and some of my applications top out at 85MB. FMPro is cool too (used it for 7+ years), but when I use it I long for Access' more robust feature set.

If you want a cross platform solution, I'd go for Access and VPC. I've never used this setup, but that's what I would try first.
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Mac Software
AppleInsider › Forums › Software › Mac Software › Filemaker Pro versus MS Access