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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Calling an ms access query from Query Analyzer?

Author  Topic 

rweasel6
Starting Member

6 Posts

Posted - 2007-05-01 : 14:12:12
I have searched on trying to prompt a user for input from QA but it appears to be impossible. Is it possible to call a stored procedure through ms access so that a prompt will be given to the user? If not QA can it be done from a command prompt?

The idea here is that I could connect the access project to the sql server datbase and after a user entered the data in the prompt I could use the data to set a column equal to their entry.

Im attempting to load data from a text file to sql server but I need the user to input the date that the data is for?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-05-01 : 16:54:53
This topic may help you
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=82917


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -