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 bkrike 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: lmarks
  • Content: Threads
  • Order by date
  1. lmarks

    Make table creates auto number - do not want auto

    I am running a make table query and the primary key of one of the source tables is a number. I want this number in my new table. The make table query creates this field as an Auto number and so fails to add the records to the table. Is there are way to force the make table query to create a...
  2. lmarks

    Error handling in convert (numeric(8,3),varchar)

    I am converting a list of user entered varchar values that should be numeric. I want to convert the varchar to numeric and I will then insert into a numeric field. Problem occurs if user enters a screwy value like 185 185. The SQL conversion of select statement will error "Msg 8114, Level 16...
  3. lmarks

    Need help troubleshooting vendor app: 100%CPU

    I am running a vendor app that uses an Front end hitting an Access.mdb middle to get to the SQL backend. The problem is that when using the front end in certain conitions, the cpu usage will jump to 70-100% and that freezes everthing. After about 3-5 minutes CPU usage goes back down and the...

Part and Inventory Search

Back
Top