Compile question

[jazzz]

I have a DB that at some point I am going to compile and make a stand alone.&nbsp;&nbsp;I have a table which only I will update and will need to supply that file to clients from time to time.&nbsp;&nbsp;Should I place this table in it's own database so I can send just that file.&nbsp;&nbsp;Or is it pulled out of the DB automatically so that I can just send that one table (compiled) down the road and not mess any of their data?&nbsp;&nbsp;I hope that is clear.&nbsp;&nbsp;Currently all tables are in one DB while forms etc are in another.&nbsp;&nbsp;I am just concerned how will I update this one table as I receive the data which will be used by the rest of the DB.<br><br>Thanks

 

[jimmythegeek]

Create a seperate database and put that table in it.<br>Link your table to the main database.<br>Now when you need to update that table, simply replace the second db (the linked one), and you never have to touch the main db.<br>Just remember to always name the table and the database the same thing, updates will be seemless to your users. <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href=

http://www.cgeek.com>CompuGEEKS</a><br>Custom

Application Development

 

[jazzz]

Thanks Jim that's what I thought but I wasn't sure.