Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Feb 20, 2010, 05:48 AM   #1
kksf9717
macrumors newbie
 
Join Date: Jan 2009
Location: London
Microsoft Access equivalent

Hi there,

I've been asked to maintain a database for a social association. Unfortunately, the person who designed the database is a windows user as is the rest of the association, hence the db being created in Microsoft Access. I would love to know if there is a Mac equivalent of Access which I would allow me to view, modify and update the db, which would also be accessible in windows too.

Much appreciated.
kksf9717 is offline   0 Reply With Quote
Old Feb 20, 2010, 05:58 AM   #2
roadbloc
macrumors 604
 
roadbloc's Avatar
 
Join Date: Aug 2009
Location: UK
Try OpenOffice. It's free.

http://www.openoffice.org/
__________________
roadbloc is online now   0 Reply With Quote
Old Feb 20, 2010, 06:59 AM   #3
sushi
Moderator emeritus
 
sushi's Avatar
 
Join Date: Jul 2002
Location: キャンプスワンピー [Japan]
Quote:
Originally Posted by kksf9717 View Post
I've been asked to maintain a database for a social association. Unfortunately, the person who designed the database is a windows user as is the rest of the association, hence the db being created in Microsoft Access. I would love to know if there is a Mac equivalent of Access which I would allow me to view, modify and update the db, which would also be accessible in windows too.
The problem with Databases is there is a front end and a back end if you will.

You can use Excel to maintain data if you wanted to, although not recommended.

The issue is the front end. Queries, Reports, Data Entry forms, and the like usually do not transfer over to a new DBMS (Database Management System) of which Access is one.

If the association has an extensive front end with their database, it might just be easier (although not cheap) to purchase VMware Fusion, install Windows, and install Office.
__________________
You only live twice, once when you are born, and when you look death in the face. *Basho style poem from 007 YOLT.
sushi is offline   0 Reply With Quote
Old Feb 20, 2010, 07:24 AM   #4
Eraserhead
macrumors G4
 
Eraserhead's Avatar
 
Join Date: Nov 2005
Location: UK
If you don't have an extensive front end you could try Filemaker.
__________________
Actually it does make sense. Man created god, so if we exist, He exists. - obeygiant
Eraserhead is offline   0 Reply With Quote
Old Feb 20, 2010, 07:30 AM   #5
kksf9717
Thread Starter
macrumors newbie
 
Join Date: Jan 2009
Location: London
Quote:
Originally Posted by roadbloc View Post
Try OpenOffice. It's free.

http://www.openoffice.org/
The problem with that is I just want Access and not the whole suite. I already have the student version of Microsoft Office for Mac.

But I'll look into FileMaker.
kksf9717 is offline   0 Reply With Quote
Old Feb 20, 2010, 07:44 AM   #6
sushi
Moderator emeritus
 
sushi's Avatar
 
Join Date: Jul 2002
Location: キャンプスワンピー [Japan]
Quote:
Originally Posted by Eraserhead View Post
If you don't have an extensive front end you could try Filemaker.
Agree with this.

FileMaker is very good and easy to use.
__________________
You only live twice, once when you are born, and when you look death in the face. *Basho style poem from 007 YOLT.
sushi is offline   0 Reply With Quote
Old Feb 20, 2010, 10:32 AM   #7
wartime
macrumors newbie
 
Join Date: Mar 2005
Location: Bournemouth UK
Send a message via AIM to wartime
Ms Access

I have the same requirement. I've been running a company for 15 years and my co-Director uses a Dell PC with Access for her Membership records, and there's a lot. I decided to go down the route of Bootcamp having tried Fusion which I thought was more trouble than it was worth. Yes, Windows runs fine on the MacBook Pro but as my main apps are photoshop and Quark, I can't boot out and into windows as it takes time. So I'd like an Access equiv on the Mac. As far as I know Filemaker doesn't import Access files easily and I'd need to update my files from the Dell almost daily. My answer was to buy a Dell Mini 10v which in part solves the problem but I've ofter wondered why MS never manufactured an Access version for the Mac?
wartime is offline   0 Reply With Quote
Old Feb 20, 2010, 11:15 AM   #8
kksf9717
Thread Starter
macrumors newbie
 
Join Date: Jan 2009
Location: London
Quote:
Originally Posted by wartime View Post
My answer was to buy a Dell Mini 10v which in part solves the problem but I've ofter wondered why MS never manufactured an Access version for the Mac?
Considering I'm a PhD student and volunteering as secretary for this association, plus I wouldn't be compensated/reimbursed for any purchases, I was hoping to go for a cheaper option.

