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 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
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
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
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
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
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...
|
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...
|
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....
|
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...
|
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...
| |
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...
|
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...
|
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)...
|
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...
|
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,...
|
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...
| |
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...
|
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...
|
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...
|
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,...
|
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...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |