473,324 Members | 2,178 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Updating a server table from a local table

My application is calculation intensive and the servers are agonizingly slow.
Administrators of my application only update the backends once a month (twice
a month max). So, my launching program allows the back-end file to be
downloaded to the user's PC. This will provide maximum speed for these
calculations/manipulations of data. Without this, just logging into the main
app connected to the server back-end file can take five minutes (normal time
is 15 seconds when linked to back-end file on PC) at some locations. They've
all been told many times that there is a possibility that the local PC data
may not be in sync with the server, but in 6 months that has never been a
problem.

This method works well and my users really appreciate the speed of data
retrieval from the local PC back-end versus the server back-end. However,
updating the server backend is still an issue. Updating can take a long,
long time in some cases and I've been struggling with how to deal with this.

At first I thought:

1) Do a forced logoff of any user connected to the server back-end (app
already has functionality for this). This will also lock everyone out until
the administrator sets that it is okay to connect to the server back-end
again.
2) Make a back-up copy of the server back-end file
3) Have the data entry person download the most current back-end file from
the server to their PC. This is so they have the most current version.
4) Data entry person updates the back-end file on their local PC.
5) Goto Windows explorer and copy the updated local PC back-end over the
server back-end.
But perhaps instead I should just include code in the application that allows
users to overwrite the server backend TABLE which has been updated with a
local PC backend TABLE (let's not talk about the situation where multiple
tables may have been updated yet), rather than copy over the whole file.
This could be a kind of synchronization process.

My users will not use the app if they are forced to always connect to the
server because it is so slow. The solution I have for downloading the
backend files periodically has been working real well. But I am struggling
with how to update the server backend files given the slow server connection.

I would greatly appreciate any comments on the scenarios I presented for
solving this or certainly if you have any other suggestions.

Thanks.

--
Message posted via http://www.accessmonster.com

Dec 13 '06 #1
4 1964
On Wed, 13 Dec 2006 00:33:11 GMT, "rdemyan via AccessMonster.com"
<u6836@uwewrote:

Tough problem. You don't shed a lot of light as to why the server is
so slow. Assuming a 100 base-T network (or get quotes for recabling)
and a server machine not more than 5 years old (or get a new one for
5K USD) and a normal network load there is simply no excuse for that.

That said, I might do async updates with the server. What if each
client machine had an app running whose task it was to take its merry
old time to update the server. This would be a background task, and
users can continue to do other things while the data continues to be
sent to the server.

Have you considered Access replication. I'm not a big fan of it, but
this may be an exception.

-Tom.
>My application is calculation intensive and the servers are agonizingly slow.
Administrators of my application only update the backends once a month (twice
a month max). So, my launching program allows the back-end file to be
downloaded to the user's PC. This will provide maximum speed for these
calculations/manipulations of data. Without this, just logging into the main
app connected to the server back-end file can take five minutes (normal time
is 15 seconds when linked to back-end file on PC) at some locations. They've
all been told many times that there is a possibility that the local PC data
may not be in sync with the server, but in 6 months that has never been a
problem.

This method works well and my users really appreciate the speed of data
retrieval from the local PC back-end versus the server back-end. However,
updating the server backend is still an issue. Updating can take a long,
long time in some cases and I've been struggling with how to deal with this.

At first I thought:

1) Do a forced logoff of any user connected to the server back-end (app
already has functionality for this). This will also lock everyone out until
the administrator sets that it is okay to connect to the server back-end
again.
2) Make a back-up copy of the server back-end file
3) Have the data entry person download the most current back-end file from
the server to their PC. This is so they have the most current version.
4) Data entry person updates the back-end file on their local PC.
5) Goto Windows explorer and copy the updated local PC back-end over the
server back-end.
But perhaps instead I should just include code in the application that allows
users to overwrite the server backend TABLE which has been updated with a
local PC backend TABLE (let's not talk about the situation where multiple
tables may have been updated yet), rather than copy over the whole file.
This could be a kind of synchronization process.

My users will not use the app if they are forced to always connect to the
server because it is so slow. The solution I have for downloading the
backend files periodically has been working real well. But I am struggling
with how to update the server backend files given the slow server connection.

I would greatly appreciate any comments on the scenarios I presented for
solving this or certainly if you have any other suggestions.

Thanks.
Dec 13 '06 #2
Tom:

