Recent content by acteck

Possibly the following solution could be useful for others who is using SQL server Reporting Services as main Reporting Tool and Microsoft Access as front end for SQL server or even MDB. I do not think it is the most efficient way to do that, so if you have any suggestions , that would be...

It is been several days since i have uninstalled SP1! So far so good!

I have understood about command line switch /decompile. but what i meant that i found the article in Microsoft web site and it says that the reason of crashes is Microsoft Office 2010 Service Pack 1 so i am going to uninstall it and will check if problem will be resolved

i will try using decompile switch. Based on your suggestion i have looked up and found this: (apparently i cannot add link to my post, so office_2010-access/access-2010-sp1-you-receive-random-crashes-in/d2bf6175-075a-4a12-a2b1-f55d40af271b ) so, It looks like the reason is Microsoft Office 2010...

Hello! I know you'd probably suggest: use search and you will get your answer I have searched and i could not find the one which will solve the problem. So, here is the problem: I have Microsoft Office 2010 32 bit installed on Microsoft Windows 7 Prof 64 bit the database is accdb. Recently...

Re: Is there simple alternative of sql TRANCATE yes, it would be TRUNCATE:)

Thank you! but it seems that there is no easy alternative, what you have described it is ok, but it is not worth it, so i will stick with the normal delete thank you !

Not much! probably around 10 -15 thousands! so the result should be 2-3 thousands

yep! I have index on tbl_1.field. It did not increase the performance of that query at all

Here is the task: delete all duplicates by field from the table and keep the one with say max(ID): DELETE * FROM tbl_1 WHERE ID not IN (SELECT Max(tbl_1.ID) AS MaxOfID FROM tbl_1 GROUP BY tbl_1.Fields); And it performs painfully slow even though i have indexes If i am using temp table to...

Re: Is there simple alternative of sql TRANCATE Thank you John for the quick replay and worm welcome :-) The reason why i wanted to use TRANCATE , because in SQL Server this command is really fast compare with normal DELETE operations as it is no logging anything in transaction log. So, if we...

I just need quickly erase all records from the table and reset Autonumber field? is it possible to do without using DAO stuff? Thank you!