Recent content by moolie

Thank You. This was the last piece of my puzzle for automatic configuration script. Thanks again.

Can this be done from command line or script? Ie. server has 2 GB of ram installed, I would like to limit sql server usage to 1 gb. Normally done from properties dialog inside sql registration. Any thoughts?

thanks for the responce. I am changing my request. I have been able to connect using a script run through osql from command line that I will activate from access no biggie. exec sp_attach_db N'test', @filename1 = N'C:\test\test.mdf' @filename2 = N'C:\test\test.ldf' go This attached the db in...

Hello all. I'm trying to create a function in an Access front end that will allow me to attach and detach database's on the hosting SQL server. Any suggestions?

Found this entry in VBScript forum: tsuji (TechnicalUser) Feb 27, 2004 Hello jantrummel, Check out the ms article KB189105 http://support.microsoft.com/default.aspx?scid=kb;EN-US;189105 or it xp version KB314486 http://support.microsoft.com/default.aspx?scid=kb;en-us;314486 worked...

I was thinking the same thing. The printer would be local to the machine, using print-to-file port and QMS-PS 2220 v51.0 or 52.3 printer driver, named "FFTPrinter". I'll check in the scripting forum as well.

In code I would like to create a print-to-file printer using a predefined PS printer driver and naming the printer a predefined name. When the application I have starts, if the PS print to file printer called FFTPrinter does not exist, then create it. Preferably with little or no interaction...

Merry Holidays everyone! I have an issue with the app I'm working on. We have built a custom toolbar for the users to have access to from within Access. Unfortunately, this lockdown eliminates the standard toolbars and makes Supporting the app more difficult because we have to SHIFT-Open the...

DropTable.Execute , Array(delTable) Killer - Did the trick. 2 days and 2 forums later. Star for you!

Typed and tested, unfortunately. here is the full code from the app: Code: Private Sub Command6_Click() Dim cn As New ADODB.Connection cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=TestStride;Data Source=IT2" cn.Open Dim...

I tried that as well - same error message.

I have a stored proceedure on my SQL server called SP_DROP. Basically, it drops a table from the database. the SP requires a parameter containing the name of the table to drop. SP looks like this: code: CREATE PROCEDURE SP_DROP(@tablename varchar(50)) AS DECLARE @InsertString NVARCHAR(500)...

Same. It seems no matter what I try the parameter will not go. I'm using the exact code for the SP, maybe I'm missing something in VBA to launch the SP? Stumped

Edited the SP and I still am getting the same error message on the .parameter(1) = delTable line of VBA code. Although, the SP now runs well on the server, I just need to be able to pass the parameter.

I am trying to create a stored proceedure that drops a table from the database. code CREATE PROCEDURE SP_DROP @InputTable as varchar(50) AS DROP TABLE InputTable GO seems straight forward. I get an error message when I try to pass the parameter to the SP. "Item cannot be found in the...