Dear Sir,

I´m trying to create some database views in which I use some tables from a 
database located in SQL Server and other tables located in OpenOffice Base.

Unfortunetely, I could only save the SQL Server tables via ODBC connection in a 
separe odb file. Thus, it was impossible to view those tables together with the 
tables from the local database, in order to add them to the queries that would 
produce the desired views.

I´ve asked some specilists from BROffice site (the OpenOffice official site in 
Brazil) and they confirmed that this is a feature not implemented yet.

I argued that it is a very basic feature to not having being included 
yet...after all, almost every applications will need to relate tables from 
distinct databases, and without that, OpenOffice base will be like a toy that 
can be used to crete "pilots" or "prototypes".

So, I think you should assign a righ priority to this new feature immediately 
to the next release. 

For you t have an idea of the problems that this limitation cause, I´m thinking 
about using MS-Access to relate the tables and save the results in a shared mdb 
file, and use OpenOffice Base just as a "reader" for around 50 users. Using 
this approach, we will have to buy only one license of MS-Access to work 
as "middleware server", and install only OpenOffice Base in the 
users´computers, so that they can access the information they need.

I think that OpenOffice Base is a good product, and I´ve been a fan of it, but 
the first priority in its project should be eliminate the need to use MS-
Access...it´s a question of honor for the OpenOffice community, don´t you 
think ?

Thank you in advance for your attention !

Best regards,

Cláudio Kfuri
Systems Analyst
Brazil.

PS : After I have concluded the project that will implement the approach using 
MS-Access, I can send it to you via email if you want, so that you can analyse 
the best way to do that using only OpenOffice base, ok ?