Access Databases on a Macintosh - Tech Learning

Access Databases on a Macintosh

Question: How can I view an Access database on a Macintosh? The IT Guy says: Three possible options come to mind. First, you could have the person export the Access database data as a delimited file, and then open that file with Microsoft Excel or another spreadsheet program. That way you could not only view
Author:
Publish date:

Question: How can I view an Access database on a Macintosh?

The IT Guy says:
Three possible options come to mind.
First, you could have the person export the Access database data as a delimited file, and then open that file with Microsoft Excel or another spreadsheet program. That way you could not only view the data, but also manipulate it. You can also import the delimited data into a native Macintosh database program like Filemaker Pro.

A second option is to ask your network administrator to configure a remote access account that will log into a Windows server and run Microsoft Access. This connection can be made using the free “Remote Desktop Client Application for Macintosh OS X.” Alternatively, you could log into a WindowsXP computer (at a time when another user isn’t working) from your Macintosh and run MS Access if it is installed on that computer. You will need to be able to open your Access file from the network, however, so it is a good idea to save the file to a shared network folder/directory first that you can access from the remote login.

A third option is to run Virtual PC on your Macintosh that has MS Office (including the Access program) installed on it. With this solution, you do not have to remotely open your Access data file via a network share. With Virtual PC, you can open files that are saved in folders on your Macintosh computer that are shared with the Windows/Virtual PC software emulator program.

Next Tip: Access Databases on a Macintosh

Featured

Related

Access Database on a Macintosh

Question: How can I view and use an Access database on a Macintosh computer? The IT Guy says: You have several options. If you are using an OS X Macintosh computer, you can use the free program from Microsoft “Remote Desktop Client for Macintosh” to remotely connect to a WindowsXP computer (with

Web Based Databases

Last week I mentioned Jotforms, an easy to use web tool for creating simple forms. This week I would like to expand on this idea and talk about online database tools. Basically these are tools similar to traditional desktop databases, except you access them and enter data via a web interface. Because they are accessed

Slow Macintosh

Question: My Macintosh, which runs OS X, seems to be running much more slowly than it has before. What can I do? The IT Guy says: Over time, cache files can build up and certain files can become corrupted on your computer, so it can be good to clear these out and repair corrupted files. Applejack is a free and

Macintosh disks on PC

Question: How can I read Macintosh disks on my PC? The IT Guy says: First, if you are still using floppy disks, it is really time to join the 21st century and get rid of them – or keep them just for their sentimental value! Copy your data to a folder on your network or hard drive and burn a CD of it.

Image placeholder title

Product: Bento 4 for Macintosh

If your database needs are simple and you’re a Macintoshbased school, Bento 4 is a user-friendly, economically priced entry-level database program.

Support for MS Office for Macintosh

Question: How can I get free support on Microsoft Office Mac? The IT Guy says: Free support for MS Office for Macintosh is available from “Office 2004 for Mac”. A searchable knowledge database specifically related to Office for Mac is in the right sidebar: enter keywords for the problem with which you want help

Repairing Macintosh Disk Permissions

Question: With Macintosh OS X, I don't seem to need to rebuild my desktop like I used to do with OS 9. What types of regular maintenance should I do to keep my system running smoothly? The IT Guy says: You are correct that Macintosh OS X native applications do not require you to rebuild your desktop, but if you

Screen shots on a Macintosh computer

Question: How can I create screen shots on a Macintosh computer? The IT Guy says: Macintosh computers, including newer OS X as well as older OS 9 / 8 / 7 computers, offer comparatively more built-in options for screen capture than do Windows computers. To copy an image of the entire screen to a saved file on

Fixing a Corrupt Entourage 2004 Database

Question: My Entourage 2004 has a corrupt database. I attempted to use the database utility tool and it gives me an error message. "An error occurred while attempting to verify your database. An unknown error (-5000) occurred." No matter what I try, verifying integrity or rebuilding database, etc., it gives me the