Procedures : OBDC-DSN connection in MS Access ? Print

  • 0

Description :

This procedure allows you to OBDC-DSN connection in MSACCESS

Required Information :

Your website's hosting control panel user name and password.

Procedure :

Note : ODBC is an old method of connecting to the database. Hence start using dsn less connection. That way you can connect to any number of databases.

Please note that to work with the msaccess database use the procedure,

For any database , you will have to give write permission to insert data.

How to give write permission :

[1] Go to your windows control panel .
[2] Click on the tab file manager .
[3] Click on httpdocs .
[4] Now you will see list of files uploaded in the server.
[5] Against the database file, click on lock icon .
[6] Against psaserv - give write permission.
[ ! Notes ]
Please note that you need to give write permission for the MS access database.
Please be careful while giving the permissions. Follow exactly what we have said there and do not try giving permission for httpdocs folder.


 


Was this answer helpful?

« Back