I have a few MS Access 2003 MDB files and I want to search for a string in
the SQL query text of these MDBs. Is there a way to retrieve the text
(source) of a query?
Thanks,

I am updating a large country time zone file. I want to increase the TimeZone
column by 5. For example. Afghanistan's time zone is +0430. I want to add 5
to all records so in this case the time zone will change from +0430 to +0930.
Which means that Afganistan is 9 hours and 30 ...

I'm trying to insert records from a ASCII file to access.
Seen somewhere on the internet that something like this should work :
 'SELECT * INTO MyTable '+
   'FROM OPENDATASOURCE("Microsoft.JET.OLEDB.4.0,Data

Hello. I have already create a program using test records and it is
working (partially thanks to help I got here).
Using larger set of data it soon hits limit of 2 GB in size.
Basic idea is to use one table and connect each ID with each other

I have the following result set...
District    Commune
D1            C1
D1            C2

I have two textboxes with sTime and eTime. If I enter time as decimal how do
I
calculate time.e.g
sTime = 7.00

I've got a table (tblHouseholds) consisting of address information with an
additional field that stipulates the PrimaryMember (head of the household
from a related tblMembers table).
My problem is that as new records are added to tblHouseholds, PrimaryMember

Trying to obtain "Years to Retire" with a query taking into consideration the
following criteria:
Criteria:  If Age is >=55 and 30 years of service then 0 years remaining to
retire OR if Age >=60 and have 2 years of service then 0 years to retire,

I'd like to use an existing table to create a new table.
The existing table contains one record with 82 fields.
In the new table I'd like to create records from the existing
tables' fields - 82 records. I'd also like to create a new field

How do I run a query that displays field names and not captions

Hi, I was hoping someone could tell me where to start with using an update
query in Access. I have a table called AbsenceTable . The AbsenceTable is
updated daily when an employee is absent or tardy. I want comply with our HR
guildlines and send a report to managers of the employees ...

I have a table (tbl125) that holds employees yearly desired contributions to
a medical plan my agency offers.  That desired amount is divided by 26 ( we
are paid every 2 weeks) to come up with the amount that will need to be
deducted from each paycheck in order to reach the goal ...

   I have made a form using too combo boxes (I am using the form to execute
a query and these combo boxes are used in the criteria.)
   Box A has a Drop down list of Countries
   Box B has a Drop down list of Cities

i have a simple function that i use in an update query to add a counter for a
"project number" field.  results as follows:
1530000     1
1530000     2

I have 2 tables that I'm trying to make a new table from with a make table
query.
Ok that's the easy part out of the way.
Basically table 1 has start and end point fields and table 2 has start and