time of link text file 2003 Results


Sponsored Links:



Hi,

In my access database, I have a table link with a text file that auto generate from another system daily on random time. Is any way that I can disappear the time of last time modify the text file on of of my report in access database?

Please advise.

Thanks

Regards




Hello All,

I'm currenly working on a project that requires me to grab information that is kept in our PDM system (Agile), such as manufacture, manufacture part number, compliance, notes, etc. Since I have no way to link to this data (corporate policy for people like me), I've been exporting entire data tables (20K to 40K records) from this program in a comma delimited text file then loading it up into Access via Access' import. When using Access' import feature, I'm able to load the data in a table in the correct format as long as a comma doesn't exist in the data itself. If a comma does exist, in say the notes field, Access thinks that it must go to the next field when actually it's part of the data in the same field. Is their some way to get this to work? I've tried changing the delimator (find and replace in Word, Notepad, and Wordpad) to a special character that I know is not used in our data but this takes a LONG time for the find a replace to do it's thing.

Ideally, I would like a user (myself and a couple others) to be able to click a button, open a text file selected by the user, and then have the file load directly into a specific table. However, this is easier said than done when your a novice user of Access with no VB training and limited background. I don't know how I could do a lot of this, but if I could get the text into a variant or string, I could use MID, LEN, and other easy functions to extract the data to the table. I have a strong feeling that this wouldn't be the best way, but not knowing VB that we'll, I don't know of any other way. Any help or suggestions would be greatly appreciated.

Thanks in advance.
Regards,
Drew




Dear Readers,

Before posting a CMD.EXE command line script related question please be
aware of the information and solutions material already available, such
as

97091 Jun 28 2004 ftp://garbo.uwasa.fi/pc/link/tscmd.zip
tscmd.zip Useful NT/2000/XP script tricks and tips, T.Salmi

In case of grave difficulties in getting this file from Garbo archives
see
Sites with permission to mirror Garbo archives
http://www.uwasa.fi/~ts/garbinfo/garbmirr.html

The contents of the FAQ-like script tips collection is given below.
For more command line script or near information sources please see

http://www.uwasa.fi/~ts/http/http2.html#cmdscript

This file TSCMDIDX.TXT lists the contents of

1CMDFAQ.TXT NT/2000/XP CMD.EXE Script Tricks
in ftp://garbo.uwasa.fi/pc/link/tscmd.zip
Alternatively available with the version number as
ftp://garbo.uwasa.fi/pc/ts/tscmd20.zip

--------------------------------------------------------------------
1} How get today's date elements into environment variables?
2} On Windows XP how do you stop the script files from closing?
3} How can I customize the Command Prompt Window with script commands?
4} How can I test is it on MSDOS/Win3..9x/Me or NT/2000/XP?
5} How do I get a fully qualified path name of my script?
6} How does one get yesterday's date?
7} How can I test if two files agree in size and datetime stamp?
8} How do I find all the files made at of after YYYYMMDD HHMM?
9} How can I suppress script error messages altogether?
10} How can I change the environment variable values within a FOR loop?
11} How do I retain my original code page in these scripts?
12} How can I rename all my .JPG files sequentially in a folder?
13} How do I get the current day of the week?
14} Help! My old batch files won't work since there is no choice.
15} Is it possible to echo without linefeed like the Unix echo -n?
16} How can I get the time without having to press enter?
17} How can I avoid the potential "ECHO is off." in echoing %myvar%
18} How does one build re-usable script function modules?
19} How can one build a delay / sleep / wait procedure for a script?
20} Is is possible to right-justify numbers or words in a script?
21} Do you have pointers to additional script material and tips?
22} How do I capture the current folder name into a variable?
23} How do I get the n:th, the first and the last line of a text file?
24} How do I get the m:th item on the n:th line of a text file?
25} How can I quote with e.g. " " an entire message?
26} How do I get the length of a string into a variable?
27} How can I remove all the blank lines from a text file?
28} How to convert a file written in IBM PC characters into LATIN1?
29} How do I drop the first two characters of a string, and so on?
30} Can one calculate the difference between two times in a script?
31} How many days ago was 31.12.2003? What date it was a 100 days ago?
32} How can I convert a decimal number to binary, octal, hexadecimal?
33} How can I convert a binary, octal, hexadecimal into a decimal?
34} How can I remove the quote characters from a line?
35} How can I substitute the second field on each line of my file?
36} I start a program from my script and it hogs my command window.
37} How can I insert a line in the middle of a file with a script?
38} How can I set and test the errorlevel within a script file?
39} Is there a subroutine to convert a variable into uppercase?
40} How do I get the number of arguments given to a script?
41} How can I create a zero-byte file? How do I test for it?
42} What is the subroutine for testing a filename for wildcards?
43} Is there a way of counting the number of files in a folder?
44} How do I get the first 68 columns from a text file?
45} How can I find out how many days old a file is?
46} Is a program available in the default folder or at path?
47} Is it possible to echo the redirection symbol in a script?
48} Why do some comment lines cause errors? What can I do about it?
49} I need to reverse a text file. How do I do that fairly quickly?
50} How do I get the position of a substring in a string?
51} How can I echo lines in different colors in NT scripts?
52} How can I enter a password into a variable without echoing it?
53} How can I test if a disk device is ready or not?
54} How can I get the type of a disk device?
55} How to get the creation, last modified and last access of a file?
56} How to find and move more recent files from one folder to another?
57} How do I get a list of all my empty folders on c: ?
58} How do I best combine two quoted arguments into one quoted string?
59} How do I find if a folder exists? How about visible files in it?
60} How do I delete all but most recent 20 files in a folder?
61} How can one devise a command line calculator?
62} How can I compare within a script if two files are identical?
63} How to perform a command on each line of file as an argument?
64} How to count the number of lines in a file, empty lines inclusive?
65} How do I add text in front and after each line in a text file?
66} How can I delete all the hidden Thumbs.db files from my system?
67} Is it possible to send a variable value to the clipboard?
68} How can I test if a program already has been loaded?
--------------------------------------------------------------------

All the best, Timo

--
Prof. Timo Salmi ftp & http://garbo.uwasa.fi/ archives 193.166.120.5
Department of Accounting and Business Finance ; University of Vaasa
http://www.uwasa.fi/~ts/ ; FIN-65101, Finland
Timo's FAQ materials at http://www.uwasa.fi/~ts/http/tsfaq.html




How do you set a compilation constant at compile time?
I mean, if I wanted to set the AllFiles constant in the following sub to true, where should I set it?

Sub FileSearch3XP()
Dim sngStart As Double
Dim sngEnd As Double
Dim int1 As Integer
Dim str1 As String
#Const AllFiles = False

