1. It cleans up its own garbage; No "Set RS = nothing" is required;
2. OpenSchema provides me from Code or Script any information about my
Database of which I can think;
3. The provider for Internet Publishing gives me a very slick FTP

I'm familiar with Shift + F2 to view the data of 1 field in a separate
window -- very useful for editing long text fields. In Paradox, there
was a keystroke or menu item that displayed all fields and contents in
a separate window, although scrolling down was required to see all of

We have an access app (both front & back ends are in access) that runs over
win server networks. There are now more and more users who would like to
take away a copy of app with them, work offline, and when they come back
expect the client copy to sync (both ways) with the server ...

I have an Access database that needs to be compacted and repaired
almost on a daily basis. It is the front end that needs to be fixed, so
other users cannot get into it when the problem happens. This is
driving me nuts and needs to be resolved.

Need help with the right statement for the following situation.
In Access97 I have a Form(frmComplaintUpdate) which has a Tab
Control(called TabCtl987) with several tabs(first tab we'll call
tbComplInfo).  tbComplInfo has a subform(sbfrmComplaintInfo), on it,

I am having trouble populating text data that represents data in my
table.  Here's the setup:
There is a People Table (name, address, phone, ...)
 peopleID = autonumber key

I wonder if I am taking a shortcut that may create problems.....
I have an mdb that has an ODBC link to data on a SQL Server. I created the
link using a dsn file.
File -> Get External Data -> Link -> ODBC -> DSN file -> etc

I have an application that use a lot of tables.
All those tables are located in 4 different mdb files.
I am wondering would it be better to put all the table in the same files?
What are the pros and the cons?

I have a database of a bunch of contractors who have signed a safety
agreement with us, their contact info, their insurance info, etc. Each
was assigned an ID number as the main key.  Each contractor agreement
has an expiry date.  I have a report that lists the contractors and a

I am using Access 2002. WinXP, Template from MS called Orders Mgmt DB.
I have tweaked this DB to work for our small co.
It has worked pretty well up until I made the mistake of deleting about
80 records from the Orders table.  80 out of a 1000 records.

I am using:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
lcQueryName, strFilePathNamE, True
...to export my query data to an existing excel workbook. Then what i

I have a problem trying to transfer text to a file.  I need to include
periods (.) in the file name, but it keeps changing them to pound signs
(#).  Here is what I have in the 'File Name' field:
="c:\38XW71.01.ADF.0001." & Format(Now(),"mmddhhnnss") & ".txt"

I'm designing a database which will store test data from a scientific
instrument. There are approximately 300 variables which can be
collected from this device, although not all tests will conatin valid
data for all variables. Because of this, would it be best to create a

    On one of my forms I display a histogram representing the status
of jobs in our factory.  It's configured as a stacked bar which I
create using labels of different background colors.  75 labels are
arranged in, up to, 15 vertical bars representing different customers.

I am using Access 2002. WinXP, Template from MS called Orders Mgmt DB.
I have tweaked this DB to work for our small co.  It has worked pretty
well up until I made the mistake of deleting about 80 records from the
Orders table.  80 out of a 1000 records.