Hello,
I'm trying to connect a local front-end to a remote back-end. Here's what I did:
1. Split my database into a front-end (test.accdb) and a back-end (test_be.accdb). Worked perfectly.
2. Uploaded the back-end file (test_be.accdb) to a remote server (www.mycrazytestsite.com/mypath/test_be.accdb) with Winhost (who says they support "Microsoft Access Database Hosting").
3. Then I tried to use the Link Table Manager to link my front-end to the remote back-end, but I can't figure out how to do this. It doesn't seem to allow me to point to an internet address.
Can anyone tell me if this is possible? And if so, then how to do it? I've tried creating mapped drives and data sources, but nothing seems to be working.
Thanks! Jason