Search results for query: *

I have set up a DTS to export 5 or 6 tables from SQL Server to MS Access. The largest is about 125,000 records. The sequence is, delete from the MS Access table, then copy the table from SQL to Access. No trsnformations, just straight copying. Each time I test this DTS, at least one step...

The intranet uses one of 2 .mdb's as a recordsource. The ODBC connection has to be manually switched to point at the .mdb for the day. They are alternated because they need to be compacted & repaired daily, and something about the intranet connection causes an .ldb to be open all the time, so...

Hi, I have a group of 6 tables I am importing using a DTS package. No particular reason why these 6 are grouped together, except that they all come from the same ODBC connection & DB. The DTS is Create table . . . Copy table sequence for each of the 6. The tables vary in size but the largest...

Thanks, fluteplr and tlbroadbent, for your responses to my earlier post. I have a bit more information and am hoping you can keep me going. The field looks like this: }sÓ when it is imported from the H-P. From the vendor technical info, I see it is a 6-byte field mapped to different...

OK, I was afraid of that. I'll see if I can find out more about the H-P formats. Thanks for info.

I'm just getting started with SQL Server. I'm using the DTS wizard to set up an import from a Hewlett-Packard database. The H-P has a timestamp field that is not importing correctly -- I think it is importing in unicode? I searched the BOL and MS KB but didn't find anything that seemed to...

Hi, thanks for your response. It wasn't any of those things, but your response inspired me to experiment some more. I finally took the START off the beginning of the command line in the batch file, and it worked fine! (I had previously removed the wrkgrp and user switches, and just left the...

I'm trying to set up a batch file to open an .mdb. This would run unattended during the night. So far I have: START "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Folder\RevSchedules.mdb" /wrkgrp "L:\ITStuff\Workgroup.mdw" /user GoodUser /pwd MagicWord...

Aha! Now I get it. Using AT at the command line tells the scheduler what to do. So, there isn't any way to view what the scheduler has in it, when it last ran, etc? Do you just take it on faith that NT knows to do this now? Thanks a lot for your response.

Well if you have tested a different database in the same exact client-server distribution, and it works, then it would be a problem with this specific database. If you've already tried compacting and repairing, try creating a new shell database, and importing all objects into it, then renaming...

OK, I'm a novice with NT so please explain slowly and clearly. I need to schedule something to run during the night. I've got the routine written, and I've got a batch file which opens the routine. I read in NT help about using the AT command, but I can't figure out WHERE you type the...

Wow, thank you so much for an enormously helpful reply! Do you think it would be advisable for me to become more familiar with Linux (I know for general purposes it would, but I mean relative to this specific client's database)? Or would working on the database be essentially the same...

Hello, I am new to this forum and Linux. I am a database programmer, mostly MS Access. One of my clients is changing their network system to Linux. I can't seem to get a straight answer re: will client machines still be able to run Access (say they still have Windows, or have dual boot...