Search results for query: *

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

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...

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...

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...

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

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 '...

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

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...

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...

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...

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

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...

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...

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.

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...

Hi, I'm having problems with linking sql servers in the enterprise manager. Could someone help me with filling in the right options?

HI, No i did it on the open event. Should it be on the current event, because i also tried that but it didn't work. Maybe i did something wrong.

Hello, I have an access mdb front-end which i use for end-users. The back-end is sql server 2000. In the front-end there no linked tables or pass-through-queries, all recordsources are binded in forms through ado. At the moment i've created a login for the front-end to connect to the...

Hi, Can anyone help me with setting a recordset in a subform? I've this code where i use the connection method to connect to a sql server database. I can use it to set the recordset in a form and a subform, but when i go the next record in the main form the subform's recordset stays the same...

Hello, I was wondering what the best way is to use lookup tables. i don't want to use a new table for every lookup. Basically what i want is a generic lookup table for all kinds of data. In queries, to translate the integer value of the lookup, it should know which description it should use in...