It's a very highly secure network, nothing can be downloaded, users have no
admin rights (so no software installation), zip and other files are
automatically removed from emails. Need I say more?

Interesting you mention replication. I just discovered that there is such a
thing and am trying to research it. Any links on where I can learn about
what this is exactly?

Thanks.

Tom van Stiphout wrote:
>Tough problem. You don't shed a lot of light as to why the server is
so slow. Assuming a 100 base-T network (or get quotes for recabling)
and a server machine not more than 5 years old (or get a new one for
5K USD) and a normal network load there is simply no excuse for that.

That said, I might do async updates with the server. What if each
client machine had an app running whose task it was to take its merry
old time to update the server. This would be a background task, and
users can continue to do other things while the data continues to be
sent to the server.

Have you considered Access replication. I'm not a big fan of it, but
this may be an exception.

-Tom.
>>My application is calculation intensive and the servers are agonizingly slow.
Administrators of my application only update the backends once a month (twice
[quoted text clipped - 40 lines]
>>
Thanks.
--
Message posted via http://www.accessmonster.com

Dec 13 '06 #3
On Wed, 13 Dec 2006 05:11:17 GMT, "rdemyan via AccessMonster.com"
<u6836@uwewrote:

Security doesn't make it slow.

Access replication is an advanced topic and not for the faint of
heart. Check out trigeminal.com.

-Tom.

>Tom:

It's a very highly secure network, nothing can be downloaded, users have no
admin rights (so no software installation), zip and other files are
automatically removed from emails. Need I say more?

Interesting you mention replication. I just discovered that there is such a
thing and am trying to research it. Any links on where I can learn about
what this is exactly?

Thanks.

Tom van Stiphout wrote:
>>Tough problem. You don't shed a lot of light as to why the server is
so slow. Assuming a 100 base-T network (or get quotes for recabling)
and a server machine not more than 5 years old (or get a new one for
5K USD) and a normal network load there is simply no excuse for that.

That said, I might do async updates with the server. What if each
client machine had an app running whose task it was to take its merry
old time to update the server. This would be a background task, and
users can continue to do other things while the data continues to be
sent to the server.

Have you considered Access replication. I'm not a big fan of it, but
this may be an exception.

-Tom.
>>>My application is calculation intensive and the servers are agonizingly slow.
Administrators of my application only update the backends once a month (twice
[quoted text clipped - 40 lines]
>>>
Thanks.
Dec 13 '06 #4
Are you talking about a wan, or a lan?

I high speed t1 line is 100 times slower then a super cheap office netowrk.

I speak of a wan vs a lan, and its probems here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Dec 15 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Paige | last post by:
I have a database on my local machine that I make entries and corrections on. I'd like to be able to upload that to my server and have that update the database that's on the server. What I've been...
0
by: Vladimir Kanovnik | last post by:
I have table with columns id(number), photo(blob) and thumbnail(blob). I would like to insert image (using stored procedure) from file to column photo and in same time copy reduced image to column...
5
by: junglist | last post by:
Hi guys, I've been trying to implement an editable datagrid and i have been succesful up to the point where i can update my datagrid row by row. However what used to happen was that once i updated...
1
by: jason | last post by:
The guts of the below asp.net vb code was pieced together from another thread - all due credit to it's original author. Thank you! I've modified it to maintain a small local Microsoft 2000...
9
by: Mr Newbie | last post by:
HI People, Thanks to all who helped me earlier on the subject of @@IDentity. However, I seem to have hit another snagette! My DataSet contains two tables from the SQL Server. lets say Master...
14
by: el_sid | last post by:
Our developers have experienced a problem with updating Web References in Visual Studio.NET 2003. Normally, when a web service class (.asmx) is created, updating the Web Reference will...
10
by: erick-flores | last post by:
Hello all I have been trying to look for the answer to my question doing some search in the groups but no luck. I have linked a table using ODBC. Then I made a copy of the link table to my local...
3
by: John Morgan | last post by:
I have my first small SQl Server 2005 database developed on my local server and I have also its equivalent as an online database. I wish to update the local database (using and asp.net interface)...
5
by: Bill Schanks | last post by:
I have a winform app (VB 2005) that allows users to export data to excel, make updates to the excel file and import the data from that Excel file and update the database. My question is: Is it...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.