Avatar billede jind Nybegynder
23. april 2007 - 09:13 Der er 18 kommentarer og
1 løsning

Hente backend fra www hvis opdateringer

Hej Gæve Folk,
Jeg skal opdatere en backend fra www ved klik på en knap i frontend.
Nogen der ved hvordan man gør det?
Avatar billede terry Ekspert
23. april 2007 - 12:10 #1
as far as I know you cant
Avatar billede terry Ekspert
23. april 2007 - 12:12 #2
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
Avatar billede terry Ekspert
29. maj 2007 - 10:11 #3
status?
Avatar billede jind Nybegynder
29. maj 2007 - 12:23 #4
Status - er at jeg ikke kunne finde ud af ASP. Du har vel ikke en nem løsning herpå?
Avatar billede terry Ekspert
29. maj 2007 - 12:43 #5
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?
Avatar billede jind Nybegynder
29. maj 2007 - 23:36 #6
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.
Avatar billede terry Ekspert
30. maj 2007 - 18:53 #7
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
Avatar billede jind Nybegynder
30. maj 2007 - 21:47 #8
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?
Avatar billede terry Ekspert
31. maj 2007 - 19:56 #9
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!!
Avatar billede jind Nybegynder
01. juni 2007 - 08:10 #10
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.
Avatar billede terry Ekspert
01. juni 2007 - 12:04 #11
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?
Avatar billede jind Nybegynder
01. juni 2007 - 20:27 #12
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.
Avatar billede terry Ekspert
01. juni 2007 - 21:04 #13
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
Avatar billede jind Nybegynder
01. juni 2007 - 21:22 #14
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...
Avatar billede terry Ekspert
02. juni 2007 - 11:05 #15
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.
Avatar billede jind Nybegynder
02. juni 2007 - 21:37 #16
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.
Avatar billede terry Ekspert
12. juni 2007 - 09:50 #17
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.)
Avatar billede jind Nybegynder
12. juni 2007 - 11:33 #18
Er der en smart måde at lave det automatisk på? Jeg tænker her på FTP - og Access
Avatar billede terry Ekspert
12. juni 2007 - 12:35 #19
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.
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester