Recent content by ykfc

Mine has the same version for Access and Outlook. However, the kb article of MB does help.

My Access module is supposed to start automatically but running a batch file. This could be achieved easily by specifying a /x switch with the name of the macro and to put this command line inside a batch file. For example, "c:\program files....\MSACESS.exe" c:\myProgram\aaa.mdb /x startMacro...

In the office we purchased a number of well-known brand PC. They arrived with WindowsXP pro pre-installed, each bearing a sticker for COA. I set them up a few months so I know them. Recently (few weeks ago) I was given a task to upgrade some WinNt/Win9x PC for WindowsXP. We don't have a...

Our Win9x boxes are actually all Win98 now. I couldn't even recall any one of if these simple stations has ever got a problem because we forget to run Windows Updates. They are just rock-solid reliable, due to the simplicity of the application it runs. Personally I favour not to upgrade them...

Assume there are 3 parties: a small number of users out of a large group of Corporate users, application developer designing and selling the intranet application to this small user group, and the Corporate IT system Administration team. IT System Admin say: Hey, we don't want to see any Win9x...

Well, in the company I work for we're still having quite a number of Win9x stations. The operators of these workstations run no PC applications other than entering data onto a web-based application. Sort of ASP hosted internally (in other words, purely intranet application). People say...

SkipVought, I don't think it is correct, unless I made you mis-interpret my question. We have Oracle installed only in one Unix Box. A few Windows PC were already installed (not by me) with certain software to allow application written with VBA codings and accessing Oracle data in the Unix via...

No, help again. I do not have the required Oracle client installed in the pc yet. Is this component readily downloadable free? Oracle is installed and maintained by another team working globally for our company. Can someone tell me how it works in regards to licencing Oracle client software...

Maybe the question is not clear enough. I doubt if my pc has got the required odbc driver to make the above codes to run. When I tried to create a system DSN and pick "Microsoft ODBC for Oracle" as the driver, Windows XP prompts me with the following message: "The Oracle client and networking...

To access Oracle data via ODBC and writting application using VBA codes (Windows Environment), what client software do I need to install? Thanks.

I need to create a command file (batch file) and run it from the command prompt. I am familiar how to create this. However between two particular command lines, I want to insert a time gap between them so that the second command is only run, say one minute after the first one. Insert of...

My stored procedure, say sp_aa is a sysobject of Database a. Can I code in sp_aa to invoke another stored procedure sp_bb that is a sysobject of database b? If yes, what is the syntax?

Examining the properties of the table sales in the pubs sample database (MS SQL 2000), I notice the salesID column has the data type tid. What is that? I read the chapter "data type" in BOL but get nowhere.

Thanks for reply. "What sort of processing?" Retreive certain records. Processing of each of the retrieved record includes: 1) get other data from other database and/or table to retrieve other values 2) use the values as parameters to run Crystal Report 3) update another table in the same/other...

I've used to process multiple rows data return by sql select statement, using vb or Java codes. As usual, it is just looping through the result set and process the data one record at a time. Can people employ Stored Procedure alone to do row-level processing? I did some research from the web...