Linking-Internet

[IP076]

I've just got a linking question if someone has a spare second. I've developed an access database that works really well, and have just decided to mess around with splitting it into a FE and BE. I understand how to link to tables in a different DB, and if I was on a Network, I'm pretty sure i could figure out how to link it to a Network Drive. What I'm having difficulty is figuring out how to link to a BE that is loaded on the web, at a web hosting site. I'd like to do it this way so that others can access the database from home. I'm looking maybe 4 or 5 users a time, max.

If anyone can give me some insight on linking to a file loaded to a web server, I'd be very happy!

Thanks in advance!

(I used the search function here, but there were limited responses, and all from a few years ago.)

 

[josephwalter]

Are you talking about using a web browser as your front end, or am I mis-understanding your question?

 

[IP076]

Nope...just use an Access Front End and Access Back End...I just want to be able to pass out the Front End to 3 or 4 people and allow them to access the Back End over the internet. Just wondering if it can be done simply, or if you need to have a web host that has SQL or MS Access Database support.

Thanks

 

[rthornto]

For years (!) I've looked for the easy answer to this question. Sorry .. there is no easy answer. I totally understand the logic of the simplicity behind what you're trying to do. But there doesn't seem to be a way to have an Access Front End on your local machine communicate (link to) an Access Back End on the Internet.

Unless you want to end up old and frustrated like me I'd have to suggest that you redo what you've done in you're Access Front End in ASP - it's really very easy. ..and yes you'll have to be on a hosting server that can handle ASp pages (there are free ones).

Sorry I couldn't be of any help .. but I really hope somone else can because I'd kill to see an answer if there is one!

 

[Pat Hartman]

If your site supports FTP you may be able to do it. Remember, Access is a file server so nothing happens on the server anyway. I can't test this out but put the db on the server and then try to link to it. You may need to drop down the "look in" box and add the FTP location if it doesn't automatically show up in your network places list.

Please let us know if this works.