I think Microsoft are bitter, twisted people who know how useful Access is and pretty much keep that away from us.
kksf9717 is offline   0 Reply With Quote
Old Feb 21, 2010, 07:52 AM   #9
sushi
Moderator emeritus
 
sushi's Avatar
 
Join Date: Jul 2002
Location: キャンプスワンピー [Japan]
Quote:
Originally Posted by wartime View Post
I decided to go down the route of Bootcamp having tried Fusion which I thought was more trouble than it was worth.
Curious what issues you had with VMware Fusion.

Would you care to elaborate? TIA.
__________________
You only live twice, once when you are born, and when you look death in the face. *Basho style poem from 007 YOLT.
sushi is offline   0 Reply With Quote
Old Feb 21, 2010, 08:15 AM   #10
Angelo95210
macrumors 6502a
 
Angelo95210's Avatar
 
Join Date: Jan 2009
Location: Paris, France
I know Access very well and I think it is (was?) a very good DB. So I would stick to MS Access, unless you are not afraid to face compatibility issues when switching to Filemaker or 4D.
__________________
Hackintosh G31M-S2L - Macbook 3,1
Angelo95210 is offline   0 Reply With Quote
Old Feb 26, 2010, 01:17 AM   #11
leebrendalee
macrumors newbie
 
Join Date: Feb 2010
besides ms access

I was thinking of using access as well but yes I am on a fabulous imac. Not sure why anyone would use a pc once they got there hands on a mac, however --another time.........

Here is what I need would LOVE the input. I think access or openoffice is way to complicated for me.

All I want to do is enter data somewhere and than be able to search for that data.

Example: I enter stuff, than want to search say for a word like: MLH or TNR or pending_delete

whatever, stuff like that, so I type it and it brings up what that word means....or sentence means..kinda like a dictionary.

however

I need to be able to use it at work. I tried tikiwiki or something like that but that's external and would be accessing an outside website, not sure our IT department would like that very much.
Does anyone know of any solutions for me please?
leebrendalee is offline   0 Reply With Quote
Old Feb 26, 2010, 02:27 AM   #12
Michael CM1
macrumors 603
 
Join Date: Feb 2008
Quote:
Originally Posted by Eraserhead View Post
If you don't have an extensive front end you could try Filemaker.
That's what my college band program used to maintain hundreds of geeks, uniforms, instruments, etc. I never used it myself, but we managed to not lose too many people or uniforms. Well, there was that one time with the rogue clarinet, but I won't go there.
__________________
13.3" 2014 MacBook Air; Mid-2010 21.5" iMac; silver 64GB iPhone 6; white iPad Air 32 GB; third-gen TV (x2)
Michael CM1 is offline   0 Reply With Quote
Old Feb 26, 2010, 05:01 AM   #13
Winni
macrumors 68030
 
Winni's Avatar
 
Join Date: Oct 2008
Location: Germany.
Quote:
Originally Posted by leebrendalee View Post
I was thinking of using access as well but yes I am on a fabulous imac. Not sure why anyone would use a pc once they got there hands on a mac, however --another time.........
Ahem, maybe because the PC can run all that software that your fabulous Mac with OS X cannot run?

Macs sell so well these days not because they run their own proprietary, closed-down Mac OS X, but because they can run Windows (and even Linux) so well.

To the original poster:

Your only acceptable option is to run Microsoft Access in Windows in VMWare Fusion. Access is not compatible with anything but Microsoft Access - there are no fully compatible substitutes for it, not even in the Windows world. I won't go into the technical 'merits' of Microsoft Access, but let's just say that I had to support an Access-based application on a former job and that is was the worst nightmare that I've ever experienced in my long IT career. If you can use a real database system instead of Access then do it.
__________________
Coming soon: http://endnacht.de.
Winni is offline   0 Reply With Quote
Old Mar 1, 2010, 06:56 AM   #14
Charmywoo
macrumors newbie
 
Join Date: Jun 2009
hi there, i have the same issue. I have two macs running and one windows 7 laptop and to get cross compatibility, i've put parallels on both of the macs and installed windows and then office on each to use access. Parallels is an amazing piece of software and really easy to use. None of this booting in and booting out tosh, it's a dual operating system, so you can do both windows and mac stuff at the same time and of course, able to treat the pc as if it is an actual pc... if you see what i mean anyway, it's really worth it i simply couldn't run my business without it.

