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!

Register Log in
  • Congratulations Chriss Miller 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: *

  • Users: skerr
  • Content: Threads
  • Order by date
  1. skerr

    JDBC error trying to connect to MS access db on remote NT 4.0 server

    I am running ColdFusion server MX 6.0 on a Windows 2000server. In Administrator I am trying to connect to an MS Access datasource on a remote NT 4.0 server. I have tried to connect using ODBC sockets and MS Access and neither will work. I have the ColdFusion services all set to run with my...
    • skerr
    • Thread
    • Replies: 0
    • Forum: Adobe
  2. skerr

    Query Help - use of MAX returns all rows for an ID - I want only one

    I have the following table: ReqStatusID AutoNumber Unique Identifier for table RequestID Number Unique Identifier for the Request Table StatusID Number Unique Identifier for the Status Description Table StatusDte Date/Time Date status added for a request Detail Text Detail for status...
  3. skerr

    Calculate Sum for Word text form fields

    In Word 2000 I have a table with a column of 13 text form fields (type = number & format = currency). In the last row of this column I would like to sum the currency in the text form fields. Is it posible to perform a calculation on text form fields in protected mode? Thanks for any help.
  4. skerr

    Alter Column results in Incorect syntax near 'Column'

    I ran this query against the pubs database and it runs successfully ALTER TABLE publishers ALTER COLUMN state CHAR(25) I change the table & field names for my db as follows: ALTER TABLE customquery ALTER COLUMN toclause CHAR(25) and run against my database and I get the following error -...
  5. skerr

    Model Database won't attach in SQL 7.0

    I used sp_detach_db to detach the master, model and msdb databases on ServerA and then used sp_attach_db to attach the master, model and msdb databases on ServerB. The attach process completed successfully for all databases (and I did start SQL Server with trace flag 3608 for the detach and...

Part and Inventory Search

Back
Top