Geek Answers Handbook

What is the best way to work with SQL Server data is not software?

We have a SQL server database. To manipulate non-software data, I can use SQL Server Management Studio by right-clicking on a table and selecting Open Table. However, it is very slow for very large tables, and sorting and filtering are cumbersome.

Typically, we are still trying to create an Access database containing linked tables that point to tables and SQL Server views. Opening a large table is much faster and Access has easy-to-use filtering and sorting of right-clicks.

However, since Access 2007, sorting in particular was rather slow when working with large tables. An Access database can also inadvertently lock database tables, blocking other processes that may be required to access the data. Creating an Access database in the first place and updating it when adding new tables to SQL Server is also tedious.

Is there a better way to work with data that offers ease of access without its disadvantages?

+5
source share
6 answers

Joel Coehoorn, , , , , . , , , (, ) .

MS Access, , , , . . , No Locks. . , . , .

, , SQL Server, , .

+2

Visual Studio, , , .

, Toad MS SQL ( Quest Software)? Oracle ( , Oracle).

+1

, , Visual Studio , SQL Management Studio . , "", " " , ..

0

no-no. , , , , , .

0

, , (Base), , .

0

You might want to read the Tony Toews Access Performance FAQ , which contains a series of tips on how to improve performance in your Access application. Perhaps one of these tips will help solve the problem in your A2K7 application.

0
source

More articles:


All Articles