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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-25 : 07:41:53
|
| Rob writes "I have a software package, which consists of multiple applications running in a multi-user environment. Some of the applications require temporary tables used in grid selects, reporting and other processes. The software package is currently designed with VB6 and the database is MS Access 97. I am currently well underway to converting the apps to ADO and SQL 2000.My question is how would be the best way to handle and create the high quantity of temporary tables my apps are using on the fly? The current Access version of the apps creates a temporary access database on the users home directory therefore not taxing the main database.Any direction would be greatly appreciated.Note – I have currently created a DTS package for my apps which does drop and create tables in a temporary Access database, however when I try to then open a Jet recordset in the temp database I am forced to retry(or loop) the OpenRecordSet command due to something after the package has ran successfully not releasing the new table object in the temporary database. Any ideas?Thank you very much for your help.RG" |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-03-25 : 08:22:15
|
| CREATE TABLE #MyTable (columna ... columnb...)process tableDROP TABLE #MyTableSam |
 |
|
|
|
|
|
Creating Temporary Tables in an external database