Yes, You will need an Rbase database to hold the Sattached table definitions, forms and reports. You should need to only Sattach to them once. No problem in leaving them attached.
You need to find out about the clients MS SQL server licensing and whether the software package they have allows ODBC connections. There may be restrictions on the number of connections to their database and each Rbase session would take up one connection count. (Just like a 10 seat Oterro license will only allow 10 connections they may have a limited number available as well) So if their user is running the existing software and then starts your Rbase front end application, that user will now be using (2) access licenses instead of just one. (Again, this is only a possibility you should check, I am not saying it is a certainty) Some software companies also lock out their database to various degrees. Some will allow view only while others will allow full updates. Again you will need to check out what the case is. This function is not so much MS Server but how the other company sets up their security on tables. Just because the existing application is in MS SQL Server does not necessarily mean you will have access to the data. I use RBase for front ends to other system often, however sometimes I am very limited to what can be done due to the security setup on the foreign database. To find out how much access you will have, you may have to do testing as some companies will not be very open to sending out information on how to hook into their database. -Bob ----- Original Message ----- From: [email protected] To: RBASE-L Mailing List Sent: Saturday, November 21, 2009 9:39 AM Subject: [RBASE-L] - Re: RBase and SQL Server It occurs to me that I wasn't clear enough when I posted my question. I might want to use RBase as a front-end to a SQL Server database. IE: no RBase database involved. Do I need to have a shell RBase database and SAttach every single SQL Server table? There could be hundreds of them! I'm assuming I would have to do that only once, though, and keep them always sattached (any problem with that?). No other way to front-end another database without going thru the SAttach? I found out that SS 2008 has separate date and time fields. Hurray. Karen ------------------------------------------------------------------------------ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.425 / Virus Database: 270.14.74/2515 - Release Date: 11/20/09 08:02:00
