Hi 



I have some nice asp pages which are based on a access db. I work remotely 

so fp publish to the site which has the extensions installed on server. I 

have created some db forms within the access db so the company can add new 

news items but these do not appear on the pages when they are saved. But 

if I add new data and then publish to the site there they are? If I ftp 

the db to the site they appear also? 



Any thoughts 

andrew

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

: I have some nice asp pages which are based on a access db. I work remotely

: so fp publish to the site which has the extensions installed on server. I

: have created some db forms within the access db so the company can add new

: news items but these do not appear on the pages when they are saved.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



What does not appear, when what is saved? Where are you saving <what>? Where

is this "new stuff" not appearing? On your development machine? or on the

server?



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

: But if I add new data and then publish to the site there they are? If I

ftp

: the db to the site they appear also?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Huh?



Cheers

Ken

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> : I have some nice asp pages which are based on a access db. I work 

remotely

> : so fp publish to the site which has the extensions installed on 

server. I

> : have created some db forms within the access db so the company can add 

new

> : news items but these do not appear on the pages when they are saved.

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> 

> What does not appear, when what is saved? Where are you saving <what>? 

Where

> is this "new stuff" not appearing? On your development machine? or on the

> server?

> 

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> : But if I add new data and then publish to the site there they are? If I

> ftp

> : the db to the site they appear also?

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> 

> Huh?

> 

> Cheers

> Ken

> 

> 



Apologies I may not have been very clear. 



I have the access db which is being opened across a network from server to 

a client pc. New data is added directly into the access db and (hopefully) 

then saved back onto the server. Unfortunately this is not happenning. So 

what we are now looking at is having 2 copies the master on a client 

machine and when new data is added this is 'dragged and dropped' onto the 

server machine effectively overwriting the server copy. When this is done 

the new data can be seen in the browser. Is this the normal method? (apart 

from online forms which seemed a bit of an overkill for a 

pressrelease/news page system). 



Thanks

Andrew

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

: I have the access db which is being opened across a

: network from server to a client pc. New data is added

: directly into the access db and (hopefully) then saved

: back onto the server. Unfortunately this is not happenning.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Is the data being saved into the database? eg if you open the database again

using Access, the new data is there?



Is it just that the new data is not appearing when viewed through the web

browser?



If so, then maybe your browser, or a proxy, is caching the webpages? You can

change the settings on the server to expire content immediately



Cheers

Ken

> 

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> : I have the access db which is being opened across a

> : network from server to a client pc. New data is added

> : directly into the access db and (hopefully) then saved

> : back onto the server. Unfortunately this is not happenning.

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> 

> Is the data being saved into the database? eg if you open the database 

again

> using Access, the new data is there?

> 

> Is it just that the new data is not appearing when viewed through the web

> browser?

> 

> If so, then maybe your browser, or a proxy, is caching the webpages? You 

can

> change the settings on the server to expire content immediately

> 

> Cheers

> Ken

> 

> 

hi



Yes the data is being saved to the database, so when opened again it is in 

the db. It just doesnt appear in the web browser but it does appear when 

the alternative approach is taken and we overwrite the db on the server 

with a new copy from the client by 'drag and drop' through window 

explorer.  Which I found a little strange. 



 It may well be in the server settings and we will look at those next. 



Thanks for your replies.



Andrew