Forum Moderators: phranque
I'm having a hard time trying to figure out how to solve the following problem:
My company just got a dedicate server from 1and1.co.uk (root server) and I created a database (MS Access) that will receive information from 2 or 3 different web sites (shops) located in that server and that will be accessible to the company employees for adding/updating/deleting data through Data Access Pages.
Now the problems:
1 - Do I have to have a "private" domain for the employess to access the database from? That's probably a stupid question, but I'm that inexperienced.
2 - Where do I have to put that database in the root server? There are about a zillion folders in it and I'm feeling kinda lost. Or should I keep it in the domain created for the employees?
3 - I'm using Data Access pages. How on earth do I connect a DAP in a website(domain) to a database that is on the same server but on a different domain or folder, whichever be the easiest?
I know it's a lot of stuff to be asking for, but any help will be REALLY APPRECIATED!
Thank you in advance,
Kiko
Does ODBC work with Data Access Pages? If yes, do you have any examples of how to create the connection?
And, what do you mean by "above the server structure". Is it somewhere other than \home?
THANK YOU!
KIKO
My experience with Access and SQL is via PHP and CF.
What I meant by 'above', is this:
Often times, there is a directory (via FTP), which is clicked on, to get to the portion of the pages which are visible online. If yours has this, you are able to create a directory ("data" for example) here, and put your DB in it. That way, the site can locate it, and it provides another security option.
