SOLVED

I want to use access but I have a Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-2337271%22%20slang%3D%22en-US%22%3EI%20want%20to%20use%20access%20but%20I%20have%20a%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2337271%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20was%20wondering%20if%20there%20is%20Access%20for%20Mac%20or%20if%20there%20is%20an%20online%20app%20where%20I%20can%20use%20it.%20Also%2C%20is%20it%20possible%20to%20save%20data%20in%20the%20cloud%20and%20have%20access%20to%20it%20from%20another%20computer.%20For%20example%2C%20I%20want%20to%20view%20the%20data%20that%20I%20entered%20at%20work%20on%20my%20PC%20in%20my%20laptop%20at%20home.%20Does%20this%20make%20sense%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2337271%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%20Web%20App%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%20Web%20Database%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2337403%22%20slang%3D%22en-US%22%3ERe%3A%20I%20want%20to%20use%20access%20but%20I%20have%20a%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2337403%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1048342%22%20target%3D%22_blank%22%3E%40CLCV1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20no%20version%20of%20Mac%20that%20can%20run%20on%20a%20Mac.%20There%20is%20no%20online%20version%20of%20Access.%20You%20can%20not%20put%20Access%20%22in%20the%20cloud%22%20and%20share%20the%20data%20directly%20that%20way.%3C%2FP%3E%3CP%3EYou%20CAN%2C%20however%2C%20use%20a%20Windows%20Emulator%20application%2C%20like%20Parallels%2C%20and%20run%20Access%20in%20that%20Windows%20emulator.%20IIRC%2C%20there%20are%20other%20emulator%20applications%2C%20but%20Parallels%20is%20the%20most%20widely%20known.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20address%20the%20other%20part%20of%20your%20question%20requires%20a%20lot%20more%20background.%3C%2FP%3E%3CP%3EAll%20relational%20database%20applications%2C%20including%20those%20created%20with%20the%20MS%20Access%20application%2C%20consist%20of%20three%20components.%3C%2FP%3E%3COL%3E%3CLI%3EThe%20Data%20tier%2C%20or%20layer.%20All%20data%20in%20a%20relational%20database%20application%20is%20stored%20in%20tables.%20There%20is%20a%20Database%20Engine%20which%20manages%20those%20tables.%20In%20Access%2C%20the%20database%20engine%20is%20called%20ACE.%20Other%20widely%20known%20and%20used%20relational%20database%20engines%20include%20SQL%20Server%20and%20Oracle.%20More%20on%20this%20below.%3C%2FLI%3E%3CLI%3EThe%20Interface%20tier%20or%20layer.%20All%20relational%20database%20applications%20require%20objects%20for%20an%20interface%20through%20which%20users--like%20yourself--can%20interact%20with%20the%20data%20in%20the%20tables.%20In%20a%20website%2C%20this%20is%20the%20web%20pages.%20In%20an%20Access%20relational%20database%20application%2C%20this%20is%20the%20forms%20and%20reports.%20Forms%20are%20bound%20to%20tables%20and%20allow%20users%20to%20call%20up%20data%20for%20viewing%20or%20modification%2C%20or%20to%20add%20new%20data%20to%20the%20tables.%20Reports%20are%2C%20as%20the%20name%20suggests%2C%20objects%20which%20retrieve%20data%20from%20the%20tables%20for%20summary%20presentation%20to%20the%20user.%3C%2FLI%3E%3CLI%3EThe%20Logic%20tier%20or%20layer.%20The%20coding%20language%20used%20in%20Access%20is%20VBA%20(and%20for%20minor%20tasks%2C%20macros).%20You%20use%20VBA%20to%20create%20logic%20that%20opens%20and%20closes%20forms%2C%20for%20example%2C%20and%20which%20calculates%20and%20manages%20data%20and%20other%20tasks.%3C%2FLI%3E%3C%2FOL%3E%3CP%3ESo%2C%20with%20that%20background%2C%20you%20can%20use%20the%20Interface%20and%20Logic%20components%20of%20Access%20with%20its%20own%20internal%20ACE%20tables.%20However%2C%20Access%20also%20supports%20connections%20to%20a%20very%20wide%20variety%20of%20other%20database%20engines%2C%20including%20SQL%20Server%2C%20Oracle%2C%20MySQL%20and%20others.%3C%2FP%3E%3CP%3ESo%2C%20to%20address%20your%20question%20about%20accessing%20your%20data%20from%20work%20and%20from%20home%2C%20the%20answer%20is%20yes%2C%20you%20can%20do%20that%2C%20but%20NOT%20with%20Access%20local%20tables.%20You'll%20have%20to%20set%20up%20a%20database%20that%20you%20CAN%20connect%20to%20from%20both%20locations%2C%20and%20that%20is%20probably%20going%20to%20be%20one%20of%20two%20or%20three%20options.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20obtain%20a%20SharePoint%2C%20or%20Office%20365%2C%20account%20and%20use%20SharePoint%20lists%20in%20that%20O365%20site%20as%20the%20tables%20for%20your%20relational%20database%20application.%20That%20allows%20the%20Access%20interface%20(forms%20and%20reports%20and%20code%20in%20an%20accdb)%20to%20connect%20to%20the%20SP%20lists%20from%20any%20location%20where%20you%20have%20an%20internet%20connection.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20option%20is%20a%20remotely%20hosted%20SQL%20Server%20from%20a%20hosting%20site.%20I%20personally%20use%20Winhost.com%2C%20for%20example.%20For%20about%20%246%2Fmonth%20I%20have%20a%20hosted%20SQL%20Server%20along%20with%20the%20ability%20to%20create%20and%20host%20a%20small%20website.%20For%20your%20purposes%20the%20SQL%20Server%20database%20is%20the%20pertinent%20offering.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20still%20another%20option%20is%20SQL%20Azure%2C%20which%20is%20a%20Microsoft%20offering.%20It%20is%2C%20essentially%2C%20a%20hosted%20SQL%20Server%2C%20but%20being%20part%20of%20Microsoft%20Azure%2C%20a%20great%20deal%20of%20other%20products%20and%20tools%20are%20available.%20You%20can%20obtain%20a%20minimal%20Azure%20account%20for%20a%20competitive%20cost.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOf%20the%20three%2C%20I%20can't%20suggest%20which%20is%20most%20appropriate%20for%20your%20needs%2C%20except%20to%20note%20that%20SharePoint%20would%20probably%20require%20the%20least%20new%20learning%20to%20work%20with%20effectively.%20It%20is%20better%20suited%20for%20smaller%20applications%2C%20so%20that%20becomes%20a%20factor%20in%20deciding%20if%20it%20is%20a%20good%20fit.%20If%20you%20plan%20on%20handling%20a%20few%20thousand%20records%2C%20or%20maybe%20up%20to%2050%2C000%20or%2060%2C000%20records%2C%20SharePoint%20could%20be%20a%20good%20fit.%20If%20you%20are%20going%20to%20handle%20500%2C000%20or%20a%20million%20records%2C%20you'll%20need%20SQL%20Server%20or%20SQL%20Azure.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20probably%20a%20number%20of%20additional%20considerations.%20So%20post%20back%20with%20additional%20questions.%20Look%20for%20additional%20posts%20from%20experts.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello, I was wondering if there is Access for Mac or if there is an online app where I can use it. Also, is it possible to save data in the cloud and have access to it from another computer. For example, I want to view the data that I entered at work on my PC in my laptop at home. Does this make sense?

