Search results

  1. A

    Tip Access + SQL Server Reporting Services

    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...
  2. A

    access database crashes ...

    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...
  3. A

    Using subqueries in delete queries is really slow?

    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...
  4. A

    Is there simple alternative of sql TRUNCATE

    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!
Back
Top Bottom