Search results for query: *

Hi, I have an access project which is liked via OLE DB to a SQL Server. It uses NT authentication. I want to create a query on it. As far as I can see (new to Access projects) the way to do this is to create a new view, which actualy does create a view in the SQL Server db. So I have given...

Hi, I have a query which is incredibly slow. It's a make table query but when it's changed to a select query it runs in <3 seconds (still slow I know, but not half an hour!) Does anyone know why this is happening and how it could be fixed? Thanks for any help

Hi I hope this is the right forum for this! I have recently moved in to a managment position, and will be involved in my first ever interview (on the other side!) quite soon. I was talking to my boos about it in general terms, and realised that he thinks it is important that the applicants have...

Hi, I have set up a data source and a query in Excel to get the result into Excel. I also want to pass in parameters that come from cells on the Excel sheet, and that works fine. However, is there a way to get these parameters to change, as a value would change if it's a relative value? e.g...

Hi, I have a very strange problem and would appreciate any help. Access 2000 I have bound a form to a recordset (using the form's .Recordset property). The query I used to populate the recordset has an order by in it. The form has navigation buttons to move through the recordset. The form has...

I have a recordset which is filled iin my VBA by running a SQL Server stored procedure. I am then trying to display the returned records on a form. I have put navigation buttons at the bottom, and I want to display one record per 'page' i.e. navigate through the records using the buttons. I...

I'm getting the above error when trying to load data from a text file into SQL Server 2000 database. All I can find is that I'm trying to load data that is too long for the field in, but this is using Bulk Insert with a format file, and the table structure was created to match, so why is this...

Is there a way to work with records that fail to be inserted into a table? I have a command: insert into Table1 (select * from Table2) but Table1 has more constraints on it, so some records will fail (this is what I want to happen). However, I would ideally like to be able to identify these...

I have a text file which I am bulk inserting into a SQL Server (2000) table using a format file. There is a date field in the file which is usually fine or blank, but ocassionally has a zero in it. I would like it to treat these as nulls. Is there an easy way of doing this? I know that I could...

I have a table with some existing data in it. It has an identity column - since I wanted to keep the ID the same as the PK in the table it was migrated from, I inserted into that by allowing identity insert. I now have a bulk copy that is inserting data into this table. It works fine when I...

I have a really strange problem and I hope I've chosen the correct forum. I have two databases, on separate SQL Server 2000 servers. On each database i have an application role set up, called HPSImporter. I want to run stored procedures on the database through Access. This was the first time I...

I hope someone can help me. I have a DTS package which copies data between tables on the same db. The source is a query, which formats things and moves things around. It's in the form of "select ..from <table1>" - no where clause. <table1> has 1.8 million rows. The destination is an empty...

I have done a lot of research on this, and the answer has been 'no' so far, but does anyone know of any way to get data out of an Oracle .dmp file without an Oracle database? I would be prepared to do a lot of manipulation etc.

I have a job, and I'm trying to set up a notification for when it completes. When I go in to create a new operator, I put in the email address and click Test. It tells me that "This will send the message...OK to send?". When I click OK it comes up saying "Error 22022: SQL Server Agent Error...

When I want my data grouped "for each week", how do I change the options so the dates displayed are a different day to the standard, which seems to be a Sunday?

I'm sure this is something abvious, but I have a formula which calculates an average (there are reasons why I can't just use the average function). I have a summary field and a count field. In this particular example, the summary field equates to 3, and the count to 2. My formula divides one by...

I hope this is the right forum, sorry if it isn't. I have an Access (2000) form that calls SQL Server (2000) stored procedures. I pass in the connection string: sqlConn.Open "DATA SOURCE =OurServer; USER=sa PASSWORD=pwd; INITIAL CATALOG=DatabaseName" and this works fine When I try to use...

Is it possible to use a Crystal report (with data saved with report) as a data source for another Crystal report? I couldn't see any obvious way to do it.

I have a really strange problems. I have three subreports on a main report. The main report has three parameter fields - Param1, Param2, Param3. I want to pass Param1 into subreport 1, Param2 into 2 etc. In each subreport, I have created a parameter field, all of type Number - allow muliple...

This problem might be too vague for anyone to be able to fix without seeing it, but I'm interested to hear your ideas. I am filling a dataset (using SQLHelper) using a stored procedure, and one of the tables in it isn't being filled at all. I debug at the point where I'm calling...