Search results for query: *

Does anyone know if it's possible to run a query from a file? I'm trying to update a client database and don't want them to have to zip and send me the db. I'd rather send them a file that they run to make the update. It's a simple data change. Thanks, Jenny

Anyone know how I can send files via SSH from Coldfusion, to another server? Right now I'm using CFEXECUTE against a program called PSCP.exe. The program hangs when calling it from CFEXECUTE, though works perfectly when entering in the command line. It is a command line program, so no issues there.

Hi, I can't seem to restore my database because the log file is too big for the space left on my drive. There are a number of reasons for this, to prevent this from happening again... but in the meantime, does anyone know how to restore a .bak file, using only the .mdf and not the .ldf? The...

When using the Profiler to assess some hangups in one of our VB applications, I keep randomly seeing these two errors: Error 16937 and 16945 Any idea what they are, or where I can find what they mean? Thanks, Jenny

Hi, I'm running SQL7 and seem to have a problem with missing users in the Users view of my DB. I know the users exist, as they use their NT windows login as authentication, and if I try to add them, a message appears stating they already exist. Yet, they are not seen in the view, nor in the...

Can you make an instance of a combobox, and dynamically place it on a form in runtime? Thanks, Jenny

Hi, OpenArgs seems to work in A2002 in A2000 mode, but does not work in A2000. Any reason for this? Thanks, Jenny

Hi, We have a tape backup plan that backs up the MSSQL7/backup folder every night at 3:00am. For some reason, the folder MSSQL7/backup gets denied every once in a while, stating the tape backup doesn't have permission to back up it. It does of course, and often works fine. I do have a...

Hi, I'm working on SQL7 and seems to have an unscheduled backup that occurs every night at midnight. I DO have a scheulded one that occurs at 2:00AM, but not at midnight. The log states the following: Log backed up with following information: Database: prod2000, creation date and time...

Hi, This is tricky! I have a subform that needs to be repeated on a form 3 times. I can make an instance of this subform: Dim mySub as New Form_frmShiftData ...but can't make this form appear in any way on the main form. I know I can change sourceobject of a subform object on the main form...

Hi, I know with an Access MDB you can use replication to distribute an application, but how would one distribute an ADP? Thanks, Jenny Peters

Hi, I can't seem to assign the contents of one UDT to another UDT. i.e. Type Test Value as stting end Type Dim myTest1 as Test myTest1.Value = 1 Dim myTest2 as Test myTest2 = myTest1 myTest2.value ends up being 0 How do I assing the contents of one UDT to another? Thanks, Jenny Peters

I'm trying to deploy an Access ADP frontend to several users. Replication is not an option for ADPs, so what would be the best way to deploy frontend changes to all the existing frontends? Thanks, Jenny Peters

I am creating Access Projects in Access 2002, which use the Excel 10.0 Object library. But, when deploying the application on Access 2000 machines, they don't have this reference, and hence an error occurs. The 10.0 refernce can't be registered on a 2000 office machine without problems. So...

I have a large archive table, 200,000 records, and when trying to append record from this archive table to another empty table, I get a message saying 'Timeout expired', and my SP stops. Is there a way to change the 'Timeout' value, so this query has time to actually run? Thanks, Jenny

Here's the scenerio: I need to append records from one table1 to table2. I need the date to change from full datetime data, '11/13/03 12:23:43 AM' to just '11/13/03'. In other words, in my INSERT statement I need some syntax that will remove the time portion of the date, and only insert the...

I'm trying to insert the value for a string type variable called 'strCommets' into a table field called 'comments' that is of the type 'nText'. I keep getting an error that says: 'Application uses a value of the wrong type for the current operation' If I can't insert a String into a nText, then...

What's the difference between the SQL Server Agent service, and the SQL Server service? Is one better than the other? Thanks, Jenny

Does anyone know why the above code does not work? I'm trying to reference the column 1 value of a combobox, not the column(0) value, which is takes by default. I can't seem to get the right syntax to do this.... Any help would be great! Thanks, Jenny

Hi, I have a table that has 17,000+ records in it and it's really slow when I'm accessing it. There is an index on the rowguide column, but I'm thinking this is one of the reasons why it is so slow. I never use the rowguide for accessing records, just numeric fields within the table. Should I...