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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DTSFreak

  1. DTSFreak

    Index tuning wizard bugs

    Hi, I've already read that article, but the dbo does own all objects and all objects are reference with the 2-part naming rule
  2. DTSFreak

    Index tuning wizard bugs

    Hello, I've the following error when using the index tuning wizard with profiler or analyzer: "The server returned an error attempting to either create a temporary table or index statistics." In analyzer tried to tune a given sql statement. On first it did work, but after the second time, i...
  3. DTSFreak

    checking for duplicate entries

    Hi, I've a problem to check if there is a duplicate entry. In my table i have a computed column which checks for a certain type of entry which must be unique. E.g. there can be two types of entries. One which has a type of 1 where period can be 6 or 7. The other type is 2 where period can be...
  4. DTSFreak

    enabling arithabort in odbc

    Hello, I've a problem with inserting a record through a form of msaccess. The recordsource is a view from sql server. The view has a computed column. The problem occurs when there is an insert on that view. In my ado-connection i can fix that, but how do i do it when the view is linked through...
  5. DTSFreak

    update table

    Hi Roy, It worked, however i was wondering if you have a ado-based recordset solution for my problem.
  6. DTSFreak

    update table

    Hi Roy, Sorry, here's the code: Dim oRE As VBScript_RegExp_55.RegExp Dim oMatches As VBScript_RegExp_55.MatchCollection Dim rsR As DAO.Recordset Set oRE = CreateObject("VBScript.RegExp") oRE.Pattern = "^(?:([a-z][^ ]+)\s+)?(?:([0-9.]{5,12})\s+)?(.*)$" oRE.IgnoreCase = True '...
  7. DTSFreak

    update table

    I already removed the line, i was hoping someone could make it right. the one i was using was not very readable.
  8. DTSFreak

    update table

    Hi, I've this code which i want to update a table. The thing is that i don't get it to work how i want it. I've tried to use a dao-based recordset and loop through the recordset, but then my app hangs. Can some help me adjust the code to update a table? code: Public sub Conversion() Dim oRE...
  9. DTSFreak

    connection strings with ado

    Hi, I was wondering how i could set connection strings from info in a table. I have a table where i store the following data about connections: Id DataProvider NetworkLibrary DataSource PortNr Database UID PWD (don't know if i should store that in a table) Also i have forms which get their...
  10. DTSFreak

    setting unique table

    Hi, I've an acces form which recordsource is generated through an ado-connection. This ado-connection calls a view in sql server. Within the view there are multiple tables joined from different databases in sql server. The problem is that i cannot update a field in the access form because no...
  11. DTSFreak

    refreshing or requerying ado based recordsets

    Hi PHV, I did that but i don't know how to use it. I'm getting a message that the recordset is closed if i do rst.requery in the second form
  12. DTSFreak

    refreshing or requerying ado based recordsets

    Hi, I'm having trouble with refreshing or requery an ado-based recordset. I have two forms where the recordset is buildup through an ado-connection. The first form is a continueous form and the second form a detailed form which pops open via a cmd button. If i update some data on the second...
  13. DTSFreak

    insert trigger

    Hi, I'm having trouble with an after insert trigger. The trigger handles an integrity check on a second id column. I have a scheduled stored procedure which can return a recordset. If the id in that recordset does not exist in the table with the trigger it may insert the new id's. The problem...
  14. DTSFreak

    sync recordset in subfrm

    Hi, Thanks for the code, it works. But how do i use it for inserting? If i insert a record i'm getting errors or sometimes a vb crash.
  15. DTSFreak

    contacts table

    Hi, I'm designing a database where i have some tables about contacts. What i would like to know is what the best design is for creating contacts. I have a table relations where i store persons name and company names. Now to determine the relation where who is related to who, e.g. a company and...

Part and Inventory Search

Back
Top