Viewing the contents of a .mdb (Access) database?

[IGx89]

How do I view the contents of a .mdb file? I've searched all over, and the only program I found was shareware and just listed the field names, not their values. I'm brand-new to database programming, so please share even the most basic advice. If it helps, I'm trying to access Adobe Album 2's database file that stores the locations and tags of photos; the file ends in .psa, but I was told by a developer at Adobe that it's just a simple Access database (which it appears to be).

[Mazdak]

Can't you open it with Access? :confused: You can view the Bitmap fields by Paint from Access, otherwise simply write an application that read image fields and show each picture there. (You said you know the name of fileds) Mazy No sig. available now.

[IGx89]

The problem is, I don't have Access (the Academic version of Office 2003 doesn't include Access), and I don't think the shareware app listed all the fields. The database file is only ~300kb for ~50 photos, so I think it just has filenames and metadata.

[Guillermo Rivero]

Use VS.NET. Server Explorer. Free your mind...

[Mazdak]

Well just try this one: I open my .mdb file with Excel and it works,at least you can see name of fields and table and value of non-image fields.Then with the name of them you can write your own application. Mazy No sig. available now.

[IGx89]

Thanks, that works great :)

[totig]

Have you tried Microsofts free Access viewer?

[IGx89]

That was the first thing I looked for, but I couldn't find one - I only found an Access snapshot viewer, which only opened *.snp files.