Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jimgrin

    Extracting Access data without Access

    Roz, thanks for this. There are a few freebies on there (CuteSQL) which is exactly what I was looking for. I'm sure these will come in handy at some point, thanks again, Jim.
  2. jimgrin

    Extracting Access data without Access

    Rosalindr, Thanks for the suggestions. I now have Office installed on the machine in question so my problem is solved. Just for the record, what I was after was some way of accessing the data in the mdb file (a bit like using Excel and ODBC to get to the data) but without having Office...
  3. jimgrin

    Extracting Access data without Access

    May seem a strange question, but does anyone know a quick way of getting data out of an Access mdb file without having Access (or any other part of Office) installed? I have a remote machine with an Acccess database file that I would like to use. I can ftp the file, but the size of it makes...
  4. jimgrin

    Systematics Accord file format

    Thanks for the help. I have given up on trying to access the data files and am relying on the IT guy where Accord is installed to send me data presumably exported as you suggest, Jim.
  5. jimgrin

    Systematics Accord file format

    I have some data files from an accounting system called Systematics Accord. The extension on the largest files is either .SID or .SIB or .SIT with a whole load of smaller files, some with the same extensions, others with .PRE or .SI1. I have looked at the files in a text editor (Emacs) and can...
  6. jimgrin

    X Window screen resolution prob.

    I have installed an old version of Red Hat Linux (5.0) on a spare disk in my PC just to see how easy it is to set up and use. It all looks fine, but I am having a few problems with setting up X. Using Xconfigurator or xf86setup, I can get X to work using the VGA16 server but whatever I do, it...
  7. jimgrin

    automatically update records in an access97/2000 database from .CSV

    Automating this process (at least the Access bit) is fairly easy, depending on how familiar you are with Visual Basic for Applications. If you have never used VBA then there is probably a bit of a learning curve here, but it will pay off. You can import data from spreadsheets with the following...
  8. jimgrin

    How do I get rolling 3 monthly totals?

    Thanks Michael, that was helpful, but as ever with brief descriptions of problems, there is always a "but". Your method would be good if I only wanted the totals for three specific months. However, I have sales data going back to 99 and potentially going forward into the future, and I...
  9. jimgrin

    How do I get rolling 3 monthly totals?

    I have a database of sales info. with one record for each sale (customer, date, product etc.). I somehow need to produce a query or report to give me for each customer and each month, a rolling total of the last 3 months. So I have: Customer YearMonth SaleVal Cust1 2000 01 200 Cust1...
  10. jimgrin

    VBA DDE commands to Outlook

    I am trying to automate the mailing of some Excel spreadsheets from some existing VBA code within Excel. I have had a look at the help for DDE commands and can see how this works for Word etc. but can you get this to work for Outlook? What do you put in the "topic" string of the...
  11. jimgrin

    SCO slow login performance

    GOSCO: There was no delay before ping replied AndyBo: We have other Unix servers and I can telnet to them with no delay. If I log onto one of the other Unix servers and try and telnet to the offending SCO machine from there, I experience the same interminable delay! Thanks again for your help...
  12. jimgrin

    SCO slow login performance

    Here is the response of the ping command from my workstation: C:\>ping 192.168.0.1 Pinging 192.168.0.1 with 32 bytes of data: Reply from 192.168.0.1: bytes=32 time<10ms TTL=64 Reply from 192.168.0.1: bytes=32 time<10ms TTL=64 Reply from 192.168.0.1: bytes=32 time<10ms TTL=64 Reply from...
  13. jimgrin

    SCO slow login performance

    Thanks for the replies. I am connecting to the SCO machine from a PC running NT, with a telnet session. As far as I know, there is no delay when logging on from the console. It seems to be the same regardless of time of day and the number of users who are on. I am not familiar with DNS so can't...
  14. jimgrin

    SCO slow login performance

    Can anyone suggest reasons why the login prompt would take a long time to appear. Is there anything I can do to diagnose the source of the problem? Any help much appreciated. I am using SCO OpenServer Rel. 5. Jim.

Part and Inventory Search

Back
Top