Replies

jscher2000,

I have also heard that the WINPowerDown API is unreliable; I am going to try GUI automation to shutdown windows like a user does; since this is not a commercial application, i don’t care how the shutdown gets done;

thanksto all for the help!

–Llyal

I found the solution- one can use the App object in VB to check for a previous instance of the application and then act upon the finding;

–Llyal

Mark,

Thanks for the suggestions;

I did a test install of Windows2000 pro on another machine and find that the PWS (IIS) works fine without a hitch when installed; so my current setup is corrupted; the service packs and other tricks do not fix problem;

I suggest to others that they install PWS (IIS) shortly after they install WIndows2000; I had decided to install PWS long after I configured the machine with other programs and I got problems;

–Llyal

Mark,

I checked the security settings for intranet and they look good;

Another observation, when i go to a local website location and do not explicitly put “default.htm”, IE returns an error saying page cannot be displayed; I might have to setup a fresh machine and see if problems persists;

–Llyal

Hi,

I found some answers: SQL Server 7 limits stored procedures to 1024 parameters; a SQL string length is over 128KB (no exact number);

Comments of database design- not all Information Systems fit a generic database design model;

Comments on column limits of SQL Server – Oracle DBMS do not have a 1024 column limitation; Microsoft made the 1024 column limitation on SQL Server 7 so that the database could look good in certain kinds of benchmark tests;

I hope this information will be useful to others; I appreciate all the help that I got;

Thanks!

–llyal

I am building a database system in SQL Server 7 and one aspect of it will require a table with a few thousand columns; as you can see, filter queries can be quite big (whether I use ADO or stored procedures); I have already found that SQL Server 7 has a column limit of 1024 per table; I am creating a workaround now; I am wondering if there is a query size limit or/and stored procedure parameter size limit that I will need to make a workaround for as well;

I tried to find the limits of SQL server 7 at Microsoft and Google and could not find anything; if you know the answer, I appreciate it; It would be great to know what one can/cannot do with SQL Server so I don’t find “surprises” later;

Thanks,

–Llyal

To All,

Thanks for the clarification. I see that DAO is not dead.

–Llyal

Gary,

Thanks for the information lead. I was able to get a trial subscription and could read the article. The articles look pretty decent and I may get a subscription to MS Office Pro.

Thank you!

–llyal

I tested the suggested time/date program. It works above my expectations! It does what I want in Windows 2K- display the date and the time together. Highly recommended to others who need similar capability from Windows.

–llyal

Thanks Leif!

I just downloaded it- looks like it will do the job. I read your warnings- if the date and time are “always” displayed, I will be happy. I will find out when I install it.

–llyal

Thanks Charlotte!

The macro idea sounds intersting- might save time. I will look into.

–llyal

Thanks Charlotte! That is enough information for me to work out the solution!

–llyal

Got it, and thanks!

–llyal

I converted Null values to zero-length strings because i was having problems with queries when doing text searches (example, queries with LIKE ‘%info%’). I think the queries would return nothing if i search several fields of a record looking for a string match and one of the fields contained a null.

So this is why I replaced nulls with zero-length string. Now I want to filter this table and make a new table of the filtered data. Well, i cannot insert zero-length strings!

The workaround i am using is- to replace the zero-length with a single-space character. I get the results, but i don’t understand why Access cannot handle zero-length strings in INSERT statements.

Thanks!

–llyal

Charlotte,

I agree, one does not want to push the “natural” limitations of Access and VBA; you only invite headache and lose time.

–llyal