Access convert to OpenOffice!

[Bob]

--

Is it possible to convert MS Access DB to OpenOffice.Base, I seem to be able
to import Tables and Queries Only?
Thanks for any Help...Bob

 

['69 Camaro]

Hi, Bob.

Is it possible to convert MS Access DB to OpenOffice.Base, I seem to be
able to import Tables and Queries Only?

No. The other objects are incompatible. You must recreate them from
scratch within Base.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Bob]

Thanks Gunny, How is it when I imported them they all went into tables my
queries!
Thanks...Bob

 

['69 Camaro]

Hi, Bob.

How is it when I imported them they all went into tables my queries!

That's what the driver can handle for data access to the MDB file. It's as
close as you're going to get as a conversion of MDB to Base database files.
The rest you have to do manually.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Bob]

Gunny Whats your opinion of OpenOffice.Base will it do everything my
Microsoft Access db does, Do you think its worth converting because
OpenOffice is free so my friends can use my Access DB???..........Thanks Bob

 

['69 Camaro]

Hi, Bob.

Whats your opinion of OpenOffice.Base will it do everything my Microsoft
Access db does

I haven't used it enough to have formed an opinion yet. I loathed Access
for the first four or five months, and now I'm a big fan, so I should give
other products a reasonable amount of time before forming an opinion, too.

Do you think its worth converting because OpenOffice is free so my friends
can use my Access DB???

Depends upon how much time it would take to convert. If it's only a few
hours, sure. If it takes a month or more, no way. However, if price is the
main factor in your decision, consider upgrading to Access 2007. With a
license for Access 2007, the Access 2007 Runtime version will be free to
distribute. The Access 2007 Runtime is scheduled to be released around
March 2007. Please see the following Web page for more information and
links to even more information:

http://datadevildog.blogspot.com/2007/01/access-developer-extensions-2007-are.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[ryan]

Thanks Gunny, How is it when I imported them they all went into tables my
queries!
Thanks...Bob
message news:[email protected]...