'Search in a folder on linked computer
'for files containing ADO
With Application.FileSearch
'Start a new search
.NewSearch
'Set search criteria
.LookIn = "cab2000cBooksArchiveAccess11"
.SearchSubFolders = False
'When searching for text, consider
'restricting the files you search
'*.* can require more time
'than msoFileTypeWordDocuments
#If AllFiles = True Then
.FileName = "*.*"
#Else
.FileType = msoFileTypeWordDocuments
#End If
.TextOrProperty = "ADO"
End With

With Application.FileSearch
'Execute the search
sngStart = Now
If .Execute() > 0 Then
sngEnd = Now
Debug.Print "The file search took " & _
DateDiff("s", sngStart, sngEnd) & " seconds."
str1 = "There were " & .FoundFiles.Count & _
" file(s) found. Do you want to see " & _
"them in a series of messages boxes?"
If MsgBox(str1, vbYesNo) = vbYes Then
'Display names of all found files
For int1 = 1 To .FoundFiles.Count
MsgBox .FoundFiles(int1)
Next int1
End If
Else
'If no files found, say so
MsgBox "There were no files found."
End If
End With

End Sub




Just wanted to share a few lessons I learned regarding use of the Import External Data process. I described my setup in post 617254 - basically using templates as the basis of a new file into which the data from a "source" table in a "source" file is imported.

- my dates, since they had text associated with some of them (eg. I had date entries like a normal "12/10/06" without the quotes as well as "12/11/06 Security Team") had to be formatted as text in both the source file and the template. Otherwise, results seemed unpredictable as I mentioned in above post. Giving up the ability to do "date" math was not a big deal for me since I could have taken advantage of that in only a limited way. If really necessary, create a hidden column upon which you do the date math where the value is the date part of the "text date."

- a general rule that follows from the above seems to be to keep formatting the same in the template and the source file for a given column. I also had custom formats in the source file that were messed up on importation unless I had the same custom format for the corresponding column in the template.

- text formatting for very long character strings (>255) can create problems on importation. I got the #### indication even though text wrapping was on. This happened in both the source and template files. But see next point. I had to switch the formatting to General to even get the >255-char text strings to appear.

- Since you don't know how the rows are going to be arranged based on sorting, which can change based on source file entries, you can't pre-plan the heights of the rows in the template. Format all the rows to be used in the template as AutoFit. Otherwise you get a row that's 1 line high or whatever you set it to. It's bound to be wrong for some row.

- If you have to filter on rows to appear in your output, you may need an extra "dummy" column to specify whether that row should be imported. You need to select that "show record" column when defining the query for importing the data. But best leave that to the end of the fields/columns you want (the query definition process allows you to move a field down after you've selected which ones you want, or go through the fields once and go back to get the fields for "control" purposes like filtering). Putting this field at the end, along with the next point, allows you to hide these columns in the template at one shot rather than having them in several places.

- if you have to sort rows so that your output appears in a way different than the source, this can be defined in the query definition process also. Again you may need a dummy column for proper sorting. For example, we have a status column with entries "Red", "Yellow", "Green", which can change over time. In the output, we want all the "Red" rows to be grouped and appear first, then all "Yellow" rows, and finally all "Green" rows. I had to define a numeric "sort" field as a dummy column that was selected in the query definition process, moved to the end, and imported into a hidden column. (I also used the "status sort" column as the basis for a Conditional Format to actually color the rows according to their status.)

- There's the issue of the source file pathname being hard-coded into the query definition file. This is a pain. There's some VBA code one could get from "Professional Excel Development" by Bullen, Bovey, & Green (page 496) for starters. Put the source file on a share drive so it stays put. Alternatively, you can edit the query definition file if you save it (xxx.dqy is the file) using Notepad since the file is just text with the source file info, the SQL for the query, and other stuff.

- Instead of saving the query as a separate file, it can be saved as part of the file into which the data is being imported (which can be a separate sheet in the source file, hence an advantage over Advanced Filter w/o a VBA assist). Editing the query from the destination file seems to offer limited editing capabilities (you can pick a new source file). There's also a Query Manager add-in by JK Pieterse that allows one to change the source file easily.

- Although I thought some of the import options would have given me what I needed, I found that if I didn't supply enough empty rows for the records to be imported that crazy things started to happen. For example, my imported data starts on row 5 under some col headings provided by the template (I positioned the active cell as A5 in my template so not to forget to reposition the active cell in the new file). I have some general notes starting at around row 20. If I'm importing more than 15 rows, my col headings and notes got pushed to the right to make room for the imported data. Better to create lots of empty rows in the template and delete the unused ones.

- The above works pretty well for creating multiple "reports" (think Access) from flat DBs/tables. The import data/MS Query will not help you define a "report" based on a set of relational tables; it will tell you to do it yourself by dragging the linked field from one table to the other when you see the Query table view (think Query design view in Access). It's not that hard but the message can be overwhelming - what did it want me to do? All it's asking you to do is drag the linking field (like a key) from one table to the other so it knows which field in the 2 tables is the common key.

- When working with templates, it may be necessary to edit them like for some of the above. Double clicking the xlt in Explorer activates the default action, which is to open a new file based on the template. You don't know how many times I double-clicked, edited the file, and wondered where my edits went when I next opened a file based on that template. (Of course, it's not all that bad since I was asked if I wanted to save the file when I was finished and was surprised when I had to pick a file name for the new file based on the template created on the double click.)

