auto compact on close

[Galaxiom]

VPN is not a viable option for using an Access app over the web. It will be too slow but Citrix and RDP are excellent options and are unlikely to require any application changes.

I think that need to be explained. While using a VPN to connect a local client running an Access front end to a back end on a server would not be ideal, there is nothing inherently wrong with using a VPN.

Connecting to a server with RDP via a VPN works fine. What matters is keeping the front and back ends on the same LAN.

 

[Andy74]

Andy and Boer - congratulations on creating what sounds like excellent systems.

The only other thing I would add is I like rolling backups for my development copy. So I can click a shortcut on my desktop and it will give a backup as for that second or minute. I have only had a development copy of access break on me a couple of times in 15 years.

I would echo everyone else - I haven't come close to reaching the limit of the front end MS Access for storing forms and objects. The limit is something like 32k of objects or 2gb - I think my biggest application after 15 years of development has maybe 1000 objects which is about 100mb (no data).

Thank you Lightwave, I must also say that this forum helped me a lot. Maybe I didn't make many posts but just because most of the answers were already there

 

[Andy74]

I think that need to be explained. While using a VPN to connect a local client running an Access front end to a back end on a server would not be ideal, there is nothing inherently wrong with using a VPN.

Connecting to a server with RDP via a VPN works fine. What matters is keeping the front and back ends on the same LAN.

In fact at the beginning I tried to work (I mean as a "user") remotely like that, i.e. with the Access running on my laptop and pulling the data through VPN from the tables in the company LAN: but it had decent speed only with very small tables exactly as said: possible but impractical. Then our IT manager suggested me RDP and it worked as a charm and in fact they are in the same LAN. Since then working remotely is very efficient for my users (which includes myself). I actually asked for another terminal server with a full Access installed on it only for myself: on this I occasionally make some devolopment remotely with full access to the linked tables and maybe pubblish an update of the app remotely.

 

[boerbende]

In fact at the beginning I tried to work (I mean as a "user") remotely like that, i.e. with the Access running on my laptop and pulling the data through VPN from the tables in the company LAN: but it had decent speed only with very small tables exactly as said: possible but impractical. Then our IT manager suggested me RDP and it worked as a charm and in fact they are in the same LAN. Since then working remotely is very efficient for my users (which includes myself). I actually asked for another terminal server with a full Access installed on it only for myself: on this I occasionally make some devolopment remotely with full access to the linked tables and maybe pubblish an update of the app remotely.

In my company the VPN was adviced, so I created a RDP solution myself, ending up with a private development server in our building which I use with teamviewer.
So my compliments to your IT-manager! Good IT support is worth gold (still searching for it myself)