I could really use your help....

Is it possible to have an Access database locally and then synchronize
it with another Access database residing on a web server...?

I have a scenario where a client makes all the changes locally (on his
pc) and then wants to synchronize the changed records with the database
on the web server.

Is this possible? And if so, how?

The only way I can think of is installing pws or iis on client machine
and create a set of ASP pages to delete remote set of tables and then
copy it again. Is there a better way?

Thank you all.

PauloF

Paulo--how about using remote scripting and updating the databases at the
same time?  The process of updating the one over the Internet would happen
behind the scenes and would not be something the user would be aware of.  At
the same time, he would see his data locally without the wait of server side
updates.

-----Original Message-----
From: Paulo Fernandes [mailto:paulofernandes@c...]
Sent: Sunday, November 17, 2002 11:48 AM
To: Access ASP
Subject: [access_asp] Syncronizing access database over the internet


I could really use your help....

Is it possible to have an Access database locally and then synchronize
it with another Access database residing on a web server...?

I have a scenario where a client makes all the changes locally (on his
pc) and then wants to synchronize the changed records with the database
on the web server.

Is this possible? And if so, how?

The only way I can think of is installing pws or iis on client machine
and create a set of ASP pages to delete remote set of tables and then
copy it again. Is there a better way?

Thank you all.

PauloF

Karri,

Can you explain me your idea a little bit better? I've never done remote
scripting.... (at least knowing this would be the name for it!!).

Thanks in advance.

PauloF

-----Original Message-----
From: Karri Peterson [mailto:KPeterson@C...] 
Sent: domingo, 17 de Novembro de 2002 17:49
To: Access ASP
Subject: [access_asp] RE: Syncronizing access database over the internet

Paulo--how about using remote scripting and updating the databases at
the
same time?  The process of updating the one over the Internet would
happen
behind the scenes and would not be something the user would be aware of.
At
the same time, he would see his data locally without the wait of server
side
updates.

-----Original Message-----
From: Paulo Fernandes [mailto:paulofernandes@c...]
Sent: Sunday, November 17, 2002 11:48 AM
To: Access ASP
Subject: [access_asp] Syncronizing access database over the internet


I could really use your help....

Is it possible to have an Access database locally and then synchronize
it with another Access database residing on a web server...?

I have a scenario where a client makes all the changes locally (on his
pc) and then wants to synchronize the changed records with the database
on the web server.

Is this possible? And if so, how?

The only way I can think of is installing pws or iis on client machine
and create a set of ASP pages to delete remote set of tables and then
copy it again. Is there a better way?

Thank you all.

PauloF

Well, ok, let's talk about the architecture of what you are building for
starters.  

1)  I don't think that you would need pws or iis on the client side if you
used this.  You would have client side script making the updates to the
database, but server-side, you would have asp writing to the server side
database.  

2)  Here is an excerpt from msdn.microsoft.com/scripting about remote
scripting.  The link address is 
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rmscpt/Html
/rmscpt.asp  and will tell you how remote scripting works.  It tells you how
to do it step by step.  If you do the stuff they tell you to do here, if you
are having problems with a weird error message, you can email the list
again, and if I am online, I'll help you a little. It's not really difficult
though, if you already know asp and dhtml.  By the way , it relies on an
applet, so I believe it can be used in Netscape as well--I haven't tried
that tho.

Using Remote Scripting
Remote scripting gives you the ability in Web applications to combine two
scripting platforms in one page. You can create client script to control an
application's user interface and, if you are working with Microsoft Internet
Explorer 4.0, to take advantage of the powerful features of Dynamic HTML
(DHTML). At the same time, you can run script on your server to perform
server-side tasks, including database queries, middle-tier business logic,
and so on. Because remote scripting runs on the server while the client page
is still active, your scripts are greatly simplified and the application can
present a richer, more responsive interface to the user.

The following topics provide details about remote scripting.

For information about See 
What remote scripting is and how it works Executing Server Script Remotely 
How to set up your pages for remote scripting Enabling Remote Scripting in
Client Pages and Enabling Remote Scripting in Server Pages 
Creating an object reference that you can use to invoke server script
methods. Referencing ASP Pages as Objects 
How to make remote scripting calls Calling Remote Scripting Methods
Synchronously and Calling Remote Scripting Methods Asynchronously 
Troubleshoot remote scripting calls Checking for Errors 
Methods and objects used for remote scripting Remote Scripting Reference 

