Search results for query: *

I did some more digging and it looks like I justed needed to set the PAE switch in boot.ini (just like with a 32 bit system. SQL is now seeing the memory.

We are trying to run SQL Server 2000 Enterprise Edition 32 bit on Windows Server 2003 64 bit running on Opteron 64 bit processors. SQL is only using a little under 4GB of RAM (we have 32) and I cannot find out how to use the balance of the RAM. I've already tried using sp_configure and 'awe...

Another option is to generating the diagram is to generate the SQL scripts for all the tables (make sure to check the option to "Script Primary Keys, Foreign Keys ..."). Along with the table definitions, it will also generate the table "relationships"; that is, at least this ones that enforce...

Try testing for -1 in ADO. Some programs use 1 for true and some use -1 for true.

Cheryl3D, I think your case statement should look like the following: CASE WHEN qryAnnex_View.RCost > 0 THEN 1 ELSE 0 END I'm assuming RCost is a numeric value and not a text value (your Access statement was structured that way). Michael

Or a shorter version of the same code. me.quantity2.visible=not isnull(me.quantity2.value)

Can you repost the where clause with paranthesis? That may be your problem. That is, since you are mixing ORs and ANDs there needs to be some heirarchy. Michael

Roswald, Are you working on HEDIS? If so, I have some code for HEDIS continuous enrollment. If not, is it healthcare data? Michael michaelhodes@managedcare.com

This is kind of a long shot, but have you tried explicitly referencing the value property: dblRetVal1 = .Parameters("@dblOLat").value

Access is definitely not the most efficient program on the planet, but as you stated, you can run it on another server. If fact, to state the obvious, you do not even need to run it on a server.

I have a similar process monthly. I receive a lot of data in a wide variety of formats. The data requires a LOT of manipulation prior to loading into SQL. I do the cleanup processing in MS Access then use DTS to import the data. Given the above, her are my comments: -If your data...

The import should either succeed or fail. This is, either all or none of the data will be imported. If you are running the package from Enterprise Manager, you will receive immediate feedback. If you are running the package from some other source, you can have the status output to a text file...

Terry, You are absolutely right about the permissions issue. I created a test package and a test Access db on the local computer and it works. I created another test package referencing an identical db on another computer and it fails. But I am rather confused. As I indicated, I am the only...

I'm running the standard edition for the past three years.

SQL Server 7 SQL Server is running on Windows 2000 Pro The other computer is running Windows XP

Terry, Thanks for the post, but I do not think permissions are the issue. - SQL Server is residing on a work station, not a server. - The network is just a peer-to-peer network with four computers. - I am the only user of all these computers and I use the same login in all places (same login...

I have setup a stored procedure to allow me to run any DTS package from Query Analyzer. When I run the stored procedure for a DTS package that moves data from one SQL DB to another it works. However, when I run the stored procedure for packages which transer data from MS Access to SQL, it does...

Terry, Thank you for the clarification. That was my understanding as well. I misunderstood your first post. Thanks for the clarification. Michael

Terry, I'm getting off topic here, but you said something very interesting in your response: I just want to clarify something I think you said: If you have a primary key on a table. The primary key is not used an index for queries (either in FK links or on queries of that table). If I want...

There are quite a few more knowledgabe individuals on this forum than me (specifically tlbroadbent and SQLSister), but I remember something written in some Access books about indexes and selectivity. Specifically, indexes on fields with a very limited range of values (i.e. true/false, 1/2/3 -...