Search results for query: *

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...

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 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'...

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.

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...

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...

I imported some data from an exernal text file. However, MS Access re-sorted the sequence of my data. E.g. Original Text File : 01, 02, 03, 04, 05, ....99, 100 After import, Access Table : 90, 91 ....100, 01, 02, ....98 How can I maintain the original order of my data in the table...

Let me try to explain this as clear as I can. Hopefully it does not sound too complicated. :) I have a report that prompts the user to enter a student name. Suppose John is being entered, what is displayed on the report are the info on John. There are 2 pages of report, and it shows 'Page n...

Currently, I have a query that prompts the user to enter name (e.g. Enter Student Name), which it will then list down the student information as defined in the query. How can I customise the query in a way that when I left the prompt blank or 0, it will return me the names of all the...

I need to write a simple batch program to rename some files, based on system date. Can someone provide me some useful links where I make reference to? Appreciate it lotz. :)