-----Original Message-----
From: Paulo Fernandes [mailto:paulofernandes@c...]
Sent: Sunday, November 17, 2002 12:35 PM
To: Access ASP
Subject: [access_asp] RE: Syncronizing access database over the internet


Karri,

Can you explain me your idea a little bit better? I've never done remote
scripting.... (at least knowing this would be the name for it!!).

Thanks in advance.

PauloF

-----Original Message-----
From: Karri Peterson [mailto:KPeterson@C...] 
Sent: domingo, 17 de Novembro de 2002 17:49
To: Access ASP
Subject: [access_asp] RE: Syncronizing access database over the internet

Paulo--how about using remote scripting and updating the databases at
the
same time?  The process of updating the one over the Internet would
happen
behind the scenes and would not be something the user would be aware of.
At
the same time, he would see his data locally without the wait of server
side
updates.

-----Original Message-----
From: Paulo Fernandes [mailto:paulofernandes@c...]
Sent: Sunday, November 17, 2002 11:48 AM
To: Access ASP
Subject: [access_asp] Syncronizing access database over the internet


I could really use your help....

Is it possible to have an Access database locally and then synchronize
it with another Access database residing on a web server...?

I have a scenario where a client makes all the changes locally (on his
pc) and then wants to synchronize the changed records with the database
on the web server.

Is this possible? And if so, how?

The only way I can think of is installing pws or iis on client machine
and create a set of ASP pages to delete remote set of tables and then
copy it again. Is there a better way?

Thank you all.

PauloF

Karri,

You are running a remote scripting project out of a local Access
application?  Do you have a simple example that you could upload?

Thanks.

Larry Woods


> -----Original Message-----
> From: Karri Peterson [mailto:KPeterson@C...]
> Sent: Sunday, November 17, 2002 11:41 AM
> To: Access ASP
> Subject: [access_asp] RE: Syncronizing access database
> over the intern
> et
>
>
> Well, ok, let's talk about the architecture of what
> you are building for
> starters.
>
........etc.>

You guys, I am really sorry, but I am busier than heck right now.  I can't
help you--so sorry.  Can someone else give them a lift?

-----Original Message-----
From: Larry Woods [mailto:larry@l...]
Sent: Sunday, November 17, 2002 1:45 PM
To: Access ASP
Cc: KPeterson@C...
Subject: [access_asp] RE: Syncronizing access database over the intern
et


Karri,

You are running a remote scripting project out of a local Access
application?  Do you have a simple example that you could upload?

Thanks.

Larry Woods


> -----Original Message-----
> From: Karri Peterson [mailto:KPeterson@C...]
> Sent: Sunday, November 17, 2002 11:41 AM
> To: Access ASP
> Subject: [access_asp] RE: Syncronizing access database
> over the intern
> et
>
>
> Well, ok, let's talk about the architecture of what
> you are building for
> starters.
>
........etc.>

Karri,

Just one quick question and I'll leave you alone.

You ARE running the "client" side of the remote script out of
Access, right?

Larry Woods


> -----Original Message-----
> From: Karri Peterson [mailto:KPeterson@C...]
> Sent: Monday, November 18, 2002 9:36 AM
> To: Access ASP
> Subject: [access_asp] RE: Syncronizing access database
> over the intern
> et
>
>
> You guys, I am really sorry, but I am busier than heck
> right now.  I can't
> help you--so sorry.  Can someone else give them a lift?
>
> -----Original Message-----
> From: Larry Woods [mailto:larry@l...]
> Sent: Sunday, November 17, 2002 1:45 PM
> To: Access ASP
> Cc: KPeterson@C...
> Subject: [access_asp] RE: Syncronizing access database
> over the intern
> et
>
>
> Karri,
>
> You are running a remote scripting project out of a
> local Access
> application?  Do you have a simple example that you
> could upload?
>
> Thanks.
>
> Larry Woods
>
>
> > -----Original Message-----
> > From: Karri Peterson [mailto:KPeterson@C...]
> > Sent: Sunday, November 17, 2002 11:41 AM
> > To: Access ASP
> > Subject: [access_asp] RE: Syncronizing access database
> > over the intern
> > et
> >
> >
> > Well, ok, let's talk about the architecture of what
> > you are building for
> > starters.
> >
> ........etc.>
>
>
>