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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
