Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / fpc-pascal / 2000-12

M$ Access

4 messages · 3 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Andre Wohnig

Hello all!

Is there a chance to read and write to Microsoft Access from DOS within Pascal?
I´ll be verry thankfull for informations and/or examples.

tia
Andre´

Thiesen | André Wohnig hardware- & software- design GmbH | Im Tiegel 9 | www.thiesen.com 36367 Wartenberg | tel. +49 (0) 6641 979-142 fax -299
Michael Van Canneyt
to Andre Wohnig
Andre Wohnig wrote 5 lines
Hello all! Is there a chance to read and write to Microsoft Access from DOS within Pascal? I�ll be verry thankfull for informations and/or examples.

There is no way:
1) You need the Jet engine to access (sic) a MS-Access database. The Jet engine runs only under Windows.
2) You must be able to use interfaces to access the Jet engine. The Interfaces support is not yet ready for this.

Michael.

Kuba Ober
to Andre Wohnig: Hello all! Is there a chance to read and write to Microsoft Access from DOS within Pascal?
Is there a chance to read and write to Microsoft Access from DOS within Pascal? I´ll be verry thankfull for informations and/or examples.

Sure there is as long as you have access to the file. Try digging up file formats somewhere. MSDN (http://msdn.microsoft.com/library) would be the first choice, and then some hacking sites maybe... The data in an Access file is wrapped at least once. I don't know whether Access files are OLE Compound files, but that might also be the case, so then it would be double-wrapping.

It seems that OpenOffice sources have all the M$ Office files fully documented (as code, at least) - see http://www.opensource.org.

Kuba

Kuba Ober
to Kuba Ober
Show quoted text 12 lines
> Is there a chance to read and write to Microsoft Access from DOS within > Pascal? Sure there is as long as you have access to the file. Try digging up file formats somewhere. MSDN (http://msdn.microsoft.com/library) would be the first choice, and then some hacking sites maybe... The data in an Access file is wrapped at least once. I don't know whether Access files are OLE Compound files, but that might also be the case, so then it would be double-wrapping. It seems that OpenOffice sources have all the M$ Office files fully documented (as code, at least) - see http://www.opensource.org.

Commenting on myself ;-)
1. I meant see http://www.openoffice.org
2. You can also try finding a free odbc driver implementation for linux. There is a free implementation of odbc architecture for linux (dunno where, though, use your favourite search), and it may contain access drivers. The code will be in C, but you can port it to FPC.

Kuba