Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to use/configure the MS-Access Database?

April 26, 2017configure database ms-access

0

Posted

How to use/configure the MS-Access Database?

2 Answers

0

Posted

Upload all your database files in the “db” folder. For OLEDB Connection string Set con=Server.CreateObject(“Adodb.Connection”) con.Open “Provider=Microsoft.JET.OLEDB.4.0; Data Source=c:\domains\yourdomain.ext\db\YOUR_database.mdb” Try creating and using ODBC DSN connections . It is simpler. If you want OLEDB, the database location is c:\Domains\yourdomain.com\db\your-database-name.mdb You create ODBC DSN from the domain page (LOG IN TO YOUR HELM CONTROL Panel > Click On Domains Icon > click on yourdomain.com) You have to create the database first (using Database manager). Then creating the DSN for it (using ODBC DSN) using the name of the database you just created. That is all.

0

Alex Krenvalk Posted

My friend told me an interesting story about his problems with access databases. But I have already run across like issue and remembered about one solution. For luck it solved out my trouble and probably might be useful in this question – Access Recovery.