I have an Access .accdb database that I want to upload and connect to from my website. I have it working on my localhost, so I know that the issues I'm having are just on the godaddy side of things.
Here's what I've tried:
(1) I had an Access .mdb database on my site that I was able to connect to. It worked both on my localhost and worked when I uploaded it to my godaddy website, with no changes. I didn't use any of the godaddy database tools, I just had it in a folder on my website. I tried the same thing with the new .accdb database, but it does not work. When I load a page that uses the database, it immediately redirects to the default 500 error page (which I hate -- it would be more helpful if it stayed on the page so I could see the error message and know what the problem is).
(2) I thought maybe I needed to use Godaddy's database tools instead, so I used the admin to create a sqlserver database. However, in the database admin tools there was no way to import my database into this new sql server db. There's only a .csv import directly into a single table. My database has many tables and many views set up and there's absolutely no way I'm going to do a tedious import like that every single time I make an update.
Has anyone else ever uploaded and connected to an .accdb Access database? How do I do it?
I would greatly appreciate any help. Thank you!
Solved! Go to Solution.
Did you do all of the following?
Thank you for your response.
On step #4, "In the Databases section of the Hosting Control Panel, click the Access icon.", there is no Access icon there for me to click. There is a MySQL icon and a SQL Server icon, neither of which go to anything that says "Enable Access Support".
However, there is already a "access_db" folder on my site (I didn't put it there). I have tried moving my database to that folder and and updating the code to point there instead of where I had it before, but I still get redirected to the 500 error page when I try to load the page that accesses the database.
See Considerations for server-side Automation of Office. Microsoft does not support use of Access server-side and warns against doing it. So the solution to problems with use of Access in a website is to convert to something else.
I would like to know also.
I am trying to re-brand myself. I currently run CountyRealty.com elsewhere; but I'm thinking about using GoDaddy.
It looks like a total pain to use MS Access .mdb's here. If you found a solution, please let me know what you did.
See my previous reply. See Considerations for server-side Automation of Office. It is old but I have not heard of any relevant changes. The article is technical in many places so the following are quotes of relevant portions. You can (try to) read the article for more but the important thing is that if you want a reliable and professional web site then you definitely do not want to use Access for it.
In this context ... the 2010 Access Database Engine are considered Microsoft Office components.
All current versions of Microsoft Office were designed, tested, and configured to run as end-user products on a client workstation.
They do not provide the level of reentrancy or security that is necessary to meet the needs of server-side components that are designed to run unattended.
Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.
I was hosted and I plan to go back to Web.com. I tried to convert my web pages to GoDaddy. I have over many years created successful ASP pages that connect to Microsoft Access databases. These are basically mini applications to solve specific client issues. The GoDaddy new tier 2 folks tell me they do not support Access databases. I find this unbelievable but my crashing code tells me they are right. The Plesk control panel does have an option to create an ODBC connection for an Access Database but it doesn't work. If you want to run an access database - GoDaddy is not an option. I suspect there are folks in this community that have connected to an access database and know how to do it, but the GoDaddy folks do not know how. I am going back to Web.com