Re: Offline application for reporting and collect data

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Ken/All,
Thanks for the update man. That is very interesting stuff. But
what I plan is giving an installer to the client that will install the
Application and the database needed for it(incase of MDB i can load the
MDB with tables). But as far as I have worked with SQL, first we need
to install SQL server and restore the database backup in the system. So
the user has to install the SQL compact and then has to do a backup of
the database! Can I do this also in the installer?? (I preferred ACCESS
just to short cut this procedure as I cannot force the user to install
a lot)

Thanks and Regards
Senthil


Ken Tucker [MVP] wrote:

Hi,

Take a look at the sql compact edition now in release canidate.
Sql Compact edition has some nice features for sync with sql server. It
should be out by the end of the year.

http://blogs.msdn.com/stevelasker/archive/2006/11/07/sql-server-compact-edition-rc1-released.aspx

http://blogs.msdn.com/stevelasker/archive/2006/04/10/SqlEverywhereInfo.aspx

http://blogs.msdn.com/stevelasker/archive/2006/05/02/SqleCodeSnipetts.aspx

Ken
-----------------------
"Senthil" <senthildekumar@xxxxxxxxx> wrote in message
news:1164972309.633379.215630@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi All
We are having a VB application on SQL. But we need to collect
information from persons who will be offline to verify data and insert
new data. Generally they will be entering the data in Excel spread
sheets which can be uploaded to the database using the application
after some validations.

But rather than Excel I was looking at Infopath with Access as the
database, to create validation rules and collect data offline that can
be submitted at a later stage when the user is back online. But the
reporting tool is not serving the purpose.
Rather Can i build a VB.Net application that comes with Access data
base embedded in it in the installer so that even when the user is
offline we can get him the reports and enable him to update or enter
new data through the grids?? And later we can easily gather the data to
SQL by just importing using DTS.
Or is there any other better approach? Please advice.

Thanks
Senthil


.

Quantcast