Recent content by jpastika

Well, I answered my own question. After about 6 hours of fiddling around with different security rights, moving users around, and banging my head, it turns out all I had to do was add my SQL Server user (the one used by the VB app) to the System Administrators group. This is because that is...

I am getting the following error when I try running a stored procedure that executes the xp_cmdshell extended stored procedure: "Msg 50001, Level 1, State 50001 xpsql.cpp: Error 997 from GetProxyAccount on line 472" I only get this error when I try executing the "parent&quot...

I would like to develop an application that will monitor the transactions going into my SQL Server Database. I want the application to look at every INSERT, UPDATE, and DELETE transaction that occurs, and based on defined rules, send notifications, set timers, update tables, etc. I don't want...

I GOT IT!!! I had to use the CallByName function. Here is the new code: ----------------------------------------- maxFields = rs_MetaData.Fields.Count For i = 0 To maxFields - 1 'Dynamically reference m_objMetaData properties using the name of each field in the rs_MetaData...

Thank you for the response. Unfortunately because "m_objMetaData" is a class object, not a recordset, referencing ".Fields()" does not work. Unless I am doing something else wrong.

I am trying to set the value of each property of an object. However, I do not want to have to hardcode the call to each property individually. I am trying to pass in a recordset of all of the property names and values. The object's property names match the recordset field names. I keep...

Thank you for the advice! I figured a class or global connection would be the way to go, and your explanation really helped. I hadn't really thought about disconnecting the recordsets. Thank you for that advice. -Jeremy

I am new to Visual Basic and OOP, but not new to programming in general. I am starting to work on a Database application, and I need some advice on how to proceed in two main areas, DLLs and Database connections. Here are my two questions: 1) What are the advantages/disadvantages to using...

Thank you for your response Ken. I don't know what I was thinking by going through the trouble of executing a .CMD file and trying to pass it arguments when all I had to do was call the "NET SEND" command directly from the "Shell()" command. Here's what I am using now...

I am trying to create a pop-up alert system inside Access using the Shell() command to execute a .CMD file. What I want is to be able to execute the .CMD file and pass it the computer name of the person I want the pop-up message to go to. I would also like to be able to pass the actual text of...