In order to allow others to be able to read and write from
your database you need to provide a connection and set permissions allowing
them to do so. This tutorial will walk you through the necessary steps to accomplish
this task.
Step One – Find the ODBC Connection.
Click on the Start Menu, and Select Control Panel
At this point you will need to select Administrative Tools
After which the following Screen Should appear and you will
need to select Data Sources (ODBC)
This will produce the following screen—Select System
DSN—then Click ADD
Click on Access Database (or SQL if you have created and
SQL Database) and select Finish.
You will then be prompted to specify some parameters, like
a name and location for the database
If successful you will see the following screen:
Click OK and then proceed to Windows Explorer as you need
to see the permissions so others will have the ability to read and write to
your database. Once you have located your database, right click on the database
file and select Properties.
The Following Screen should appear:
Click on Security and the following screen will appear
In most cases you will have to add the Internet Guest User
Account, this is accomplished by clicking on ADD and scrolling down to find
IUSR_MACHINE_NAME, again Click ADD and then OK
At this point you will want to make certain the READ,
WRITE, EXECUTE Boxes are Selected.
Click Apply, then OK and you’re ODBC Connection will be
established!