IMac 27", IMAC 24", Macbook 13", Iphone 1g (yeah baby, unlocked to orange payg, with a cracked screen and still goin' strong! LOVE IT!)
_________________________________________________________________
Check out my website for cheap mobility equipment: www.wheeliegoodmobility.co.uk - thank you.
Proudly supported by The Prince's Trust and Age Concern, Kent
Charmywoo is offline   0 Reply With Quote
Old Mar 1, 2010, 09:11 PM   #15
bmcgonag
macrumors 65816
 
bmcgonag's Avatar
 
Join Date: Mar 2007
Location: Texas
Send a message via Skype™ to bmcgonag
I guess my question to the OP would be, is this database something that ll of th emember have to access, or just you. Is it just information?

If you are really the only accessing it, switch to something mac friendly, Filemaker, MySQL with PHP, or something similar. You can export the data to Excel from Access, then import it to your preferred program. Clean up is always necessary, but not too difficult with a simple database system. If it is a huge complex database, that accomodates many users, then your only real option will be to use windows in one way or another.

I love my macs, but I have to admit that Access is a brilliantly easy to use and fairly robust database system.

I've tried Filemaker, didn't like it...but that's just me.

Best of luck,

Brian
__________________
OS X Tech Tips
24" White iMac Core 2 duo, 3 GB Ram, 1 TB, Orig & 2nd Gen AppleTV, iPhone 3GS, iPad Gen 1 - 16 Gig WiFi
Innovative CR
bmcgonag is offline   0 Reply With Quote
Old Mar 1, 2010, 09:41 PM   #16
*LTD*
Banned
 
Join Date: Feb 2009
Location: Canada
FileMaker or Bento.
*LTD* is offline   0 Reply With Quote
Old Mar 2, 2010, 01:32 AM   #17
Buzz Bumble
Guest
 
Join Date: Oct 2008
Location: New Zealand
A note for the original person, FileMaker Pro is not Access. FileMaker Pro is a completely separate database system with its own structure, etc. You would have to re-create the database structure in FileMaker and then import the data from the Access database. The one advantage is that FileMaker Pro is available for both Mac OS and Windows, so the same database files can be used on both systems.



Quote:
Originally Posted by kksf9717
I think Microsoft are bitter, twisted people who know how useful Access is and pretty much keep that away from us.
Nope. Microsoft simply knows they can't compete with a real database system: FileMaker Pro.


Quote:
Originally Posted by bmcgonag
I love my macs, but I have to admit that Access is a brilliantly easy to use and fairly robust database system.

I've tried Filemaker, didn't like it...but that's just me.
It's definitely just you!

Most people are completely the other way around - Access is an over-complicated, over-bloated dog, while FileMaker Pro is quick and easy.
Buzz Bumble is offline   0 Reply With Quote
Old Mar 2, 2010, 06:52 AM   #18
mysterytramp
macrumors 65816
 
mysterytramp's Avatar
 
Join Date: Jul 2008
Location: Maryland
Quote:
Originally Posted by roadbloc View Post
Try OpenOffice. It's free.

http://www.openoffice.org/
Has anyone actually used the database portion of OpenOffice/NeoOffice productively? I tried a year or so ago and found the software extremely lacking.

mt
__________________
What looks large from a distance, close up ain't never that big.
mysterytramp is offline   0 Reply With Quote
Old Mar 2, 2010, 07:37 AM   #19
Charmywoo
macrumors newbie
 
Join Date: Jun 2009
Access vs. Filemaker

hi there, as posted before, i had an awful experience with filemaker and frankly it's far easier getting hold of a copy of Parallels and installing xp and office with access. You can still work simultaneously with apple and you'll be able to open your file with no agg.i run my business like this! it's great and i have no worries at all.
If you're stuck feel free to drop me an email at charmaine a kemp at gmail dot com (all one word, no spaces, including usual punctuation.)
good luck, regards, charmaine
Charmywoo is offline   0 Reply With Quote
Old Mar 2, 2010, 08:10 AM   #20
bilboa
macrumors regular
 
Join Date: Jan 2008
Quote:
Originally Posted by leebrendalee View Post
I was thinking of using access as well but yes I am on a fabulous imac. Not sure why anyone would use a pc once they got there hands on a mac, however --another time.........

Here is what I need would LOVE the input. I think access or openoffice is way to complicated for me.

All I want to do is enter data somewhere and than be able to search for that data.

Example: I enter stuff, than want to search say for a word like: MLH or TNR or pending_delete

whatever, stuff like that, so I type it and it brings up what that word means....or sentence means..kinda like a dictionary.