- Of course, you may be asking why do this in Excel. Because...people start projects like these in Excel because they like it (I had a friend who used Excel for his word processing and web design). Access is much better. You could import an Excel range into Access, design your report, and export the report back to Excel (why, I don't know). I ran into a problem with this in that exported columns to Excel were in a different order and width than the Access report from which I exported.

- while you're at it, if you have several tables that you import to Access from Excel that are related, you can define your query in Access and copy/paste Access's SQL back into the query (.dqy) file, if you save the query separately per above, that you use for importing the data. You have to be a little careful here and may need to do some editing in the .dqy file. I'm not sure where you'd put the Access SQL if you saved the Excel query as part of the Excel file.

Anyway, that's some lessons learned the hard way.

Fred




I'm adding some new computers to our network that run Outlook/Office 2003. All the older computers are running Outlook/Office 2000. My computer being the first, as the guinea pig for troubleshooting.

Before when using Outlook 2000, when sending an email in Rich Text instead of attaching a file I could attach a Shortcut to a file on a common mapped drive on our network. Everyone is setup to this same mapped drive so there was never a problem. Now with Outlook 2003 that option for inserting a Shortcut is gone and apparently in its place is the ability to insert a Hyperlink in my Rich Text email.

Using Outlook 2003, when I click on the paperclip to insert a file, browse to the file on a mapped drive and choose to insert as a hyperlink, the resulting hyperlink L:adminnmcr2007c020907.pdf looks good and when I hover over it I get the message to Ctrl+Click to make the link work. Also when I hover over it, it tells me the link goes to file://formsadminnmcr2007c020907.pdf That's all fine. But when I send it to any of my Outlook 2000 folks the hyperlink shows up with around it and is unclickable. Ctrl+Click doesn't work for them. If they remove the it's still not a clickable link.

Interestingly enough, if I click on the paperclip to insert a file, browse through My Network Places to the same location on the network, and choose to insert it as a hyperlink, when I hover over the resulting hyperlink formsadminnmcr2007c020907.pdf it reads the same location as the above link file:///formsadminnmcr2007c020907.pdf. When I sent that to an Outlook 2000 user the symbols are again added before and after the link but this time the link works.

Is the latter the only way I can now add a link to an email for a file on the network? It's a lot more steps going through My Network Places. It was a heck of a lot more convenient when all I had to select was insert as a shortcut after browsing to my L drive.

Is there anything I can do to make this easier?




I have copied and pasted using "Paste Special | Link | Text" approximately 30+ date fields and 30+ "% Complete" fields from a "master" project plan (Project 2000). I did not enter all of the links at the same time (i.e., over several days/logons). It appears that all of the links work and automatically update when I open the spreadsheet and select "Yes" (to update the links) EXCEPT for the last group that I linked into the spreadsheet. I cannot manually update these links via the Edit | Links method either. I have checked the "Update Remote References" box on the Calculate tab in the Options, also. At one point I tried to delete some of the links and relink them, and appeared successful, but Excel then skipped those numbers (i.e., link #s 45-47). The files involved are stored on network drives.

Not sure if this is relevant, but I also have Project 2003 installed and force Project 2k file open prior to opening the spreadsheet. I have tried letting Project 2003 open instead, but did not have any better luck.

I cannot post the files involved here due to Corp. IP & confidentiality.

Any help would be appreciated!

Don L.




I have a coworker who has created a spreadsheet with links to an external website. They links keep breaking. She opens the file, makes an edit (not to a link), re-saves the file, and closes it. The next time she opens the file, the links look like links (blue, underlined text), but they aren't links anymore. She has to recreate the links virtually every time she opens the file.

Any suggestions?

I asked if she is changing the location of the worksheet - no

Thanks.




Hello,

I am looking for a macro that will:

1. Point to a folder containing RTF files.
2. Open each and every RTF file.
3. Remove all {SHAPE *MERGEFORMAT} fieldcodes.
4. Remove all fieldcodes containing {INCLUDEPICTURE...}
5. Remove all graphics that are embedded or pasted into the
word document. Another words, any graphic found in the word
documents that DO NOT use a field code.

I have been tasked to remove hundreds of old photos with text boxes and callout arrows on each photo. This macro will save
me a lot of time, if it is possible to create.

Also, if it is not possible to remove embedded graphics via a
macro (see step 5 above), then I will have to remove those graphics manually.

As mentioned before, I am using MS Word 2003/ Windows XP SP2
and all the files have been saved to RTF format.

We have created a new graphic library and will bring in all the new graphics, once the old graphics are removed. I will leave all the original figure titles in the RTF files. The macro only
needs to remove any graphics that are linked to file or embedded.

Please see the attached screen shot, which represents the two of the ways the graphics are referenced in the RTF file. Obviously, there is no fieldcode for embedded graphics.

Thanks in advance for your help.

Regards,

Jim

P.S. Most (if not all) of the graphics in the RTF files are contained inside text boxes. Is there also a simple Macro I can create to globally remove text boxes?




In a fast paced world, three years after Windows 7, Microsoft’s upcoming successor OS, Windows 8 remains a hard sell. Does that mean it is not worthy of the buzz and hype?

Browse a tech magazine lately? Check out a news site about technology? Chances are, you will read something about Windows 8. Just two weeks ago, Microsoft released the Consumer Preview for Windows 8. It hasn’t even hit store shelves yet, and people are already complaining. This is nothing new in tech circles: Everyone is resistant to change. Sometimes, that resistance to change can be helpful, and even good feedback for developers. Other times, it can result in a shouting match that just remains unwinnable. But like many things, thinking in absolutes is often deconstructive, and seldom objective. Business men and women will judge Windows 8 with business acumen; savoring each bit of financial data and sales indicators to prove a point about the new system. Decision-makers in IT circles will look at security and reliability before weighing in with a more structured cost-benefit analysis that deals in infrastructure. Home users are likely to place more value on aesthetics, performance, and ease-of-use as major factors in the upgrade model.

It is the middle of the month: March 15, 2012 to be precise. It is hard to believe that already three years have gone by since the release of Windows 7. Many IT business people, including server administrators, are just starting to become acclimated with the Windows 7 client environment, its off-shoot productivity software, and the Windows Server 2008 family of products, including Windows Server 2008 R2. In one worldview, short and steady wins the race. While more tech savvy companies clearly saw the benefit of migrating quickly upon release, many SMBs, mid-range companies, and home users remain in a Windows XP limbo – either due to the economic mess that most of the world is dealing with, budgetary constraints, or simply a lack of knowledge about how to port all of their important data over to a Windows 7-based network. But as time has gone on, these groups are a minority, for as much as is known. While much of the third world may still be using Windows XP, and even older systems, it is difficult for that data to be chomped up and read by skeptics and true-believers. In agrarian, rural, and largely undeveloped lands, Internet access still remains a commodity that is seldom traded, and where mobile phone companies continue to make inroads.

Back here in the west, the difference is noticeable in how a company conducts its business, especially when you walk into one running Windows XP and Server 2003. It is not uncommon to see pending Windows Updates on every workstation, versus an up-to-date Windows 7 network. If the IT tasks are outsourced, how that time is spent, and for what purpose, will likely face scrutiny and prioritization. For instance, the administration of an important database may take precedence over the application of client operating system updates. Many system administrators may simply ignore, or be unaware of, the capability of domain controllers and file servers to push out updates across the internal network using WSUS. In many offices, however, you will be likely to find a hybrid network. With a lack of EOL policy and strategy, many businesses end up with certain departments stuck between Windows XP and Windows 7, and that difference takes place when they purchase new hardware – not due to a timetable, but out of necessity. A hybrid network of these systems is not exactly the best medicine for either a business or group of home users who rely on their Windows computer systems day-to-day activities, but it may be better than nothing.

A Trip to Seattle: Home to 90’s Alternative Music, Starbucks Coffee, and Microsoft
On April 1, 2011, I received the Microsoft MVP award for Windows Expert – Consumer. It was a real treat to know that Microsoft had recognized my contributions in the form of setting up forum websites and participating in them. I was certainly very thankful for the award, and presumably happy to know that I could continue to do what I do best, as that is why I received it. I wasn’t the first to be recognized by Microsoft for my contributions to my own website: Ross Cameron (handle: kemical) became one of our first Microsoft MVP’s. One of our former members, Greg (handle: cybercore), had contributed thousands of helpful posts on Windows7Forums.com and was nominated. As time went by, we were fortunate enough to see other MVP’s join our website, including Shyam (handle: Captain Jack), Pat Cooke (handle: patcooke), Bill Bright (handle: Digerati), and Ken Johnston (handle: zigzag3143). These people are experts in their field and genuinely reflect an attitude of altruism towards people. Such traits are hard to find, especially over the Internet, and in a field that is driven by individual competitiveness that forces group cohesion as a necessity. I started communicating with one MVP as a result of a disagreement, but have since gained an enormous amount of respect for her: Corrine Chorney, the owner of SecurityGarden. When I made a video that contained an error or two, about ESET Smart Security, I was suddenly contacted by a fellow MVP: Aryeh Goretsky. These types of people live and breathe technology, and thus, even having a brief e-mail exchange can be a breath of fresh air. It becomes recognizable and clear to me that Microsoft’s selection process and choices for those who receive this award is hardly based on pure number crunching, but on gauging a person’s enthusiasm and demonstrated expertise in a field. Understanding how that translates to a much broader audience is compelling. To me, this is a good thing, as it shows that even one of the world’s most successful corporations, in this case Microsoft, perhaps in one of the few acts of selflessness that one could expect from a multi-national corporation, finds customers who have made a mark in information technology and celebrates that. I become hopeful that they recognize the countless others who make contributions on a day-to-day basis. With half a dozen certifications under my belt, and nearly a decade and a half of experience, I am but one person. And for every Microsoft MVP I have met, their dialogue always translated into real energy and enthusiasm. How many countless others have not received an award, or merit, for helping someone “fix their box”? I suspect that number is in the millions. This in no way belittles the award, because to me, such an award really is about helping others.

Often times helping others is giving someone your opinion: even if your opinion runs contrary to running a system consisting purely of Microsoft software. One example is Windows Live: I have a fundamental disagreement about how I chose to use Windows Live, and whether or not I want Windows Live Services embedded into my operating system experience: something that home users with Microsoft-connected accounts will notice almost immediately upon starting the OS. I do not, in any way, undervalue the development of these services, or their potential market value to consumers. I simply have a difference of opinion. And this should no way diminish someone’s ability to receive an award. I am not an employee or pitch man for Microsoft products, but someone who conveys his own thoughts and expertise in that area. To me, the award would have little value if I was expected to tout the benefits of using Microsoft Security Essentials over a paid anti-malware suite. I think that even the developers of the software themselves would take exception to misinformation. And to Microsoft’s credit, they have asked me nothing of the sort. To me, that is a fundamental sign of an award that encourages community participation and expertise in a given area of technology, from a company that is now expected to set standards on the world stage.

Not everyone made it to this summit: For many of them Redmond, WA is far, far away. For me, living in New York, that also rings true. But it sure are the people who make it worthwhile – even when you’ve never met them in person, the way they behave and conduct themselves, towards you, speaks volumes. And so I’ve learned a lot from every Microsoft MVP that I have met – both online and off; in a five minute conversation, or a fifteen hundred word e-mail.

During the Microsoft MVP Global Summit in the Seattle-Bellevue-Redmond area, I had the opportunity to meet some of the most interesting and eclectic groups of people in information technology that I’ve encountered in years. Truly, the revolution taking place around technology in Seattle, and its famous campus grounds located at 1 Microsoft Way in Redmond, is in no way limited to laboratories that are seldom, if ever, open to the public. Quite to the contrary, acclimating with Microsoft’s extensive community of worldwide supporters and individual contributors doesn’t just result in hearing success story after success story (although that is fun too). Of the thousands of people invited to the event, from all over the world, including Japan, Asia, Indochina, North America, Brazil, and the world at large, I found myself welcomed by a remarkable group of individuals. These men and women were of no traditional demographic one would think of – in fact quite the opposite was at hand. At 29 years old, I met kids younger and more successful than myself, who had generated their own start-up firms. I also met much older men and women, who witnessed the transformative nature of technology and got involved, one way or the other. These men and women came from all walks of life, but I am reminded, in particular, of a few of them I met who had a real impact on me. As someone who had come so far to be a part of this event, I did feel uneasy knowing that I was there alone. The individuals I met at the summit were polite, courteous, helpful, and informative. It was not difficult to see why they are considered experts in their field.

Whether the issue for them was something simple, like MP3 players like Zune, the Xbox, MS SQL, or the Microsoft Windows family of client and server products, this entire network of community supporters really outlined why Microsoft continues to have far-reaching success around the world. The level of enthusiasm for their technologies is clear, concise, and breaks down the traditional barriers of race, color, nationality, and gender inequality.

At that summit, I was witnessing not just what technology would be capable of doing in the future, but as a first timer, I got to see with my own eyes what it had done for just about every participant I was able to strike up a conversation with. Having been severely jet-lagged and exhausted from my trip, I travelled all the way from New York City to Seattle-Tacoma airport in a few hours. Having travelled, for the first time, outside of my own time zone, suspended at 38,000 feet in the air, I found myself dizzy, drowsy, and often times downright sick once I got off the airplane. It was something really unfamiliar to me, but in a way, strange thoughts began to fill my head. I realized that in Seattle, it nearly almost always rains once per day. There is certainly less sunlight there than in New York. Perhaps this lack of sunlight had inadvertently made people more likely to turn on a computer and create some kind of innovative programming. It was a silly thought, but staring at the horizon in the distance, I could not help but think about Mount Rainier, Lake Washington, and the land I was now interconnected with. In many cases a landmark home to science fiction, Seattle’s own Space Needle is a national treasure. A marvel of all aerodynamic ingenuity west of the Mississippi River valley, the Space Needle is essentially a giant UFO-shaped tower that is capable of housing restaurants, sight-seeing tours, and shines a giant beam of light that was part of the original design, but was only recently added.

Perhaps, I thought to myself, this is how the term “cloud computing” had caught on. With a lack of major sunlight ever permeating this area, to my knowledge, and with rain and humidity always on the horizon in a constant lake effect, it suddenly made sense to me how the area had become famous for its murky alternative rock grunge music in the 1990’s, the Jimi Hendrix Experience, the evangelical computer programmers, and a number of activities, like concerts and music performances, that are usually held in-doors! In a way, it all made sense to me now, and I spent a great majority of my time taking in the sights, sounds, and hospitality of an entirely different area of the country. The most populous city in the northern United States is also home and origin to Starbucks. It all began to make sense to me that it would be here, more than anywhere else in the USA, that they would need fresh coffee beans from Jamaica available at a moment’s notice. And as humorous and sophomoric as that may read, I still think there is some truth to this.

This summit was my first experience with my Microsoft MVP award for Windows IT Expert – Consumer on the road. It was certainly a bumpy ride, and I did not take advantage of all of the event activities I could have. Windows product group experts and Microsoft employees were available, nearly from the break of dawn to the dark hours of night, to provide on and off-campus sessions to enthusiastic individuals. Looking back, the path was worthwhile. While most of the people I met had embedded themselves in this event for many years, I was certainly a newcomer. Determined to act the part, I tried my best to overcome the massive jetlag I had encountered, and vowed to myself to never eat sushi after getting off of a six hour flight again. Who could not be anxious when arriving in such a foreign place compared to the east coast of the USA? I have certainly flown and driven up and down that area most of my life, visiting nearly all of the north and south, but I had no idea what to expect near Redmond. An acquaintance of mine from Los Angeles was able to help me deal with the insomnia and time difference that comes with this type of travel, and she probably helped me in a way that she still doesn’t know – all from a few text messages. I am constantly reminded that technology itself has made us all interconnected, no matter where we are. At the Microsoft MVP Global Summit, what I did find were individuals, many of whom who had a certain selflessness about them, and a desire, above all things, to learn more, experience more, and help even more.

Upon immediately striking up a conversation with anyone at the event, it was absolutely easy to see how these men and women achieved recognition of excellence from Microsoft. While many young people who attended the event had created innovative ways to help others by setting up websites or studying the inner-workings of the Microsoft entertainment platform, others had been part of the commercial information technology circles and big businesses that have changed the environment of the Internet. I even caught a glimpse of two individuals who appeared to be working for a former web host that one of my websites was hosted on. These businesses, powered by ingenious individuals, have swept the Internet. And while many people appeared to be there as part of a corporately backed package, it was clear to me that most others had made a name for themselves by creating their own platform for innovation and success. Most important, and pronounced to me, was that each and every person there reached that point through acts of selflessness -- for helping others. In each and every instance, you could go around the area and know that you were surrounded by people who could speak your language: whether that be ASPX, XML, C, PHP, JavaScript, or BBCode. While a person there from Asia may not have had any comprehension of what I was talking about if he did not speak English, if I showed him Process Monitor in Windows, I could probably communicate with him on some technical level.

To contrast that, I came home to an environment back in New York where the Windows 8 Consumer Preview had just been released. It was no surprise to me that Windows 8 had been getting some slag for replacing the Windows Start Orb and Start Menu with the Metro User Interface (Metro UI). Windows 8 still has some major feature improvements going for it. This early in the game, there is no question that many of these features have likely gone undocumented, exist under-the-hood, or simply have not reached a stage in development that was acceptable for the Consumer Preview. First, it is important to note that the Consumer Preview is as much of a beta release for public testing as it is a marketing tool for Microsoft. When we examine how this has been released to the public, it is not hard for me to conclude that it is also a way to gauge public reaction to the first serious and inherent differences to the way the Microsoft Windows GUI has been presented – ever. Other operating system releases have taken the idea of the Start Menu and added search capabilities and refined a core concept. Slowly, but surely, we see an improvement that has occurred over time, with the look and feel of Windows remaining consistent over the ages.

The Consumer Preview Was Released To Test Your Reaction; Not Just The OS

In fact, this is a public release of Microsoft Windows to appear in limelight, in what is essentially a beta (and presumably near release candidate stage), with some features either completely omitted or broken. But not all is lost for Windows 8. There are some under-the-hood changes that show promise. I am not a Windows developer or programmer (most of my tinkering involves Linux, C, HTML, PHP, and JavaScript), but I can start to appreciate the level of changes that are being made on a core level as I get more time to become acquainted with this system and allow various whitepapers and documents to enter my lexicon.

Those looking to upgrade, or who will receive the upgrade already as part of a plan, like Microsoft VLK Software Assurance, will reap some benefits by making the upgrade to Windows 8. Businesses that have been around long enough will be familiar with creating and following a comprehensive End of Life (EOL) cycle plan. Such plans are usually coordinated between an enterprise administrative team that manages the day-to-day changes of internal certificate authorities, domain controllers, and mail servers. This group usually (and hopefully) has the training and forethought necessary to look at the official Microsoft release timetable, as well as the support for commonly used hardware and software. Assessments can be made to better understand how, where, when, and why this software and hardware is deployed, and under what conditions it is upgraded or phased out entirely. Not only does this level of planning bring clarity to what could otherwise become a source of enormous administrative overhead, but it also helps to mitigate the risk associated with allowing systems to continue running under-the-radar and without proper security auditing. Under such a scenario, businesses may choose to have their internal IT department perform network-wide audits of all systems. It is an affordable alternative to bringing in an outside specialist, and comparisons with Microsoft’s official support timetable can help make the transition to new hardware and software – as well as what comes with that -- such as training and significant infrastructure investment -- a more conceivable possibility.

Home users can depend on a much more simple approach, and that is to monitor requirements needed for tasks like school, work, and entertainment, while keeping up-to-date with Microsoft’s in-band and out-of-band security patches. As mentioned previously, Microsoft already publishes a roadmap to indicate when mainstream support, and even updates, will be terminated for their operating systems. Combining all of these ideas together, it is not unreasonable to come to a conclusion that one can continue using Windows 7 for a few more years without much difficulty. When the time comes, an upgrade will be made easy, as the large system manufacturers and independent system builders will, no doubt, bundle OEM copies of the system after RTM (“release-to-manufacturer”). On the side, one could begin to upgrade a small office or a home network with new computers when the need arises, in order to take advantage of the new feature set that is sure to be setting a precedent going forward.

Very large enterprise networks usually already make use of proprietary, custom software and hardware. Those businesses can begin the transition planning in phases, and will have access to fully licensed Microsoft support personnel who work in the corporate sales division of the company. Those resources can be accessed by standard enterprises (approx. 200 clients systems) and by mid-range offices (approx. 50-200 client systems) using Microsoft Gold Certified Partner program members that also specialize in employee training, resource management, and all-inclusive maintenance plans. Even a few well-trained and certified IT consultants and managers could handle a migration and post-migration scenario with the right level of planning and funding.

Stay positive, here is some deductive reasoning as to why not all is lost, and how the feature improvements that Windows 8 customers will benefit from may actually start to appear after the OS hits store shelves. (The kind of stuff that may not be readily apparent in the incomplete Consumer Preview version):

Virtualization Scores A Win

Hyper-V Virtualization included in Windows 8 will allow you to take your computing experience to the next level. If you are not entirely enticed by the prospect of running Windows 8, or still have a co-dependent relationship with legacy applications, Hyper-V will be sure to help you in that area; much like Microsoft Virtual PC brought Windows XP onto the desktop for many Windows 7 users. While Hyper-V isn’t about to take the throne away from VMWare’s line of virtualization products just yet, especially Workstation and ThinApp, expect to see the inclusion of Hyper-V as an experience that has the potential to compartmentalize the installation of applications – even really old ones. With Hyper-V and Metro as platforms likely to be directly controllable and manageable from Windows Server 8, IT admins can rejoice at the concept of virtualizing what is left of the desktop – and preventing inappropriate use of computer system resources at work. With full control of Metro and Hyper-V under Active Directory, system management is about to get a whole lot easier. Windows 8 fits as the one OS that office managers can control directly from Windows Server 8 without remorse. Limiting access to the desktop will reduce headaches for employees who may only be obligated to launch specific company-approved Metro apps.

Metro: The User Interface Revolution
Metro UI will not be alien to anyone who is old enough to remember Microsoft Encarta, or to any youngster who has already owned a Windows Phone. I still remember using Microsoft Encarta’s slick navigation system to look up John F. Kennedy’s 1961 inaugural address. This was one of the first times I saw decent video footage in an encyclopedia. Back in those days, everyone was on dial-up, and an encyclopedia like Encarta was the be-all and end-all of factoid finding for non-academics and kids still in grade school. So expect Metro-powered applications, programmed in C++, C#, HTML, JavaScript, and even VisualBasic. This programming platform, dubbed, Windows Runtime or WindowsRT for short, is object-oriented and just getting started. With enough knowledge of HTML and JavaScript, many people out there with limited knowledge of C++ could create some pretty snazzy object-oriented apps that make use of jQuery and YUI hosted over the web. With the launch of the Windows App Store, don’t be surprised to see some amazing third party apps put long-time industry staples to shame. Once you start looking into the development platform for Metro, then you start to realize that it isn’t just a gimmick for touch screen users. Ostensibly, a great deal of time developing the .NET Framework is about to pay off, in bundles, for everyone who starts using Metro.

Gamers Not Doomed; HID Development Pushed Forward by Windows 8 OS
Gamers likely won’t be left out of the picture. Metro apps are designed to run in full screen, and as all hardcore gamers know, most high intensity games actually throw you into full-screen mode any way. The difference is likely to be negligible, but who wouldn’t like a concise way to manage all entertainment software and keep it running in the background every once in a while? Single player games that enter the market as instant classics like TES: Skyrim could suddenly appear more interactive in the future. Don’t be surprised to see some form of Windows 8 incorporated into the next version of Xbox (Xbox 720?) with DirectX 11 support. It would be nice to see cross-compatibility with the Xbox and Windows PC. Imagine if you could run any console game on a PC and vice versa: Now that kind of unification would prevent a lot of people from buying all those Media Center extenders and going wild on home entertainment systems. Only time will tell how far Microsoft will take us down the rabbit hole. For gamers, that is a great thing.

Multi-monitor and multi-touch support will bring Windows 8 to tablets and phones like never before with certified Metro applications that are programmed for Windows Runtime (WindowsRT). Expect a lot to happen in how we use our desktop and laptop systems. While major advancements in human interface devices are years away, it appears to be one of the major cornerstones of IBM Research and Microsoft Research. Unification across platforms is a recipe for redundancy, but in the case of sensitive data, redundancy is a very good thing. We want to be able to access our office files from home and our home files from the office, without necessarily having to do cartwheels with third party software. The integration of SkyDrive, and ultimately, shell extensions for third-party apps like Dropbox, is a given. Microsoft is never going to take over the cloud-hosted backup market, but they could pull off a pretty neat way of sharing, updating, and collaborating on projects between tablets, phones, desktops, laptops, game consoles, and more. Kinect for Windows is going to be scoffed at in the beginning, but once everyone has such a device linked up to their monitor, moving your hand around to change the active Window on your computer isn’t going to be that bad of a trade-off. In 2009, I gave a speech to a number of people in the public sector about what I saw as the cornerstone for future technology. That presentation included the fact that a device like the SmartBoard would be obsolete within five years’ time, due to the decreasing price of touch screen computers, and the ability for computing devices to detect human movement. While it didn’t go over well with the locals, it is happening, right now. That is something to be excited about. Whatever touch screen advancements Microsoft introduces with Windows 8 will once again push the hardware market to accommodate the software. This means all sorts of new human interface devices are already in development, even from third parties (see: Google Goggles/Google Glasses as one superlative example).

A New World for Software and Hardware Development

It’s not just a Microsoft world: Software companies, game studios, and all sorts of IT companies depend on the reliability and performance of Microsoft products and services, even when their customers aren’t in Microsoft Windows. This happens whenever an e-mail passes through an Exchange server, or a large database is designed for interoperability between a metadata retrieval system and Microsoft Access. Companies that specialize in document management, database administration, and even brand marketing will reap massive benefit from an interface that contains a display mechanism that has the potential to plot and chart raw data into something visually understandable. For example, if I tell you we ordered a hundred pizzas, each consisting of eight slices, and we only have 10 minutes to finish 25 slices, you’re going to wonder how many pizzas we have left. Once data entry software, even stuff that was initially designed with a Mac in mind, is designed for Metro, we’re not just going to be able to see how many pizza slices we have left – we may have the option to order some extras, or watch other people eat the ones left in 10 minutes. It’s that kind of world we’re delving into. We don’t see how great Metro can be: Only because software companies known for their great innovative capabilities like Google and Apple are just getting started on WindowsRT and Metro. This stuff is not going away, and when all the great innovator’s in the world get involved, we’re going to see sparks fly off the third rail.

Negativity Bias
Many people who try the Windows Consumer Preview may be inexperienced with running beta software. And when your whole operating system is a big chunk of bugs, in many cases unbranded, and in some cases feature incomplete, there is going to be a heck of a lot to complain about. I admit that I’m one of them. Take a look at my post about Windows 8 being a platform to sell Windows Live connected services. Well, of course that is what Windows 8 is, but it has the potential to be much more. Studies show us that, on average, people tend to remember a negative outcome 2.5x more than they do a good one. That means you’re 2.5 times more likely to remember when you got a bad haircut then when you got a good one. You’re 2.5 times more likely to dwell on the day you lost your job, than you are to remember the years you spent at the very same job when you contributed an enormous amount of productivity to the company’s bottom line. You’re 2.5 times more likely to remember that turbulence on the airplane. It was unbearable for ten minutes, and now you’re 2.5 times less likely to remember the time you struck up a great conversation with someone on that long flight. You’re 2.5x more likely to remember that woman or man who rejected you on that first date then you are to remember the laughs you shared going into the restaurant. This negativity bias is something we usually learn about in the first or second year of undergraduate psychology, but very few of us even remember or know what it is. In general, your body is trained to remember when bad things happened more than good things, and actually dwell on it. It is truly a response from the Stone Age, and is a very healthy response. It keeps you in balance. But in today’s high tech and demanding world, it can be taken too far.
So yes, we can look at Windows 8 and positively say, “Maybe this thing won’t be so bad. Maybe I can learn it, and enjoy it.”

The True Test: Greater Than The Sum of Its Parts?

Don’t forget that Windows 8 will include a Start on Demand model for all system-related services. For years, I found myself sending Windows XP, Windows Vista, and Windows 7 customers to a web page called Black Viper (BlackViper.com). This site contained detailed guides on how to configure your Windows operating system to use as few services as absolutely necessary. That site became especially popular during the Windows Vista release. Essentially, the site goes through every single service running on your system and will tell you, not only what the default start setting is for it, but how best to optimize it to suit your needs. If you were trying to squeeze every last drop of performance out of the operating system, without much care for its ability to perform certain operations, you could always use BlackViper’s “Service Configurations” lists to decide whether or not it was safe to make sure that something like the Distributed Link Tracking Client service or the World Wide Web Publishing Service could be completely disabled or not. If I haven’t lost you on this one, Microsoft has come up with a novel solution that is sure to improve your experience with Windows 8, and that is by using “Start on Demand”. Under Start on Demand, when Windows 8 needs a service, it launches it – only when. So that, in and of itself, will save resources. And when we look at what is coming up with memory deduplication, we are looking at true advancement in operating system performance at its most basic level.

Yes, the Consumer Preview is flawed, but for all its flaws, let us all think about these things and realize that the best is yet to come for an operating system ahead of its time.




OK, this is a total newbie q, but I can't seem to solve it on my own. Though the solution must be obvious.

Situation

I have a table named tblActivities. Fields in tblActivities include lngzLocationID#, intPriorityID# and intStatusID#. Each of these fields is joined to a lookup table with two fields, a numeric index number and a text descriptor. E.g., tblLocationLkUP has field idsLocationID# and field chrLocationName. tblPriorityLkUp has field intPriorityID# and filed chrPriorityDescriptor. idsLocationID# can take on any long integer value >= 0. Each value is uniquely associated with a text description of the location to which that value refers. Same for intPriorityID# except that it can only take on the values 0, 1 or 2, corresponding to chrPriorityDescriptor values of "Low", "Normal" and "High", respectively. Similarly with tblStatusLkUp (0, 1, 2; "Pending", "Completed", "Abandoned").

Each of lngzLocationID#, intPriorityID# and intStatusID# is linked to the corresponding field in the appropriate look up table. Referential Integrity is required. The joins are one-to-many (tblActivities one, look up tables many) with all occurrences in tblActivity selected but only corresponding entries in the look up tables selected.

Problem

Every time I try to enter data into tblActivities in datasheet mode, I get error messages. (This appears not to be the case if I accept the default entries I have set up for the number fields, but that's an aside.) Specifically, if I enter a number, I get a message telling me "The text you entered is not on the list." This seems to be referring to a drop down list that appears when I click on the field. The dropdown list is populated with the _text_ entries I have made in the look up tables (although the links between tblActivities and the look up tables are via the Id# fields).

If I select an entry in the dropdown list I get the error message "The value you entered isn't valid for this field."

This is all a tad confusing. I'm sure what I'm doing wrong is trivially easy to correct, but I haven't hit on how just yet.

HELP!




I fully understand that it's unwise to store images in an Access database. (Bloat and all that.) Well, along comes Office 2007, and it appears that this latest version of Access has at last solved the problem. But has it...really? Is it still a better practice to store the path to the JPG file as text in the table and link to it?

One more thing: I've tried several times to place an image control on an Access form. Every time, once I've drawn the image control on the form, Access opens a file dialog box and insists that I tell it where to find the image that will display in the control. I've un-ticked the control wizard, but this behavior persists. How do I insert an unbound image control?




When I go to insert a hyperlink in a Word file, I select the text in the file to be linked. then click on the hyperlink icon. A dialog box appears in which I can go to the file on my computer, or Internet location, to which I want to link. If I click on that, or type something into the field at the bottom, I have a link and then the dialog box closes. BUT I have three problems:

1) The dialog box doesn't remember the last place I went, every time I open it, it opens into the folder holding the file from which I am linking. This is a big pain if I want to create links to a number of files in another folder or on a Web site. Any way around this?

2) Worse, I tried to save time by typing Alt+F9 to view the fields in my document, including the hyperlink fields. I then would create a hyperlink field by typing one character into the the space at the bottom of the hyperlink dialog box. Then I would paste in and hand-type the path and filename I wanted into the hyperlink field displayed in the text of the document. Lo and behold: when I go to use that hyperlink, it still llinks into what I typed in originally, though if I use Alt+F9 to view the hyperlink fields in the text again, they show my final, edited version! Word is SHOWING me one thing but DOING another!!! Nasty. Any way around that?

3) I used the Word PDF maker to make a PDF from the file, and when I click on links in the file for which I have selected "New Window", (appearing as "/t_blank" in the hyperlinks in word, the link appears in the same window that the PDF was in rather than in a new window. Any way around that?

You may view my PDF with these issues at

http://www.john-s-allen.com/research...87/Berlin5.pdf

and the Word file at http://www.john-s-allen.com/research...87/Berlin5.doc

Note what happens when you click on Table 23 or higher in the Table of Tables. I don't know whether you can view the hyperlinks using Alt-F9 but give it a try.

Thanks.




When opening a hyperlink from within Outlook (usually Outlook 2003), have you encountered the dialog box titled Locate link browser? I've encountered this irritation more than a few times in Firefox and finally found a solution.

Microsoft explains this as behavior that occurs when an error is returned by the default web browser when opening links from within Outlook. That may be so, but they do not include this simple fix. So much for interoperability.

Open Folder Options from an Explorer window or the Control Panel
Click the File Types tab
In the list that appears, locate and click on URL:Hyper Text Transfer Protocol (this will be near the TOP of the list, not alphabetically sorted)
Click on Advanced
Double-click open
Clear the checkbox next to Use DDE
Click OK to return to the previous dialog
Click OK again to return to the Folder Options dialog
Repeat this for URL:Hyper Text Transfer Protocol with Privacy[/list]If you revisit these file associations later, you will notice that "Use DDE" is again checked, but now the correct association appears.




(We use Word 2003 SP2. All files live on a shared server that we access through our WinXP laptops and company network.)

To facilitate speedy document creation we created a template called Lab_Modules.dot. At the top-right corner of that template's header is the italicized place-holder text Exercise Name, which we manually change to match the title of each document we create with that template. We have created dozens of two-to-five-page files with this template, and on each page of every file we have carefully replaced the dummy header text Exercise Name with that file's actual title.

After we Insert as Link several of these files to create our finished lab document, we notice that the headers in a few (but never all) of the sub-documents we inserted as link have lost their title name and that the dummy text Exercise Name has mysteriously returned. Because we have dozens of these short sub-files, and we typically string together ten to fifteen of them (using Insert as Link) to create our library of finished lab documents, we are puzzled by the seeming randomness of this behavior - it does not appear to be restricted to a select few sub-files. Can you tell us how/why our dummy header text is returning and how we might fix the problem?

Thank you for your valuable time,
Curtis




Here's the problem:

The following error message appears every time I attempt to open a
particular piece of software. This is an exact copy, including all
punctuation:

---------------------------------
Run-time error '2004':

Out of memory.
---------------------------------

The software in question is titled:

---------------------------------------
Reparaturanleitung
BMW 628csi-M635i, Baujahr 75-89

Repair Manual
BMW 628csi-M635i, Model 75-89
----------------------------------------

It was published by BMW Mobile Tradition, printed 1/2002.

The CD-ROM is marked with the following, which appears to be a product
identification number:
D-80788

The software is a BMW repair manual on CD-ROM, with both English language
and German language formats. Although the illustrations used are PDF format,
they are not organized or numbered in any particular order. Also the text is
not PDF, so although a picture is worth a thousand words, it's hard to
diagnose or repair a car without written instructions...

The software is organized as a some sort of database, which links the
technical information, illustrations, etc. by a system which resembles
internet hot-links (for lack of a better description), based upon the topic
of interest selected from various menus.

The back cover has the following requirements/compatibility list:

-------------------------------
Operating System:
Windows 95, Windows 98,
Windows NT 4.0, Windows NT 2000
Windows ME, Windows XP

RAM:
32MB

Graphic:
High Color (mind. 32768)

CD-ROM Drive:
8-x Geschwindigkeit / Speed
-------------------------------

This is my computer's current configuration info* (taken from msinfo32):

-------------------------------------------------------
OS Name Microsoft Windows XP Professional
Version 5.1.2600 Service Pack 1 Build 2600
OS Manufacturer Microsoft Corporation
System Name [XXXXXXX]
System Manufacturer Dell Computer Corporation
System Model Dimension 4550
System Type X86-based PC
Processor x86 Family 15 Model 2 Stepping 7 GenuineIntel ~2524 Mhz
BIOS Version/Date Dell Computer Corporation A08, 9/23/2003
SMBIOS Version 2.3
Windows Directory C:WINDOWS
System Directory C:WINDOWSSystem32
Boot Device DeviceHarddiskDmVolumes[XXXXXXX]Volume1
Locale United States
Hardware Abstraction Layer Version = "5.1.2600.1106 (xpsp1.020828-1920)"
User Name [XXXXXXX][XXXXXXX]
Time Zone Eastern Daylight Time
Total Physical Memory 1,024.00 MB
Available Physical Memory 644.13 MB
Total Virtual Memory 3.40 GB
Available Virtual Memory 2.80 GB
Page File Space 2.40 GB
Page File C:pagefile.sys
----------------------------------------------------------

*NOTE: I edited the identifyable information from the text above when
copying, but otherwise it is exact.

------------------------------------

WHAT I HAVE ALREADY TRIED:

1. Attempted to install CD-ROM Repair manual to other computers. Installed
on 1 XP Laptop with 512MB RAM, no error. Installed on 1 WIndows 2000 Desktop
with 64MB RAM, no error.

2. Backed up all files I wanted to keep, scanned them with Norton AntiVirus
Corporate, then put them aside.

3. Completely wiped both my hard drives, including writing zeros to the
entire disks surfaces to ensure I had no leftover corruption.

4. Reinstalled Windows XP Professional, with no additional software--just
my basic drivers, and the software with the problem. Error message remained.

5. Downloaded and installed all available "Windows Update" files, service
packs, etc. Error message remained.

6. Reinstalled the Windows XP Home edition which came with my computer,
configured it as in numbers 3 and 4. Error message remained.

7. Completed steps 2 thru 4 above again, then removed one of my 512MB
DIMMS. Error message was not displayed, and the program worked fine.

8. Reinstalled the second 512MB DIMM, and the error message returned.

9. Downloaded and installed evey patch for "Visual Basic" I could find here
at Microsoft (which seemed to be related to Run-time or Out of Memory
errors). Error message remained.

10. Reinstalled the rest of my drivers, software, etc., and put my
backed-up files back on the hard drives.

11. Contacted Dell Support's Online Assistance. The technician worked with
me online for about an hour and a half, but couldn't solve this either.

12. Attempted various "Virtual Memory" settings. Set virtual memory to the
maximum allowable amount for each of my basic hard drive volumes, as well as
my third "Striped" drive, but the error continues, as long as I have more
than 512MB of RAM.

13. Contacted the product's vendor via e-mail. Still awating a response.

----------------------------------------

As best as I can tell, the software was developed using an older version of
"Microsoft Visual Basic for Applications" version 6.0 (I'm not sure exactly
which variant of 6.0 it is). There are DLL files from MVBfA, and .gid
database files which also are associated with MVBfA on the CD-ROM.

I don't want to keep opening my case repeatedly, to connect and disconnect
my memory cards, since the additional RAM accelerates many of the other
programs I enjoy.

QUESTIONS:

1. Is there any other way to fix this? Everything I've found on
Microsoft's site applies to older versions of Windows. I can't seem to
locate a solution for XP.

2. Is there any way to temporarily "Switch off" or "Disable" one of the
DIMMS electronically, then "Re-Enable" after I'm done with this particular
software?

3. Does anyone know: Has Microsoft addressed this issue yet--or do they
plan to?

4. Can someone fill me in on how Microsoft's Online support works?
a. Do you have to pay for on-line assistance--even if the problem is
caused by the incompatibility of Microsoft's own products?
b. What if the technician can't fix the problem? Do you have to pay for
support--even when the problem can not be solved?
c. Realistically, how much does it really cost?
I. What if I spend one and a half hours on-line with their
technician--like I did with Dell Support? How much would that cost me?

I'm not gonna hold my breath on this one, but some of the advice I've seen
here is quite impressive! Maybe one of you REAL tekkies can help me out!

Thanks!

___Tklop