You can upload your Access datafile (.mdb) to the site. But you will need to configure your site with a DataSourceName (ask your host about that), and this will ONLY work if you are hosted on a WINDOWS server, I believe - are you?
Sorry Im good with building websites but really don't know the lingo.
My host is Go Daddy they said they needed to switch me to a different server, then it would alow me to use access.
So have you switched? As I said, I think you need to be on a Windows server to use Access. That would be the first step in this process. Also, you'll need to be using ASP as well.
Is there a good reason why you want to use ASP/Access and not something more robust and contemporary like PHP/MySQL?
I'm just used to using Access. I really don't feel like reinventing the wheel right now
You'll find that MS Access is hardly ever used on websites. It's OK for local use on a PC but that's about it.
MySQL databases and PHP webpages on Linux servers is far more common.
could I ask for what reason
Lots of reasons.
- It's not robust-doesn't scale for more than a few simultaneous users
- It corrupts easily making it unreliable
- Needs Windows servers (Linux are more widely used)
- It's really a tool for PC users to start learning databases and most have MS Office installed (thus have access to Access). It's OK for that.
- It's a paid-for proprietary Microsoft product. The web is often averse to single vendor closed technologies.
- Lots more...
or Google "microsoft access limitations"