Database

Long time since I used Access so this may not apply. When backups were done we always did a compact of the database (it's a menu choice IIRC). In a similar situation to what you describe never had any real problems with Access in 5 years or so. The front end was VB6 and the back end was just tables and queries on the server. So may be something in your set up you can tweak. However, I'd support the suggestion of looking at SQL Server Express. I've had a little experience with MySQL (on Linux) and found no problems with it. So I would not rule it out completely. I think however that SSE is probably a better bet. There are others like SQLite around(though I don't think that's appropriate for what you describe) so may be worth investigating. Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis The only valid measurement of code quality: WTFs/minute.

Wat :-D All the best, Dan

Looks like it's working. Thanks. Won't know for sure, though, until it finishes...if it does. Started it a little over three hours ago and it began delivering the goods about two hours after that. Oh...did I forget to mention this $%^$@#! table has over 177 million rows in it? And I expect the result to be in the neighborhood of 3 million? Hopefully, it will finish before I go home this afternoon. Otherwise, pfft! "Night Watchman" will come along at 3 a.m. and shut off my computer and I'll have to start all over again in the morning. :laugh: EDIT: :laugh: :laugh: :laugh: It finished. And, as soon as I clicked on the result to try to copy it, BOOM! 'So sorry. We've run out of virtual memory and have to close. Hope you weren't working on anything too terribly important'. Or words to that effect. No dogs or cats are in the classroom. My Mu[sic] My Films My Windows Programs, etc.

My pleasure, and you're welcome :)

thank u so much.

No, there cannot be. It just means rows between the two tables with the same value in the 'joined' columns. So the order in which the table names are mentioned doesn't matter. However, for Right and Left joins, it does matter.

Thanks I think you undrestood I mean may I ask more questions do you know any programs of Hierarchical,network and flat(data models)

I know, I had to think very carefully about that one. This query used to work but only because it was a bug (in other words you thought it was good, but in fact we knew it was bad), so we fixed the bug and now your query doesn't work anymore (which you may think is bad, but really it's not, because we know it's good). If I follow the argument correctly, it has something to do with ANSI standards: you should not be able to do this in ANSI-standard SQL. So in order for Oracle to be ANSI-standard, they had to stop you from doing this. I think that's the reason.

As a caveat on Shameels comment, if you have a small number of records and each record is large (image file) then xml may be valid. You imply you have a huge image set to manage. You really should look into strategies of image storage there are quite a number of options. Never underestimate the power of human stupidity RAH

Did you try below link as well: http://social.msdn.microsoft.com/Forums/eu/sqldataaccess/thread/a262abdf-4516-45c6-8065-8203ca29977f[^] regards, vatsa www.objectiveprogramming.com

Did you even bother to search? check this[^]

Yes... We are using a standard Stored Procedure as sendmail function. ALTER PROCEDURE [dbo].[sendmail_subsc] @to varchar(200), @copy varchar(200)=null, @bcc varchar(200)=null, @replyto varchar(200)=null, @from varchar(200), @subject varchar(200), @body text, @filename varchar(255)=null AS Declare @iMsg int Declare @hr int --************* Create the CDO.Message Object ************************ EXEC @hr = sp_OACreate 'CDO.Message', @iMsg OUT -- This is to configure a remote SMTP server. EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/sendusing").Value','2' -- This is to configure the Server Name or IP address. EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/smtpserver").Value', 'our smtp server' -- Save the configurations to the message object. EXEC @hr = sp_OAMethod @iMsg, 'Configuration.Fields.Update', null -- Set the e-mail parameters. EXEC @hr = sp_OASetProperty @iMsg, 'To', @To IF @copy IS NOT NULL BEGIN EXEC @hr = sp_OASetProperty @iMsg, 'Cc', @copy END IF @bcc IS NOT NULL BEGIN EXEC @hr = sp_OASetProperty @iMsg, 'Bcc', @bcc END IF @replyto IS NOT NULL BEGIN EXEC @hr = sp_OASetProperty @iMsg, 'ReplyTo', @replyto END EXEC @hr = sp_OASetProperty @iMsg, 'From', @from EXEC @hr = sp_OASetProperty @iMsg, 'Subject', @Subject EXEC @hr = sp_OASetProperty @iMsg, 'HTMLBody', @Body IF @filename IS NOT NULL BEGIN EXEC @hr = sp_OAMethod @iMsg, 'AddAttachment', null, @filename END -- Send mail EXEC @hr = sp_OAMethod @iMsg, 'Send', NULL -- Destry object EXEC @hr=sp_OADestroy @iMsg and the error message we get is that in this procedure the destroy object fails at one point in time and then crashed the whole server. (buffer issue?) here is the error log from the server: 2011-12-28 02:00:51.25 spid55 Stack Signature for the dump is 0x000000015B32F370 2011-12-28 02:00:52.24 spid55 External dump process return code 0x20000001.External dump process returned no errors. 2011-12-28 02:00:52.26 spid55 Using 'dbghelp.dll' version '4.0.5' 2011-12-28 02:00:53.36 spid55 ***Stack Dump being sent to E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump10000.txt 2011-12-28 02:00:53.36 spid55 SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2011-12-28 02:00:53.36 spid55

This[^] will help.

There is no other documentation. I want the documentation for the database, the only area of the application that my client will be able to easily understand, to be the definitive documentation.

As well as SqlCE, there is SQLite[^], which is also a file based db system. I have used this in the exact same scenario which you have related. SQLite has a fully functional ADO.Net implementation[^], and can be embedded in the application if necessary, which means less install hassles. It is also open source, with the source code in the public domain. When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman

Thank for your information Socheat

esProc can solve this problem easily. It is just like Excel+SQL, a free tool, see: A Query Language Over-perform SQL [^]. code as below: A1: =sqlsvr.query("select Name,Dates,[Outstanding Values] from test_table order by Name,Dates") A2: =A1.derive(:Difference) A3: =A2.group(Name) A4: =A3.(~.run(Difference='Outstanding Values'-'Outstanding Values'[-1])) I can't post a image file,so here are some explains: A1 cell:query some data from database. A2 cell:add a column to A1, named "Difference", just no data. A3 cell:group the data by field "Name" in A2 cell. Here are 3 groups, A4 cell:within every group(i.e. "~"), modify the field "Difference". The algorithm is: "this row" subtract "last row"(i.e. 'Outstanding Values'[-1]) I think esProc is more simple for mass data computation BTW. how to post a image file?

It probably still is xBase. The dinosaur I slayed was written in dbIII+ in about 1988 and ran on DOS. Some of the later ones probably had a real GUI. Cheers, Peter Software rusts. Simon Stephenson, ca 1994.

How about using the Hashtotal or checksum concept and if the two rows are different, then write them out to 2 different text files (FileA & FileB). At the end of the process, you could use a tool like BeyondCompare to compare the data in the two files. Just a thought. Awesome tool to have in your bag of tricks ... http://www.scootersoftware.com/[^]

your queary is like this... insert into tbTasks_New( AssignedToId) values('Employee') where Owner = 'Seema' and your solution will be like this...! Update tbTasks_New set='Employee' where Owner='Seema' ----------------------------------- Actually u have to use update statment insted of insert statment...! and then u will get ur expected output.! Dnyanesh Wahiley....