Recent content by dr1256dr

Nelviticus That makes perfect sense. In my case, I already had Vista installed.

linney Thanks for the suggestions. I always wondered if such a thing existed as a hardware switch to activate, deactivate drives. Now I know. Drive caddies were also suggested to me. As far as the Virtual PC solution goes, I heard some horror stories about hardware support and performance. I'm...

Greetings. I have searched all over the web for an answer to my question, with no luck. Maybe I am using the wrong search terms, there are a bazillion articles, posts, storys, etc about dual booting. I need to dual boot Windows Vista and XP Pro. I got there no problem, with each OS on their...

But still, I don't see how the DIFF backup can be the same size as the FULL backup, as you mentioned before.?" Well, my assumption was that after a differential backup,"backup.bak" would grow by the amount of data entered since the last backup. As to the sequence, I didn't think of that. As I...

k108, I guess I can check into that, (replication). It just seemed a little bit extravagant as a starting point. I was hoping there would be a way to just create a small bak file with ONLY new data, then restore that bak using the append setting. In effect, I am looking at it like this...

Catadmin: Maybe I have not explained myself very well. (happens frequently!). I want to avoid having to download the large full backup bak file, as it takes a long time. Even if I do an incremental backup/restore, the file size remains the same. What I am trying to accomplish is a means of...

Thanks for the quick response, Dr.Sql I am still a little confused, however. I am already doing a full backup from production, then restoring to development. The problem is that the resultant full backup bak file takes an incredibly long time to download to my home office. It looks as if the...

I am a developer working from home 2 or 3 days a week. I need to keep my home SQL server in synch with my server at work, give or take a few hours. I am running SQL Server 2000. Currently, I run a backup at night, zip up and download the file in the morning, then do a restore. This works fine...

I created a routine to read and edit the description properties of tables, (the one you see in the database window). It seems to work just fine. This is the basic code behind it; (I substituted all my editing/updating code with the debug.print to keep it simple.) Function...

It works! Bob, Roy-Vidar...you were both right. I needed the explicit declarations. But that wasn't all of it. I also needed to lose the ! in the syntax. Thanks for all the help, I can now lose 5 queries, 5 tables, and a bunch of messy code! Stars for both. Even if Bob spent the most time ;-)...

Same type declaration error, same place. I must be overlooking the obvious, sorry! My complete code: Private Function AssignLineNos() Dim db As Database Dim rs As Recordset Dim lngLoop As Long, txtJob As String Set db = DBEngine(0)(0) Set rs = db.OpenRecordset("tblMySource")...

Bob After further reading of your post, I should ley you know that this table will not be update by any forms. I pull the data from elsewhere, and use it to print work orders, and in some labor collection procedures, (barcoding). I also print barcode labels, which is where I use the line...

Bob Thanks for the response. I am still on part 1 of your reply. I am getting an error at run-time; "Type-declaration character does not match declared data type", at this line: If rs!("Job") <> txtJobNumber Then My field name in the table is Job, not Job Number or JobNumber. I know my Job...

Greetings Seems like this should be easy, but I am stuck! I import data in a table from another program. I link to the table using ODBC, and use an Append Query with 6 of the fields. The primary key in my new table is multi-field; fieldA, fieldB, fieldC. fieldA is a "Job Number", in text...

BobJacksonWcom; Thanks a bunch. This is exactly the kind of tip I was looking for. I will adapt this to fit my needs, and post how I used it when I get there. Dennis