Search results for query: *

Hello, This is Carla again...Never mind the above question. I got it to work. Carla Documentation: A Shaft of light into a Coded world

Hello, I am not sure what I am missing. I tried both methods listed above, and both of them did the same thing that Kenneth mentioned - the screen flashes, but the formatting does not change. Any ideas? Carla Documentation: A Shaft of light into a Coded world

Hello, Could you do two select statements? In the first you could pull the forecasted date - 1 into a variable, and then use that variable in the second select. Carla Documentation: A Shaft of light into a Coded world

Thanks and I agree. The problem is I don't know what file it is! I have read (and read and read) the documentation on installing it and it just says to pick it from the list of add-ins, but it does not show up in the list. Any idea what file to look for? Carla Documentation: A Shaft of light...

I have the MOD VBA Code Commenter and Error Handler add-ins installed on my machine. But when another programmer uses my machine, logged on as themselves, those add-ins are not available. I know it is installed on the machine. What do I need to do in Access to get it to show up for the other...

Hello, I have the MOD VBA Code Commenter and Error Handler add-ins installed on my machine. But when another programmer uses my machine, logged on as themselves, those add-ins are not available. I know it is installed on the machine. What do I need to do in Access to get it to show up for the...

Hello, You should also make sure that you have the same ODBC connections on the server that you have on your desktop. This can also cause a scheduled DTS to fail. HTH, Carla Documentation: A Shaft of light into a Coded world

Kim, Good point, I was not looking at the actual "server" roles. Sorry. Carla Documentation: A Shaft of light into a Coded world

Hi again, In the wizard you should see a choice to overwrite or append the data. Carla Documentation: A Shaft of light into a Coded world

Hello, I have never had occasion to do this, but I went in an added an application role to the server role just fine. So it seems like it is possible. Carla Documentation: A Shaft of light into a Coded world

Hello, What kind of error message are you getting? Do you have the same DSN's on both machines? I am not sure what you procedure looks like that you are using to run the DTS. While I know there are several ways to do it, here is a copy of one way that we have found that works: CREATE PROCEDURE...

Have you tried using the export wizard? It will give you options to select all the tables if that is what you want to do. You may want to use the wizard to create the DTS and then tweak it as needed. HTH, Carla Documentation: A Shaft of light into a Coded world

Hello, Another way might be to just back up the database on the one server and restore it on the other server. You may need to move the physical file that you backed up to, but other wise it is very straight forward. Carla Documentation: A Shaft of light into a Coded world

Hello, A view is like a query, it does not store any information. A temp table does store information for a finite period of time (until you drop it or the connection is severed). As to which is better to use, that depends on your needs. Carla Documentation: A Shaft of light into a Coded world

Hello, You should be able to find an example in Books on Line. I would use the Columns_Updated() function in the trigger. Books ON Line describes how to do that. Carla Documentation: A Shaft of light into a Coded world

Hello, I don't think your second example will not return any records because it is an update query. Carla Documentation: A Shaft of light into a Coded world

Hello, I don't know why it works the second time, but did you give the ReadOnly user execute rights to the stored procedure? Carla Documentation: A Shaft of light into a Coded world

Hello, Here is the SQL that I use in a job to backup my databases. USE [CrMaster] DECLARE @File varchar(100) DECLARE @DeleteFile varchar(100) DECLARE @Date datetime DECLARE @DeleteDate datetime SET @Date = GETDATE() SET @DeleteDate = GetDate() - 4 SET @File = 'D:\MSSQL7\BACKUP\CrMaster_db_'...

Hello, To get the seconds, use the modulo operator (%), which returns the remainder of a division problem. declare @Talk_Duration varchar(255) declare @Talk_Minutes smallint DECLARE @Talk_Seconds smallint Select @Talk_Duration = '288' SET @Talk_Seconds = @Talk_Duration % 60 SET @Talk_Minutes...

Hi, I was wondering if it would not be easier to just use the DTS to import directly from the Access table. Carla