How do I save an Access form so it can be opened in Open Office

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

carl r - 12 Apr 2008 01:49 GMT

I have developed a database and a form for my son. However, he does not have
Microsoft Access he has Open Office. When he connects to the Access file he
only gets the database table. I would like to know how to save the form in a
manner that he can open it and edit data while using Open Office.

Reply to this Message

Arvin Meyer [MVP] - 12 Apr 2008 02:37 GMT

>I have developed a database and a form for my son. However, he does not
>have
[quoted text clipped - 3 lines]
> in a
> manner that he can open it and edit data while using Open Office.

Access data is readable in Open Office, Access objects are not.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Reply to this Message

Rick Brandt - 12 Apr 2008 02:40 GMT

> I have developed a database and a form for my son. However, he does
> not have Microsoft Access he has Open Office. When he connects to
> the Access file he only gets the database table. I would like to
> know how to save the form in a manner that he can open it and edit
> data while using Open Office.

Can't be done. As far as I know Open Office can see data only from an MDB.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

aaron_kempf@hotmail.com - 12 Apr 2008 03:57 GMT

ROFL ROFL ROFL

that is _SO_ hilarious.

Welcome to the world of 'getting screwed becuase you trusted
Microsoft'.

Access doesn't work like this-- Access Database is _COMPLETELY_
proprietary.

I would reccomend keeping your _DATA_ where it belongs.
either mySQL or SQL Server.

HTH

-Aaron

> > I have developed a database and a form for my son. However, he does
> > not have Microsoft Access he has Open Office. When he connects to
[quoted text clipped - 8 lines]
> Email (as appropriate) to...
> RBrandt at Hunter dot com

Reply to this Message

Duane Hookom - 12 Apr 2008 05:09 GMT

Aaron,
And this answers the original form question how? Are you suggesting SQL
Server or MySQL have forms that can be opened in Open Office? I use SQL
Server almost exclusively but have had to create web pages, Access forms, etc
to provide a user interface.

Signature

Duane Hookom
Microsoft Access MVP

> ROFL ROFL ROFL
>
[quoted text clipped - 25 lines]
> > Email (as appropriate) to...
> > RBrandt at Hunter dot com

Reply to this Message

a a r o n . k e m p f @ g m a i l . c o m - 12 Apr 2008 07:34 GMT

We all know that this is a load of crap!!!

There isn't a MVP on this group that knows how to _SPELL_ SQL Server--
I mean 99.9999% of the dipshit MVPs on this channel try to talk people
_OUT_ of SQL Server and _IN_ to using Terminal Services.

99.9999% of the MVPs on this channel spread _LIES_ about MDB. Because
they're too 'stuck in the 90s' to give a sh.t about anything else..

Most MVPs around here preach DAO. That is a f.cking load of crap and
I will not stand for it.

Microsoft tried the 'divide and conquer' approach for all of us. You
dipshits fell for it-- now you all get SharePoint shoved up your a.s.

That doesn't sound like fun to me.

I just wish that you had the balls to know how to run Access Data
Projects, kid.
It would be wonderful to have someone else around here that had a
clue.

-Aaron

PS - the punchline of course-- is that OpenOffice has the ADP concept
down pretty tight with openOffice & mySql the last I checked ;) The
bottom line is that you should not be tied to a particular
architecture. Maintaining different applications on each desktop is a
nightmare. Keep your data where it belongs- on a db server- and use
Dreamweaver when you leave MS Access. Nothing else out there is
remotely comparable to Access ;)

On Apr 11, 9:09 pm, Duane Hookom <duanehookom@NO_SPAMhotmail.com>
wrote:

> Aaron,
> And this answers the original form question how? Are you suggesting SQL
[quoted text clipped - 37 lines]
>
> - Show quoted text -

Reply to this Message

Gina Whipp - 12 Apr 2008 05:27 GMT

And I quote...

"Welcome to the world of 'getting screwed becuase you trusted Microsoft'."

Ummmm, isn't SQL Server by Microsoft? Oh, and you might want to check if
your spell check is working!

Signature

Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

> carl r wrote:
> > I have developed a database and a form for my son. However, he does
[quoted text clipped - 9 lines]
> Email (as appropriate) to...
> RBrandt at Hunter dot com

Reply to this Message

a a r o n . k e m p f @ g m a i l . c o m - 12 Apr 2008 07:29 GMT

if you had your data in SQL Server; it woudl be _EASY_ to get to --
from any operating system ever.

SQL Server is by Microsoft-- but it's not a 'cement boots database'

Access MDB is a one-way trap-- this format is not reliable enough for
a single record and a single user.

-Aaron

> And I quote...
>
[quoted text clipped - 44 lines]
>
> - Show quoted text -

Reply to this Message

Gina Whipp - 12 Apr 2008 12:51 GMT

Same old sound, same old dance! You know it's not true but you can't help
yourself... Oh, well...

Signature

Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

> And I quote...
>
[quoted text clipped - 45 lines]
>
> - Show quoted text -

Reply to this Message

a a r o n . k e m p f @ g m a i l . c o m - 12 Apr 2008 17:31 GMT

LIKEWISE

I know _WHAT_ is true?

That SQL Server is better; faster; easier?

I know _WHAT_ is true?

That centralizing your IT dollars in SQL Server is a _MUCH_ better use
of money than hiring a bunch of OLD NASTY DUDES THAT WRITE AN OBSOLETE
LANGUAGE?

You're the dork that's getting conned by these guys ;)

> Same old sound, same old dance! You know it's not true but you can't help
> yourself... Oh, well...
[quoted text clipped - 68 lines]
>
> - Show quoted text -

Reply to this Message