Access Database on a Macintosh - Tech Learning

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
Author:
Publish date:

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 remote access enabled for your user-ID) that has the desired Access file on it or is accessible via the network. The computer you access remotely will obviously need to have MS Access installed on it.

If you want to directly open the databse on your Macintosh computer, you can download a free version of Open Office and use its BASE database program to open and use Access files.

A third choice is to have someone (or yourself) export the data from the Access database as a delimited text file. You can then open and manipulate that data in a Macintosh compatible spreadsheet program like Excel, or a Macintosh compatible database program like Filemaker Pro.

Next Tip: PhotoStory for Windows2000

Featured

Related

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

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

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

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

Autoconnect to Servers in Macintosh OS X

Question: How can shared folders on the server automatically mount on the desktop when users login using Macintosh OS X? The IT Guy says: When a shared directory on a server is "mapped" to a drive letter in Windows, an option is provided to "reconnect at login." The same functionality can be achieved for

Macintosh OS X Server

Question: Is there any easy book you can recommend to help me learn more about Macintosh OS X server? The IT Guy says: Most of Apple’s newer software options have shipped “rather thin” on paper documentation, but with robust online help guides. If you cannot find information about a specific task or

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.

Remote Control Macintosh and Windows Servers

Question: Our district has both Windows-based and Macintosh servers, and I would like to use the same program to remote control both server types. Do you know of a software solution that can do this? The IT Guy says: Timbuktu Pro Remote Control Software can do this. An enterprise version is available also, if you

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