Search results for query: *

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, 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, 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, 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?

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

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, Could somebody explain to me what the best practice is about how to update the production environment if there are new changes to be made. I have a testing environment where i do datamodelling in a sql server db and a production environment with also a sql server db. The case is that at...

Hi, Can somebody help me with my code? I would like to do a mailmerge through document properties, which i've created in word. I'm using a continueous form in access and a commandbutton to do a mailmerge. I can manage it to do it for one record, but not for multiple records. This is what i...

Hi, How can i create logins on the fly to access a database. I have a login which can access a database through my webapp. The enduser will access also through my webapp, but they have a different login to the database. My question how can this be done? I've tried to execute the following...

Hi, I'm having some trouble debugging the following script i used from sqldts.com. ---------------------------------------------------------------------------------------- ' 246 (DefineTheGVs) Option Explicit Function Main() Dim fso Dim fold Dim pkg Dim stpContinuePkg Dim stpExitbadDirectory...

Hi, I was wondering how i could use dts to import MSaccess-files and then archive them to another folder. I've read some examples on sqldts.com but i still can't figure it out. Basically this is what i want to do: - import an access-file which has a name like this <companyname>_<today's...