Access alternatives

[Nathan England]

Is there an easy way to import the access tables, columns and records? Or are 
you talking by hand? Because I'm talking about maybe 50 different databases 
each with probably 1000 rows each. They are not small access databases. This 
is something I am entirely excited about doing by hand and certainly not 
something they will allow at all!

Unfortunately, I really know nothing about access.

On Tuesday 18 April 2006 12:33, you wrote:
> Start slow; you can have a real MySQL back end up in less then a day
> (depending on the number of tables, columns, and records) then just link
> the tables in a central Access DB and import all other existing queries,
> reports, modules, etc.  At least they can get their data from other
> platforms then :)  And at the same time they will realize increased
> stability and performance (performance depends on a number of
> factors...)
>
> As for something that can read an access file and use the query's and
> reports, I too would like to find one.
>
> -----Original Message-----
> From: Nathan England [mailto:nathan at paysonlinux.org]
> Sent: Tuesday, April 18, 2006 12:27 PM
> To: Bryan O'Neal; Phoenix-LUG,
> Subject: Re: Access alternatives
>
>
> I have thought about such a project, but they are not interested in such
> a
> rewrite of their current databases. Though because they are quite large,
>
> maybe I should recommend that. But to satisfy the immediate urge for a
> Linux
> desktop, I am just seeking a quick and simple solution.
>
> I do think a migration to a real database is not out of the question
> though,
> just not at this time.
>
> On Tuesday 18 April 2006 11:48, you wrote:
> > OO has a reasonable personal database function and can be used to
>
> build
>
> > queries forms and reports, though it is not nearly access quality.  In
> > addition I have had major issues with the file based DB it uses, so I
> > would recommend putting up a MySQL back end for the data and use a
> > combination of tools like the one in OO and more powerful ones like
> > DBACentral or MySQLFrontend to take care of creating tables and
>
> lookups.
>
> > Though I am sure others have even better tool suggestions.
> >
> > -----Original Message-----
> > From: plug-discuss-bounces at lists.plug.phoenix.az.us
> > [mailto:plug-discuss-bounces at lists.plug.phoenix.az.us] On Behalf Of
> > Nathan England
> > Sent: Tuesday, April 18, 2006 11:39 AM
> > To: Phoenix-LUG,
> > Subject: Access alternatives
> >
> >
> > One of the departments in an organization I consult for recently
> > requested a
> > new server. I gave them several recommendations and they chose the
>
> more
>
> > power
> > system to my surprise, but with opted for RHEL4 instead of Windows
>
> 2003
>
> > Server.
> >
> > Two weeks later, I have completed the integration/replacement of the
> > Windows
> > 2000 AD server with the RHEL4/Samba server. The integration was nearly
> > flawless with only a few minor irritations I have yet to figure out.
>
> But
>
> > throughout all this, I have had the corporate honchos watching what I
>
> am
>
> > doing and have been impressed with the features of the server and
>
> things
>
> > I
> > can do with my laptop. Since many of them are having major spyware
> > issues,
> > which so far I am lucky to avoid being a consultant I am not to waste
> > time on
> > little projects... lol, I they are seeking a way to avoid all these
> > problems.
> > Throughout discussions on the server and why RHEL instead of Windows,
> > they
> > recall my mention of 'no spyware and few viruses' and they are curious
> > about
> > their desktops now. The entire orgranization uses word documents and
> > excel
> > spreadsheets, nothing advanced by any means, which OO.o could easily
> > replace
> > and some are already using it. The only problem however is the access
> > databases, which there are MANY.
> >
> > Are there any ( I don't care free or not, just _ANY_ ) replacements or
> > alternatives for Access databases?
> >
> > Nathan

-- 

--------------------------------------------------------------
Payson Computer Services
PO Box 2551
Payson, Arizona 85547
(928) 595 - 1449

http://www.paysonlinux.org/
nathan at paysonlinux.org

Business Consulting Services,
Advanced Network and Server Design,
Security Solutions,
Process Management and Efficiency Consultations