Recent content by robWhitz

Hi, Just realise that 1 of the worksheet contains lot of redundant data. This causes the usually huge file size. Once removed, the file size shrunk to an acceptable size. Cheers....

I have created a macro to tabulate raw data in Excel. However, I'm pretty puzzled by 1 thing. How is it that the filesize grew to such a tremendous size, approximately 20MB, after executing the macro? If I were to tabulate the data manually, the filesize does not exceed more than 200kb. Is...

Hi, I have configured SQL Server to activate a trace at every server startup. The main objective is to audit all critical events on the DB. One thing that I would like to clarify is: - Suppose the trace file 'TraceA.trc' already exists in the directory. When the DB is re-started, new events...

Hi, The tables are actually updated via a third-party application which I do not have much control over it. That's why I need to find out exactly what tables are being updated by the apllication. For your 2 options, how can I go about setting it up? Thanks, Audrey

I need to find out a couple of things on a daily basis, mainly for backup reasons:- - How can I determine which are the tables that are updated on the current day? - If such table exists, which database does it belong to? Is there anywhere I can automate this, so that it will show me a list...

Hi John, Thanks for your reply. But just 2 questions:- - If I were to remove guest from all other databases except master and tempdb, it does not resolve the issue on the default login. Can I change it? - If I were to revoke guest from accessing master, what are the implications? Cheers

Hi guys, I executed the stored procedure 'xp_loginconfig' in the Master Database. It shows that the default login for the database is 'guest'. This is a security concern, as allowing 'guest' is as good as allowing annonymous access. A couple of questions here:- - Can I delete the 'guest'...

errr... Could you guide me to how to activate the package and deployment wizard? I can't seem to find the option in VB. TIA.

I encountered this error "Component 'MSADODC.OCX' or one of its dependencies not correctly registered: a file is missing or invalid" when I attempt to run an excutable on a machine without VB installed. However when I execute it on my macine with VB, the program runs smoothly. Am I...

I have forms, reports, queries... created in an Access DB. However, I have a concern on the security. How can I prevent the users from accessing/modifying the forms/reports/tables...? The users are only allowed to do data entry, import, export, and report generation. Please guide me.

Hi LonnieJohnson. You first suggestion is great. But I have quite a number of tables to delete, so that means I have to maintain a couple of make-table queries. I will keep this in mind for my future works. As for the second suggestion, I have a counter in the table. So, if I were to...

Thanks, mikehoot. It works just fine. I have implemented that and using it without a problem. :o)

Currently, I have a macro that does a couple of things. 1) It deletes an table (e.g. Table1). 2) Then it imports all the data into a new table call Table1. However, when the macro is cancelled, I will have an error when I try to re-run this macro. Error occurs because the macro was not able...

Hi Catadmin, by doing what you suugested was more to move the data fields from 1 part of the page to another. Please correct me if I'm missing a step here. What I hope to achieve is as follows:- Country Name Country Name Cty1 PersonA Cty3 PersonE Cty1 PersonB...

I have a report that display 2 fields, e.g Country, Name. As it is only 2 fields, it only occupies the left-half of the page. I would like the information to flow from left-half, to the right-half of the page. When the whole page is filled up, it will flow to the left-half of the 2nd page...