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
5  1179 
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******** ******@TK2MSFTN GP14.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
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.co m> escribió en el mensaje
news:uX******** *****@TK2MSFTNG P15.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******** ******@TK2MSFTN GP14.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
Ok. Please share with us what you find.
Eliyahu
"Juande" <a@b.com> wrote in message
news:%2******** *******@TK2MSFT NGP10.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******** ******@TK2MSFTN GP14.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
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******** ******@TK2MSFTN GP14.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
Yes, you can create .NET controls...
Patrice
--
"Juande" <a@b.com> a écrit dans le message de
news:OG******** *****@TK2MSFTNG P09.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.co m> escribió en el mensaje
news:uX******** *****@TK2MSFTNG P15.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******** ******@TK2MSFTN GP14.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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 must be UPDATED, if not, they
must be INSERTED.
Logically then, I would like to SELECT * FROM <TABLE>
WHERE ....<Values entered here>, and then...
|
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 the proper place for this one, but i'm just checking
Thanks
--
|
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. According to event received (say - event ID), it will update client pages, that need updating based on this ID (if currently there exist clients that are...
|
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 RaiseCallbackEvent(string eventArgs)
{
// update the data object with the values currently on screen
FormView1.UpdateItem(true);
}
|
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 machine with new version
of application deployed through internet.
Update need to be done when client is sending updated data
(XML file sent through...
| | |
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 VBA code that wrote the
results of that away to the db, either creating new records or updating
existing records, whichever was relevant. This may...
|
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 you install
Application Block on your machine,
|
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) to the machine.
The machine has about a dozen status indicators; things like over-temp,
powerfail, and so on.
|
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 machine with NEW ones.
Is there anyway that it can be done automatically without i telling the user
which files to replace and which not.
Is creating...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
