My reply to Kelvin - hopefully at this point the conversation will
continue on this list:
<DIV><FONT face=Verdana size=2> </FONT></DIV>
Helping OO.org users help each other <br>
http://user.services.openoffice.org
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: Thursday, January 31, 2008 08:03 PM
>To: 'Drew Jensen'
>Subject: Re: [users] OpenOffice Base in a multi user environment.
>
>
>Hi Drew and Dan,
>
......<snip>
>That said, if I have understood you correctly, all those JDBC, ODBC
and ADO
>etc. are means to connect to known database servers such as MySQL,
>PostgreSQL?
Yes - and that list of known database servers could include an MS
Access file.
>You see, I work in a company using only windows2K and XP.
Going forward then I will limit the options to MS Windows capable
solutions.
>I am planning to have a database of information which staff on the
>production floor should be able to access at any time and which would
>record what they have read
>to replace the current manual method of making them read the
information and
>signing against an attendance sheet.
> However, I am unable
>to get it to work the way a normal Access form does, due either to the
>limitations of the program or my skill or perhaps a little of both.
>I have read that I would either need to create a ODBC
>something on each computer to allow OO Base to access those databases
>created in MS Access.
Yes, you are correct each, satellite PC (workstation) will need to
have ODBC or OLE/DB installed and properly configured. MS distributes
both for free, and I can refer you to some good reference material on
the net about how to configure for a shared Access file on W2K .
The bottom line however is that once you have the workstations setup
such that MS Access could share the file, then yes OpenOffice.org and
Base could be used in place of the MS Access program at the
workstations, sharing the database on the W2K server.
>I was wondering, what would be the
>best way for me to implement my idea given my knowledge level on this?
>
If you don't mind I would like to invite you to continue this
discusson on the user mailing list for the Base project. I have
already taken the liberty of posting the previous emails to that list
and will do so with the ones up to here also. For one thing there are
others on that list much smarter then I that could help.
I see that NOOP has already mentioned this possibility, to reiterate
what he said -please check this page
http://dba.openoffice.org/servlets/ProjectMailingListList
and subscribe to the user mailing list there and say hello.
Of course if you prefer we can stay on this list - your call.
Thanks
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
