From posts about accessing Access database files in the past: This requires a special driver that is presently available only in Window OS's. (I think it is ADO.) So, Linux and Mac can not open Access files until the appropriate driver is written.
Dan On Wednesday September 5 2007 12:53 am, NoOp wrote: > On 09/04/2007 08:53 PM, Bob McConnell wrote: > > NoOp wrote: > >> On 09/04/2007 07:45 PM, NoOp wrote: > >>> On 09/04/2007 06:28 PM, Andrew Douglas Pitonyak wrote: > >>>> I have not checked these links... > >>>> > >>>> http://www.openoffice.org/FAQs/*ms*-*access*.pdf > >>>> > >>>> http://dba.openoffice.org/drivers/mdb/index.html > >>>> > >>>> Finally, you might be able to create an ODBC link. > >>> > >>> A connection for the following URL was requested: > >>> sdbc:ado:access:PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA > >>> SOURCE=C:\Program Files\Microsoft > >>> Office\Office\Samples\Northwind.mdb > >>> > >>> I've found that it doesn't work under linux any more. Don't know why > >>> (yet). Even if I move the .mdb to a linux drive/directory it still > >>> won't open it. However, it _does_ open in OOo windows. > >> > >> Added note: from Windows 2.2.1 the sample Northwind.mdb file opens > >> without a single hitch. All the tables are available, etc., etc. This > >> appears to be a linux (and possibly MAC) issue. If I get time > >> tomorrow I'll search the bug database and see if I can find anything. > >> > >> Tested in linux 2.2.1 & latest 2.3rc1Dev - neither work. > > > > If you are trying to do this from the shell, the backslashes won't > > work. Unix shells interpret backslashes to be escape prefixes, so they > > simply disappear. In addition, most Unix applications will treat the > > spaces as delimiters, truncating the path. If you are inside an > > application, then it will depend on whether the application can > > differentiate between Unix style paths and MS-Windows' extended style. > > Try it with "C:/Program files/Microsoft > > Office/Office/Samples/Northwind.mdb" with the double quotes wrapping > > the path to protect the spaces. > > > > Bob McConnell > > N2SPP > > Thanks but that has nothing to do with it. The message is from Base > directly, and the path is a well identified nfs-3g drive that OOo > (linux) accesses on a daily basis. As I said in the next post, the same > occurs even if the file(s) on the linux drive and/or path. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
