>how can i prevent anyone from opening a table and viewing its contents

There are a couple of ways:

1) Have all data access go through a DLL. The user won't have direct access to the data.
2) Use an encryption tool. Look at www.hallogram.com for one.