however

I need to be able to use it at work. I tried tikiwiki or something like that but that's external and would be accessing an outside website, not sure our IT department would like that very much.
Does anyone know of any solutions for me please?
Sounds like Bento might be appropriate for your needs.
http://www.filemaker.com/products/bento
bilboa is offline   0 Reply With Quote
Old Aug 1, 2010, 11:08 AM   #21
wareclarke
macrumors newbie
 
Join Date: Aug 2010
Parallels Desktop

You can install the program 'Parallels Desktop' on a Mac and it allows Windows programs to run. My husband and I run a business requiring Windows compatibility, but both prefer the Mac world. Parallels Desktop has made it possible to 'have our cake and eat it too'! We also us two monitors.... one for the Mac side and one for the Windows side.
wareclarke is offline   0 Reply With Quote
Old Aug 1, 2010, 11:21 AM   #22
exegete77
macrumors 6502a
 
Join Date: Feb 2008
Another option (with both Mac and Windows versions) is Panorama.
__________________
iMac 21.5 MBP 13" retina (since 1990)
old, slow, and confused
but at least I'm inconsistent!
The missing missing and challenges of a loved one missing
exegete77 is online now   0 Reply With Quote
Old Aug 1, 2010, 11:33 AM   #23
coachingguy
macrumors 6502
 
Join Date: Feb 2003
Location: The Great White, Albeit Frozen North
BENTO. It's cheap and ridiculously easy to use. It's the database "For the Rest of Us" From the sounds of it, it's exactly what your looking for.

Coachingguy
__________________
iPhone 5 "Vader", i5 MBP 15", MBA 11' i5, iPad, iPad 2, MBP 2.5, , 32 gig Wifi iPad & iPad 2, Canon 50D
The future is determined by the decisions made today.
coachingguy is offline   0 Reply With Quote
Old Aug 1, 2010, 09:34 PM   #24
iMAVERICKam
macrumors member
 
Join Date: Apr 2009
Location: Texas
Bento is not the answer if/when you need to turn the data over to someone else in the organization who only has a Windows PC.

FileMaker (Mac & Windows), QuickBase (web), or Caspio (web) are the best paid-for alternatives that allow everybody - regardless of platform - access & modify data.

Unfortunately, the simplest free alternative is OpenOffice Base. The best (and most complicated) free solution for anyone to be able to access & modify information in the database would be to export from Access, import to MySQL or PostgreSQL, and build a web app from scratch. If the organization has a server they'd host this on you could probably get this done in a few days with the help of a good scaffolding framework.
iMAVERICKam is offline   0 Reply With Quote
Old Dec 21, 2013, 09:02 AM   #25
osage1a
macrumors newbie
 
Join Date: Dec 2013
Exactly what I needed to know...

Quote:
Originally Posted by Charmywoo View Post
hi there, i have the same issue. I have two macs running and one windows 7 laptop and to get cross compatibility, i've put parallels on both of the macs and installed windows and then office on each to use access. Parallels is an amazing piece of software and really easy to use. None of this booting in and booting out tosh, it's a dual operating system, so you can do both windows and mac stuff at the same time and of course, able to treat the pc as if it is an actual pc... if you see what i mean anyway, it's really worth it i simply couldn't run my business without it.

IMac 27", IMAC 24", Macbook 13", Iphone 1g (yeah baby, unlocked to orange payg, with a cracked screen and still goin' strong! LOVE IT!)
_________________________________________________________________
Check out my website for cheap mobility equipment: www.wheeliegoodmobility.co.uk - thank you.
Proudly supported by The Prince's Trust and Age Concern, Kent
This is just what I have been searching for. Thank you, thank you.
osage1a is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Need Microsoft Access for school...best & cost efficient way? bluedukies8 Windows, Linux & Others on the Mac 8 Jan 10, 2014 10:19 PM
MS Access equivalent on Mac NovemberPapa Mac Applications and Mac App Store 5 Jan 3, 2014 12:11 PM
Microsoft Access - Not for Mac? Tissue Paper MacBook 7 Dec 21, 2013 08:12 AM
Is there an equivalent to the Griffin Survivor Slim case, but has fingerprint access? Shmible iPhone Accessories 2 Dec 17, 2013 06:58 PM
Mac equivalent of Microsoft Paint? (That ISN'T Seashore) CFoss Mac Applications and Mac App Store 3 Aug 9, 2012 03:11 PM

Forum Jump

All times are GMT -5. The time now is 06:14 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC