[Year 12 Its] VB and Access Problem

[Con Zymaris]

On Tue, May 31, 2005 at 03:07:47PM +1000, Sam Gerges wrote:
> Hi all,
> I am sorry, I sent the same message to IPM list, 
> I typed IPM instead of IS, so sorry if you get the same message twice.
> 
> I am just wondering if there is someone who can help me in this issue.
> There is an issue that I have found in importing a database from
> Microsoft Access 2000 for use in Visual Basic 6.
> This causes an “Unrecognized Database Format” error (#3343).
> A temporary solution was found a while back in importing an Access 2000 
> database back into Access ’97 format, but doing
> this removes the automatic validation (letters in a field designated to numbers, and so on.) 
> It appears that it is Visual Basic in fault at this. 
> Has anyone else encountered this problem, and if so, has anyone found a solution that
> does not involve Visual Basic 7 or Microsoft Access 2003?

Sam,

_If_ you want to pull your data out of this MDB file but don't want to use 
VB or Access, download these free tools:

 http://mdbtools.sourceforge.net/

I am also led to believe that OpenOffice.org 2.0 now also supports Access
MDB files. Download (for Windows) for free from here: www.openoffice.org

Cheers,
 
Con Zymaris, Convenor
Open Source Victoria
http://www.osv.org.au/
-- 
___________________________________________________________________________
Con Zymaris <conz at cyber.com.au> Level 4, 10 Queen St, Melbourne, Australia 
Cybersource: Australia's Leading Linux and Open Source Solutions Company 
Web: http://www.cyber.com.au/  Phone: 03 9621 2377   Fax: 03 9621 2477