Hente backend fra www hvis opdateringer

as far as I know you cant

You could make a front end in ASP or some othe application which allows you to connect to the dB on a web site but as far as I know you cant from Access

status?

Status - er at jeg ikke kunne finde ud af ASP. Du har vel ikke en nem løsning herpå?

Just to make sure I understand the question/problem.

You mention backend and frontend in your question, is this setup somthing youhave already? Normally the frontend is on your local PC and the backend will be on a file server not on a web site.

Can you give some more info?

Frontend er på PC og backend er på Server/PC.
Det jeg gerne vil - er at kunderne ved opstart af deres frontend tjekker får tjekket om der er en ny verion af frontenden.

Ah! thats an entirely different problem.

So you have a frontend on the server which you want to copy to the local PC, if it is newer than the onbe on the local PC?

Well if your prepared to pay cash then try looking at
http://www.fmsinc.com/Products/startup/index.asp

Nej - Fronend på server eller PC - det er ligegyldigt. en exefil eller script skal tjekke en webserver og få at vide om der er en nyere version - dowloaden den og overskrive eksisterende frontend..
Er du med nu?

There is a differece between a WEB server and a server (file server).


Can you be more specific as to what you want, your original question mentioned a backend!!

Ja, det er rigtigt.
Men jeg er interesseret i både at opdatere frontend og backend. BAre en af dem vil dog være et fremskridt for mig. Det er en webserver jeg skal hente frontend/backend fra.

If its on a web server I would have said that you would need to make your own system using FTP to download the files and then compare on the local PC.

I'm puzzled as to why you need to check on a web server, why cant you put the new versions on the file server?

Når du siger file server tænker jeg en server som står i den enkelte virksomhed. Hvis en file server også kan være på www - så er det fint.

I have a web site www.santhell.dk

If I place a file on the site I have to use FTP, also if I want to download a file I have to use FTP.

This site is hosted by Azero so I dont have access to the physical HD's other than through my www.santhell.dk, so I cant just copy files back and forth as though it were a HD on my PC.

I could also have a WEB server on my own PC at home and that would mean I would also have direct access to the HD's. This would allow me to map map the HD as a logical HD and access it as a normal HD and copy files to it. Those using the WEB site could NOT do this.

Does this explain the difference?


Try and explain what setup you have (in detail)

If the physi

Mit program distribueres til en masse virksomheder. Det skal så være muligt for virksomhederne at update programmet når der er ændringer i det.
Opdateringerne kan fx ligge på mit webhotel.

Håber det kan forklare det...

then it will be necessary to make something using FTP.

If the new dB is on your website then you can send them a link to the file in an email, then they can download it themselves.

Otherwise you would need to check to see if there is a file on the web site, download it, check to see if its a new version and then overwite the old. And obviously this cant be done in the Access dB because that is in use.

But what if this script was made in VB - eg. run.vb then it could check both the website and the DB?
Similar to http://www.eksperten.dk/spm/356127 but on web instead of intranet.

If you do it in VB then it makes things easier but I've never used FileSystemObject to read files from a web site so I cant say if it is possible. Furthermore looking at the script in the link you gave I think there is an error although I am not sure.
Comparing the dates using DateLastModified I am not sure if this works. When you open an Access database and close it again then the date will get changed, so there is a risk that the date of the newer file on the server (web) is older than the one in use.

A suggestion.
Use FTP to download the file from the website. In the database you have a table which contains a version number. After you download the file read the version number from each database and if they are different copy the new to the local dB (overwrite.)

Er der en smart måde at lave det automatisk på? Jeg tænker her på FTP - og Access

Here is a link http://www.mvps.org/access/modules/mdl0037.htm
It should be possible to us ethis code in VB also.

I suggest using the HTTP download.