1 Reply
best response confirmed by CLCV1 (Occasional Visitor)
Solution

@CLCV1 

There is no version of Mac that can run on a Mac. There is no online version of Access. You can not put Access "in the cloud" and share the data directly that way.

You CAN, however, use a Windows Emulator application, like Parallels, and run Access in that Windows emulator. IIRC, there are other emulator applications, but Parallels is the most widely known.

 

To address the other part of your question requires a lot more background.

All relational database applications, including those created with the MS Access application, consist of three components.

  1. The Data tier, or layer. All data in a relational database application is stored in tables. There is a Database Engine which manages those tables. In Access, the database engine is called ACE. Other widely known and used relational database engines include SQL Server and Oracle. More on this below.
  2. The Interface tier or layer. All relational database applications require objects for an interface through which users--like yourself--can interact with the data in the tables. In a website, this is the web pages. In an Access relational database application, this is the forms and reports. Forms are bound to tables and allow users to call up data for viewing or modification, or to add new data to the tables. Reports are, as the name suggests, objects which retrieve data from the tables for summary presentation to the user.
  3. The Logic tier or layer. The coding language used in Access is VBA (and for minor tasks, macros). You use VBA to create logic that opens and closes forms, for example, and which calculates and manages data and other tasks.

So, with that background, you can use the Interface and Logic components of Access with its own internal ACE tables. However, Access also supports connections to a very wide variety of other database engines, including SQL Server, Oracle, MySQL and others.

So, to address your question about accessing your data from work and from home, the answer is yes, you can do that, but NOT with Access local tables. You'll have to set up a database that you CAN connect to from both locations, and that is probably going to be one of two or three options. 

 

You can obtain a SharePoint, or Office 365, account and use SharePoint lists in that O365 site as the tables for your relational database application. That allows the Access interface (forms and reports and code in an accdb) to connect to the SP lists from any location where you have an internet connection.

 

Another option is a remotely hosted SQL Server from a hosting site. I personally use Winhost.com, for example. For about $6/month I have a hosted SQL Server along with the ability to create and host a small website. For your purposes the SQL Server database is the pertinent offering.

 

And still another option is SQL Azure, which is a Microsoft offering. It is, essentially, a hosted SQL Server, but being part of Microsoft Azure, a great deal of other products and tools are available. You can obtain a minimal Azure account for a competitive cost. 

 

Of the three, I can't suggest which is most appropriate for your needs, except to note that SharePoint would probably require the least new learning to work with effectively. It is better suited for smaller applications, so that becomes a factor in deciding if it is a good fit. If you plan on handling a few thousand records, or maybe up to 50,000 or 60,000 records, SharePoint could be a good fit. If you are going to handle 500,000 or a million records, you'll need SQL Server or SQL Azure. 

 

There are probably a number of additional considerations. So post back with additional questions. Look for additional posts from experts.