The Underscore Archives

You can connect to an Access database with ODBC or JDBC to extract the
data automatically.  The reading process wouldn't need to change the
Access database so wouldn't cause any problems.  I've recently written a
couple of routines that read from / write to Access importing to MySQL
all through JDBC. Feel free to contact me directly if you want to
discuss in more detail.

What format does the data need to be converted into?

Ed.

Jessica Norwood wrote:
> On Dec 11, 2007 1:58 PM, andrew holway <andrew at moonet.co.uk> wrote:
>
>   
>> I think all the sensible techs stay away from Access. Its nasty for
>> scalability and performance over a few users. And just basically
>> sucks. a lot.
>>     
>
>
> The database I'm currently working on certainly sucks.  It sucked a lot
> before I got my hands on it; I think it sucks less now but it's still not
> great.  Access and I are not the best of friends.
>
> Whats the application?
>
>
> It's just an order-tracking thing with suppliers, customers and shippers.  I
> think only about 3 people in the company make changes to it.  The problem is
> that there's no separation of front-end and data at the moment, which means
> that every time I change something I have to painfully migrate their latest
> data over (out-of-hours!).  I'm vaguely aware that they can be separated in
> Access, but wouldn't have a clue how to do it, or what I might break in the
> process :/
>
> Jess
>   
-- 

Edward Ross (Director)
Ross Technologies Limited
Phone: +44 (0)1275 331 912
Fax: +44 (0)845 6800062
http://www.rosstech.biz