Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Erik.doe
Starting Member
6 Posts |
 Posted - 2013-01-15 : 09:38:29
|
| I have a accessdb that connects to a MS SQL 2012.I the creation of a report, I fill data to a table T after deleting the previus content. Then manipulates these data in T and creating the report.But if 2 or more users do this at the same time the T is currupted.Can I lock the table T and release the lock after use?/Erik |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-01-15 : 10:04:51
|
| You can lock the table but a better option may be to use a temporary table. Temporary tables are scoped to the session that created it, so multiple users can use the same temporary table name and they will not interfere with each other. (I am of course assuming that the source data used to populate the temporary table is not altered by the reporting queries). |
 |
|
|
|
|
|
Lock sql table