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

...or message DLL files to display messages from a remote computer. The following information is part of the event: Error in Parsing Event: SELECT * FROM vw_OpenAppointments. I'm running sql 2000 enterprise sp3 on the server and running analyzer/profiler from my pc with msde sp4 also...

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.

...Dim rsR As DAO.Recordset Set oRE = CreateObject("VBScript.RegExp") oRE.Pattern = "^(?:([a-z][^ ]+)\s+)?(?:([0-9.]{5,12})\s+)?(.*)$" oRE.IgnoreCase = True ' Set case insensitivity. oRE.Global = False ' Set global applicability. Set rsR = CurrentDb.OpenRecordset("mytable")...

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

...= <should be a field of a recordset> Set oRE = CreateObject("VBScript.RegExp") oRE.Pattern = "^(?:([a-z][^]+)\s+)?(?:([0-9.]{5,12})\s+)?(.*)$" oRE.IgnoreCase = True ' Set case insensitivity. oRE.Global = False ' Set global applicability. Set oMatches =...

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

...id from MyOtherTable WHERE id not in (select id from MyTable) TRIGGER: CREATE TRIGGER Itrig_CheckId ON MyTable FOR INSERT AS IF (SELECT COUNT(*) FROM People, inserted WHERE people.id = inserted.id) <1 BEGIN RAISERROR ('not a valid id (insert)', 16, 1) ROLLBACK TRANSACTION END How do...

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

...code: Private Sub Form_Open(Cancel As Integer) Dim rst As ADODB.Recordset Set rst = New ADODB.Recordset With rst .Source = "SELECT * FROM MyTable1" .LockType = adLockOptimistic .CursorType = adOpenDynamic .CursorLocation = adUseClient...

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