Update data in a client machine

  • Thread starter Thread starter Juande
  • Start date Start date
J

Juande

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
 
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
 
Thanks, but VB .NET cannot create ActiveX Controls, Is there any similar way
to create a control like ActiveX in .Net?
Many thanks
 
Is there any similar way to create a control like ActiveX in .Net?

No, because .Net objects run *at the server*.
ActiveX objects run client-side.



Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================
 
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.
 
Ok. Please share with us what you find.

Eliyahu

Juande said:
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.
Click to expand...
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Migrate IMAP Email to Office 365 Easily 1
Best tool to recover PST files in 2026 1
What are the steps to fix damaged MDF files in SQL Server? 0
Mail clients with servers? 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Which is the best MBOX Converter Tool different formats conversion? 5
How to Export Gmail Emails to PST Format? 6
Insert or Save file into SQL Server Database Table with C# Examplesand VB.Net Examples 0

Back
Top