Search results for query: *

What is the best way to distibute an Excel (2003) macro and a form that's associated with it? Version control, as it's own workbook What are the pitfalls and things to look out for? Are there any specific things I need to do with my code? I appreciate this may be a large topic, so links to...

One of my stored procedures uses the xp_cmdshell to export data usig the following code SET @cmdline = 'bcp reporter..' + @SummaryTableName + ' OUT "\\cmcukfs01\Userdata\Reporter\AccessApplication\Import Data\SummaryFile_' + @UserID + '.txt" -T -t "," -c' EXEC master..xp_cmdshell @cmdline...

I set off a query to update a table with a 40 million rows by referencing an equally big table. It's been running for a long time - over the weekend. I know if I stop the query it will take as long to undo as it took to run. The transaction log hasn't grown too big and when I look at the task...

I stupidly ran a big update query on a table over the weekend and when I got in on Monday it was still running and all the space had been used because it had created a huge transaction log and the tempdb was massive. Even more stupidly I stopped the query thinking that it wasn't working due to...

I have a table that has just stopped working. When I try to run a query on it, it just runs and runs. I can't drop the table, I can't delete the data. When I go to the task pad view it says the table is zero rows but is 33,408 KB What could be wrong?

I'm trying to FTP data from and Access database using the iNet control. This uses the Microsoft Internet Transfer Control (msinet.ocx). This is a VB control and not an Access control. I have VB on my PC, so I can reference it fine and it works. The trouble is when someone who doesn't have VB6...

I want to use the msinet.ocx contol within my access app. It isn't currently available to any of the users who will be using the app (i.e. it isn't in their c:\windows\system32 directory) I found some code on the internet (see below) that copies the msinet.ocx file from a network location to...

I've read that you can use the command shell ftp functionality to FTP files to a site I've hunted around a bit on the internet, but so far haven't managed to find the VBA code syntax that I would need to run this. Also, I'm wanting to FTP many files and from what I can make out I need to make...

In Access I create banding functions, that when you pass them a numerical value they return a string that can be used to band ranges of values. For example; Public Function CouponSelection(Spend As Double) As String Select Case Spend Case Is > 70 CouponSelection = "Over...

I've included a list box in my form that has a SQL statement as the Row source. The SQL statement references a text box on the form. the SQL statement is; SELECT DISTINCTROW tblCouponDetail.PrintingMCLU, tblCouponDetail.Description, tblCouponDetail.Segment, tblCouponDetail.CouponType FROM...

I want users to be able to run DTS packages to export data from the database. I know that I need to set up a Proxy account and give the proxy account execute rights for the XP_cmdshell stored procedure, to allow non-members of the sysadmin role can run the following SQL statement to execute the...

I'm trying to create a user specific table. The table is used in a process to hold data before carrying out further calcualtions. Because multiple users might be running the process the table needs to be user specific. I started off with a stored procedure that created a permanent table, but...

I'm trying to set up a task on an Access database that runs a Data Transformation package using a pass through query. It works OK on my account using exec master.dbo.xp_cmdshell 'DTSRun /S CMCUKSQL2000 /N REPORTER: Update DIST_CSW /E' but I'm a member of sysadmin. I want other users to be...

I'm trying to set up a task on an Access database that runs a Data Transformation package using a pass through query. It works OK on my account using exec master.dbo.xp_cmdshell 'DTSRun /S CMCUKSQL2000 /N REPORTER: Update DIST_CSW /E' but I'm a member of sysadmin. I want other users to be...

I want to run a stored procedure that has a number of steps 1) Runs and Insert query that inserts the data into an empty table 2) Execute a Data Transformation package that exports the data from the table to a text file 3) Repeats step 1 and 2 for two further different queries on seperate...

I want to create a vlookup calculation in a cell using code. The problem is that the range used in the vlookup calculation can change. Therefore I need to select a range of cells and then use this range in a variable to be inserted into the line of code that contains the calcualtion. I know...

I have a table that has records in it for customers and the days they shopped. The fields are Customer DayShopped Spend I want to sort the table by customer, then by date and loop through the data adding a field that is the number of days between shopping trips for each customer. Obviously for...

I'm having trouble populating a list box from a SQL server datasource. I can link the table to my access database and set it to be the RowSource of the list box, but when I do this it takes a little too long to refresh the data. If I populate the table using code, will it be quicker? If so can...

I'm trying to move the back end of an Access database that I set up over to SQL server, but keep the front end in Access. On one of the forms I've got a list box that is populated by a table. In Access I had it as a bound control. When I copy the table to SQL Server, link the table and then...

I'm creating a user specific table in my database. The table name will have the format [dbo].[tablename_user1] So the table will have variable names. I'm trying to adapt the drop table statement (below) so that it will handle this variable table name. if exists (select * from sysobjects...