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 - 2001-01-18 : 17:58:41
|
| steve writes "I realize that ACCESS/97 does not have a function for temporary tables. However, is there a way to programmatically create one? I want to do a SELECT statement in visual basic code and put the result in a form. The data comes from 2 tables and the result is one row of fields. When I do a SELECT... INTO statement, the table gets locked and I can't do the procedure again. I also can't DROP the table because it is locked. I have it working with a SELECT...INTO table, but have to close the form to try it again. How can I get visual basic code to dump the output of a SELECT astatement, generated by RunSQL, into a form field? The output is 7 fields extracted from 2 tables. Thanks for your help." |
|
|
|
|
|
Temporary table in Access/97 SQL