To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=86891 Issue #|86891 Summary|Allow integration between distinct databases as MS-Acc |ess do Component|Database access Version|OOo 2.3.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|claudiokfuri
------- Additional comments from [EMAIL PROTECTED] Mon Mar 10 21:17:06 +0000 2008 ------- 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 ? --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- 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]