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

[carl r]

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.

 

[Arvin Meyer [MVP]]

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.

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

 

[Rick Brandt]

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.

 

[aaron_kempf]

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

 

[Duane Hookom]

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.
--
Duane Hookom
Microsoft Access MVP

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

 

[Gina Whipp]

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!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II
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

 

[a a r o n . k e m p f]

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

 

[a a r o n . k e m p f]

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 shit about anything else..

Most MVPs around here preach DAO. That is a ****ing 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 ass.

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

 

[Gina Whipp]

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

--
Gina Whipp

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

message
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

 

[a a r o n . k e m p f]

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