HELP! Access DB online

Hello,
I have an Access Database and I need to figure out how to have it online so that I can access and update it from any computer with an internet connection and Access 2007 installed.
PLEASE HELP ME!
Thanks
Logan

 

You won't need the Access 2007 program installed on your computer ifupdating the database programmatically. Here's sample code in ASP.NET that you can start with to connect to your Access 2007 database:

http://kb.discountasp.net/article.aspx?id=10475

The non-programmatic option is to simply download the database file via FTP, make changes with Access 2007, and reupload it.


Aristotle

DiscountASP.NET
www.DiscountASP.NET

 

With either classic ASP or the latest ASP.NET you can create pages to dialog with your Access data.
You can even add basic security.
There are lots of applications on the market that can automatically create web forms for Access databases.
At Siemens I used to use Macromedia Studio, Dreamweaver, to do this for traveling persons.
With a few clicks it writes hundreds of lines of code to connect to and modify remote data.

 

Wow that is really neat! will that allow for me to use the forms and queries that I have built into database? And I also know absolutly Nothing about programming scripts and the like, So where would I put this script u gave me? I don't even know the path to my database?
Oh and one more thing... downloading the database and then re-uploading it isn't even slightly feesable, it is 54MB and I also want to be able to have multiple users imputing data simultaneously.

Post Edited (Logan) : 2/5/2008 2:55:12 AM GMT

 

The sample script is very simple and just shows how you can query an Access 2007 database.I think what you need is to create a full ASP.NETwebuser interface for updating data, which will bea lot more involved.

I don't think the built-in forms can be accessible directly over the web. As with previous versions of Access and their data access pages, they are meant to be used within a localintranet and not across the web since it requires opening the Access file directly. I think your only option at this point is to download, open, and update method.


Aristotle

DiscountASP.NET
www.DiscountASP.NET

 

Oh Bummer! Cuz I use it here amongst several users on a local network... Is there anyway I can set it up to run over the internet, and act somewhat the same as here on the office network? I don't need the public to find it... as a matter of fact I would rather they couldn't! I just want to be able to update client files while on the road via a laptop. But I don't want to have the only copy of the database in the car with me, because I still need to let the people back in the office update it aswell!
Thank you so much for your help!
Logan

 

So does any body know of any way I canopen database remotly without downloading it and still use all the forms and queries just like in when I have it here on my local machine?

 

Via code pages.
You can create coded forms in both classic ASP and ASP.NET
To do it with ASP.NET v3.5 is the easiest.
http://www.asp.net/learn/3.5-videos/