Dynamically Linking front end & back end

[bloody_football]

I had posted this in another area but didn't receive a response and my whole project has ground to a halt until I sort this out

I have made a database with front and back ends. Now I wish to be able to use the front end over the Internet but the IP address of the back end keeps changing weekly because of my ISP.
Now I have made a splash screen at the start of the program which asks for the IP address and when this is entered the front end links to the back end - but I can't get the code right for this

The code I have at the moment is embarrasingly wrong so I'm not putting it up here

The code I have at the moment has a box that asks for user to enter the IP address - I need it to use the IP address to enter the database at ip//data.mdb

Regards, James

 

[Meltdown]

You can't use an Access front-end over the internet. The only thing you can connect with are the Tables of data in the database, not forms or reports. You need to write ASP or ASP.net scripts to edit/update/delete the data.

Each ASP file usually has an include file called strconnect.asp which has the connection string for the database on the file server, no need to keep updating IP's.

You can also use Data Access Pages(DAP's), but they require each end user to have MS Office XP installed, so it's not really viable over the internet.

One final idea, you can get programs that allow remote access to a PC, Laplink, Remote Anywhere, check them out.

 

[bloody_football]

Thanks Meltdown, I'll read up on a few of those suggestions

 

[ets960]

Instead of checking the ip address every time you want to connect, try setting up a dynamic IP address...

www.dyndns.com gives you many options. You can download and install a program on your computer that checks the ip address and will change it automatically, and many home routers give you these options now-a-days.

Thats just to make things a bit easier.