> I must confess this is the best idea I stole from A. I do not dare to > name the full name of A afraid of being on the black list > To my defence I have 1 A database and maybe 600 for R > So my conclusion is even the enemy have some bright ideas now and then
Gunnar: You should be able to use "R" in pretty much the same way as you use "A" -- you can put all your forms and reports in one database and SCONNECT another database with the data tables in it. You can simply update the front end database. In addition, "A" has an extremely annoying quality when linking tables in two databases -- the linked database path is stored in the linkage. This means trouble if you want to move the linked database or if the development machine and the deployment machine have different directory structures. Since "R" will SCONNECT via an ODBC DSN, you have a level of abstraction so that the databases can be placed in different directories on different machines. -- Larry
