Re: Upsize MS Access databases

Hi. I have gone through the whole process and in the end of the day I am having a hard time facing the future, because there's a lot of hick-ups between Informix and Access; especially when you use a driver from a third supplier i.e. Intersolv. When you get major problems (and be asured, they come) you will be pushed around from the service people: Informix blames Microsoft, Microsoft blames Intersolv and so on... but nobody is able to give you a qualified answer... even worse: nobody even feels responsible for giving you an answer! So my dearest advice would be to make a decision: Do it the Informix way or do it the Microsoft way and use tools from one supplier straightforward. For Microsoft's SQL-Server you get a tool by the way, that let you upsize your database the easy way. Good luck, -- Harry Meyer Albat+Wirsam Software-Vertriebs-GmbH Linden Please remove spamguard from my email address if you want me to receive your mail! Art S. Kagel schrieb in Nachricht <36783A76.2A7F@bloomberg.net>... >Zdenek Fajfr wrote: >> >> This is a multi-part message in MIME format. >> >> ------=_NextPart_000_0021_01BE28CB.5F59DEF0 >> Content-Type: text/plain; >> charset="iso-8859-2" >> Content-Transfer-Encoding: 7bit >> >> Hi all, >> my question is relatively simple. >> How to transfer MS Access database (version 8.0) to Informix OL 7.10? >> So far I was able to transfer only individual tables using ODBC connection. >> Is there any tool that would enable me to upsize whole MDB database incl. >> relations etc. to Informix server? > >No the only other thing you can do is export the data to delimited >files and export the table structure. Create the new tables in >Informix and use dbload or the dbaccess LOAD command to reload the data. > >Art S. Kagel