I have a friend who wishes to open and maintain some Access databases but has an old version of Access, and has just moved to Vista. He doesn't particularly want to have to buy a new version of Access.

Does anyone know of anything OpenSource, that will open and edit the databases? I don't believe OpenOffice's Base program supports them.

Cheers,

Steve

Which version does you friend have, most versions including the early ones have no problems with vista.

I think you'll be lucky to find anything like that.

That refers to the ability of base:

OpenOffice.org Forum :: Missing mdb files when opening MS Access with Base Program

Think he's using Access 97.

Steve

I think you'll be lucky to find anything like that.

That refers to the ability of base:

OpenOffice.org Forum :: Missing mdb files when opening MS Access with Base Program

Thanks for this - may go some way to sorting the issue.

Steve

MDB Viewer Plus

"MDB Viewer Plus is a freeware viewer plus and editor for Microsoft Access MDB database files. It does not require an install to run provided that Microsoft Data Access Components (MDAC) is installed on your PC (In most versions of Windows this is the case).

MDB Viewer Plus has been written to provide a free, quick and easy way to view, edit, filter, sort and search MDB files without having Microsoft Access installed.

This is very useful if you need to look at an MDB file but do not have Microsoft Access installed on your PC.

It is not yet a full database development solution but does allow you to view MDB files without an Access license.

Features:

Inline table viewing and editing

Standard search

Filtering records by fields

Sorting records by fields

Printing

Record view

Record count

Query - standard SQL select statements

Table Info (field types) plus printing of structure

Table Types

No installation required to run. (Provided MDAC already installed as part of Windows)

Exports to TXT, HTML, XML, DBF, XLS, WKS, RTF and PDF

Import from CSV,TXT,Doc,XLS,WK1,WQ1,SAV,DB,DBF,MDB,ADO,ADT,DAT,HTM,XML,WAB and VCS

Support Access 2007 Accdb files (Provided "Microsoft Office Access database engine 2007" is installed) "

That sounds spot-on Val, nice one

Especially as it sounds like you can do some basic editing and changes. I think he just has addresses etc stored, so nothing mega-complex.

I'll pass this on, thanks again.

Steve