That's not a Java issue, try one of the Apache forums. Veni, vidi, abiit domum

r_mohd wrote: and data file and log file lying on pen drive. And you can go into SQL Server Management Studio and create a database using that drive? On your box? Notice that has nothing to do with your application. It is just a test to insure that SQL server accepts that.

Script out your database and recreate it in SQL 2005 by running the script. Then import the data. I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! If you like cars, check out the Booger Mobile blog | If you feel generous - make a donation to Camp Quality!!

Are your COM objects being cleaned up properly? You need to use Marshal.ReleaseComObject to release all of the resources that are allocated when using the Excel interop classes. See this[^] thread for details (code is in C# but same principal applies). r_mohd wrote: it is working very fine, but Thanks, it always makes me chuckle when people say "It works fine but . . .". If there's a but then it isn't working fine, is it? :-D :badger:

Thanks for reply, Kindly suggestexample codes. Thanks rmshah Developer

There are way too many factors to give you a decent answer without some more details. If all you need is security for the payroll administrator then the built in fingerprint reader on lots of laptops might be OK (although not as secure as you might think). But if your requirement is not just for indentification but also a time clock system then that means an entirely different class of devices. The last biometric system I worked with was used for bus drivers to clock in and out. They had gone with a relatively cheap system and then ran into lots of issues. The hardware was not very tough, and did not stand up well to the 130 degree temperatures and exhaust fumes encountered in the bus garage. They also had problems because the fingerprint reader didn't have a good contrast range and therefore had difficulty reading a wide variety of skin tones.

To put it simply you don't display an Excel file in a RichTextBox, this control is really only designed to display RTF and plain text files. I think your best option would be to invest in a 3rd party control designed to display Excel files such as those from Spreadsheet Gear[^].

As Christian said, Gmail does not accept EXE files as attachments (not even inside a ZIP); however it suffices to modify the file extension to say EXE2. I trust some other mail systems have the same policy. :) Luc Pattyn Local announcement (Antwerp region): Lange Wapper? Neen!

r_mohd wrote: execute ('insert into ' + @tb +'(xname)values(@name)') That's a poor practice. Your code is open to SQL injection attacks. You need read SQL Injection Attacks and Some Tips on How to Prevent Them[^]. Navaneeth How to use google | Ask smart questions

you can not connect to windows application remotely, unless it is a client/server application. Even with that, only you can interact to the server from the client. You can connect to a remote machine then use the application. but this has nothing to do with application. There are several ways you can connect to remote machine, Remote Desktop, Terminal Services and connection over the web. r_mohd wrote: i have an internet connection having speed upto 256 kbps. This is low speed to connect and work remotely. ɟnsnʎ ʎlʇuǝƃıllǝʇuı uoıʇsǝnb ɐ ʞsɐ oʇ ʍoɥ [^]

Well, thats not going to work as you overwrite the database on the home pc with the one from the office pc, so you lose the work done on the home pc. One way is to add columns to your tables with the update time and action (add/change/delete) and use that those determine which records to update on the other system. Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

Firstly it is not very clear what it is that you want to do. Nor is there any mention of what errors or results, if any, you are getting when you try the SQL statements you have shown in your post. However, one thing springs to mind, given that you mention grouping. Have you looked at the GROUP BY clause of SQL? Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

DO NOT HIJACK SOMEONE ELSE'S THREAD. There is an overload for the Show and ShowDialog methods that takes a Form object. This is should be the parent form that is going to own the child form. Just pass the parent form in as the parent and it should take care of the problem. Dim newForm As New MyNewDialogForm newForm.ShowDialog(Me) A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

PIEBALDconsult wrote: That's a big reason not to use stored procedures. Not really. The user can just as easily go in and update the tables without. PIEBALDconsult wrote: At best you could have a written agreement that clearly states what happens when they screw up the system. Thats a more common way. At the end of the day, if the database is on your clients server, there is very little you can do to stop them screwing it up, so having a good, watertight, written agreement of responsibilities is probably the best way - if they are fully aware of the consequences then they probably won't. Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

Since you're using trusted connection, do you belong to a windows group that has access to that SQL Server and to that database or do you have that access granted to you personally? Now it seems that you're not granted the access so SQL Server uses Guest account which then again doesn't have access to the SQL Server instance. The need to optimize rises from a bad design.My articles[^]

You don't actually use same database file. You install SQL Server on a computer, place your database in the SQL Server and applications will connect to the SQL Server (not the database file) using SqlConnection. For connection refer to: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.aspx[^] The need to optimize rises from a bad design.My articles[^]

As Rob pointed out, SQL Server Express Edition is not designed for this. However, you could have a look at SQL Server Compact Edition (SSCE) if it suits your needs better. Here's one article to start with: Data Storage Architecture with SQL Server 2005 Compact Edition[^] The need to optimize rises from a bad design. My articles[^]

ya i tried the one you shown it's working fine to me!! thanks mate ;) ZAK