[QUOTE=brawney]
What is the best location to put an Access MDB file within my web site directory structure?
C:\hshome\AccountName\db\MyAccessDB.MDB
This would not be accessible from the web at all, but would be available to all domains under the account.
Are my assumptions correct? Any other words of wisdom or tips for making this work?
[/QUOTE]
Your assumptions are indeed correct. From what I understand of the HSphere setup, ODBC links are domain independent so you can have all of your databases in a directory off the root and access it from any domain.
Unless you want to provide public access to your database, it’s the safest way to do things.
Adding to the previous posters comments, when you setup your ODBC connection make sure to use an ODBC name which won’t be easily guessed - reason being that you are installing onto shared servers and any other customer using that server could feasibly use your ODBC name to access your database.
Although it is a already old POST, that does not clear that it cannot respond in the same one.
The best form to place Access databases and not to use ODBC, is that the file *.mdb is in the /bin/ directory (or any other file that is desired to protect).
