473,513 Members | 2,601 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Update data in a client machine

Hello,

I have a main page where the user log in to access to the data in SQL
Server, the selected data by the user will be exported in a .MDB file into
the server, I want that generated file keeps into client's machine and then
update the local user's data (SQL Server too) with this file, any ideas?,
How can I do it in a way totally transparent for the user?

Many thanks
Nov 19 '05 #1
5 1172
In no way. You will have to either ask the user to download the file or
write your ActiveX and ask the user to install it.

Eliyahu

"Juande" <a@b.com> wrote in message
news:e0**************@TK2MSFTNGP14.phx.gbl...
Hello,

I have a main page where the user log in to access to the data in SQL
Server, the selected data by the user will be exported in a .MDB file into
the server, I want that generated file keeps into client's machine and then update the local user's data (SQL Server too) with this file, any ideas?,
How can I do it in a way totally transparent for the user?

Many thanks

Nov 19 '05 #2
Thanks, but VB .NET cannot create ActiveX Controls, Is there any similar way
to create a control like ActiveX in .Net?
Many thanks
"Eliyahu Goldin" <re*************@monarchmed.com> escribió en el mensaje
news:uX*************@TK2MSFTNGP15.phx.gbl...
In no way. You will have to either ask the user to download the file or
write your ActiveX and ask the user to install it.

Eliyahu

"Juande" <a@b.com> wrote in message
news:e0**************@TK2MSFTNGP14.phx.gbl...
Hello,

I have a main page where the user log in to access to the data in SQL
Server, the selected data by the user will be exported in a .MDB file
into
the server, I want that generated file keeps into client's machine and

then
update the local user's data (SQL Server too) with this file, any
ideas?,
How can I do it in a way totally transparent for the user?

Many thanks


Nov 19 '05 #3
Ok. Please share with us what you find.

Eliyahu

"Juande" <a@b.com> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...
Still I don't believe that no exists a way to do it (Update data in the
client), I have seen software that does, so I will continue looking for a
solution, Thanks.

"Juande" <a@b.com> escribió en el mensaje
news:e0**************@TK2MSFTNGP14.phx.gbl...
Hello,

I have a main page where the user log in to access to the data in SQL
Server, the selected data by the user will be exported in a .MDB file into the server, I want that generated file keeps into client's machine and
then update the local user's data (SQL Server too) with this file, any
ideas?, How can I do it in a way totally transparent for the user?

Many thanks


Nov 19 '05 #4
MS Access databases can be exported / imported via a SQL Server DTS package.
Your web page is simply the mechanism for excuting this package, perhaps
with parameters to specify the range of data to be selected. Export to a
folder accessable by your web application and have the user open it via a
link. Once the user has finished editing the database, they can then submit
back to the web server via a provided upload control. A server side event
can then execute the package to re-import the data into SQL Server.

"Juande" <a@b.com> wrote in message
news:e0**************@TK2MSFTNGP14.phx.gbl...
Hello,

I have a main page where the user log in to access to the data in SQL
Server, the selected data by the user will be exported in a .MDB file into
the server, I want that generated file keeps into client's machine and then update the local user's data (SQL Server too) with this file, any ideas?,
How can I do it in a way totally transparent for the user?

Many thanks

Nov 19 '05 #5
Yes, you can create .NET controls...

Patrice

--

"Juande" <a@b.com> a écrit dans le message de
news:OG*************@TK2MSFTNGP09.phx.gbl...
Thanks, but VB .NET cannot create ActiveX Controls, Is there any similar way to create a control like ActiveX in .Net?
Many thanks
"Eliyahu Goldin" <re*************@monarchmed.com> escribió en el mensaje
news:uX*************@TK2MSFTNGP15.phx.gbl...
In no way. You will have to either ask the user to download the file or
write your ActiveX and ask the user to install it.

Eliyahu

"Juande" <a@b.com> wrote in message
news:e0**************@TK2MSFTNGP14.phx.gbl...
Hello,

I have a main page where the user log in to access to the data in SQL
Server, the selected data by the user will be exported in a .MDB file
into
the server, I want that generated file keeps into client's machine and

then
update the local user's data (SQL Server too) with this file, any
ideas?,
How can I do it in a way totally transparent for the user?

Many thanks



Nov 19 '05 #6

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

Similar topics

16
16975
by: Philip Boonzaaier | last post by:
I want to be able to generate SQL statements that will go through a list of data, effectively row by row, enquire on the database if this exists in the selected table- If it exists, then the colums...
14
3470
by: Jonny | last post by:
Hey all, Just a query, How does WUS (Windows Update Service) work? How does it identify what patches to install, and what are not valid patches for OS/Software Installed?? I know this isn't...
17
2714
by: Zvi Danovich | last post by:
Hi, I am a newby in ASP.NET, and till now wrote only simple "classic" WEB-sites. But - the time came, and now I need that: 1. Server will "listen" for some events on its local machine 2....
4
3382
by: Jim Hammond | last post by:
It would be udeful to be able to get the current on-screen values from a FormView that is databound to an ObjectDataSource by using a callback instead of a postback. For example: public void...
1
1102
by: kot13 | last post by:
The application (Vb.net+WindowsForms+SQL server(MSDE)) has been installed on client machine from CD. What is the best (secure and reliable in troubleshooting) architecture to update the client...
34
10766
by: Jeff | last post by:
For years I have been using VBA extensively for updating data to tables after processing. By this I mean if I had to do some intensive processing that resulted in data in temp tables, I would have...
1
1364
by: Sangra.Raman | last post by:
Hi I am using Updater Application BLock 2 for .NET 1.1 The problem I am having is running it on client machines. This is the scenario, I used one of the Quick starts Sample App you get when...
1
1436
by: CptDondo | last post by:
OK, let me explain what I am trying to do. I have an embedded PC that runs a httpd+php server and controls a machine. I have a browser front end that provides the HMI (human machine interface)...
8
1622
by: Irfan | last post by:
hi, I created a setup file using the Publish Wizard in Visual Studio 2005 and installed the software in the client machine. Now I want to update some of the installed files in the client...
0
7259
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7158
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7535
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7098
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7523
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5683
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
3232
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
1
798
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
455
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.