Alternatives to Microsoft Access on the Mac. File Maker Pro. FileMaker is probably the best known database application for the Mac. If none of the above are suitable, you can always ressort to actually running Microsoft Access on your Mac using virtualisation software like Parallels Desktop. Runtime on Apple Mac. Discussion in 'Microsoft Access' started by Bob Vance, Feb 4, 2009.
Hi, Please forgive me if this is a stupid post. I'm quite new to Linux, wine etc. A quick bit of background. I have taken over as IT Manager at a company.
They have Access Front Ends that connect to SQL back ends for all their day to day applications. All users at remote site TS into a 2003 server and run the front end on that to avoid data corruption. Of course the system was never licensed, and management don't want to fork out $50k ish for cals, windows, SQL etc. So i'm experimenting with moving to open source. I have managed to install Centos 6.0, and got wine installed.
I have installed MS 2002 runtime (only gold rated Access version), installed ie7 to fix the trusted location issue and created my ODBC link. I can open my front end it loads the start-up form. It can pull the data from my SQL database and populate the list of users (its a login form). So everything seems good there. However a simple thing, my buttons don't seem to do anything. Login or Exit buttons look to click, ie. The press graphic works, but its like there is no code behind them.
There are no errors or anything. Before I try and install a full version of Access to start debugging, has anyone else tried this? Is there something I need to install to get the vba to work? Any ideas would be great. What's your Wine version?
Newer stable version (currently 1.4) should be better in general. Wine -version Can you provide the details about why and how you install native components like MS 2002 runtime or ie7? If you use winetricks.
Show winetricks verbs you used. You may also try CrossOver. It's based on Wine. It's payware. But if you cannot do something with CrossOver, you have little chance to make it with Wine. Unless you are a real ninja You also get support by purchasing CrossOver. If would be nice if you can report bugs to Wine community.
From my experience, you won't get fix even reply very soon. But you still helped the whole community a little bit Good luck for your open source journey milesy.