I've been told I can link MS Access to SAP's Business
Warehouse.  I have linked Access to SQL Server using an
ODBC connection.  Is that the same process I would use
for SAP's Business Warehouse?

I am querying actual flat text files our company calls a database using
access 2000. The company has similar file schemas on different drives so to
get similar data for a our clients we have to run the exact same query on
mulitple drives IE I have 10 different queries that are ...

Hello,
I have created a main switchboard in Access 2002 that contains links to
sub-switchboards.  My question is how do I change the layout design of
the main switchboard without affecting the design of the

How do I change back and forth between my e-mail and my wife's e-mail??

Hello, I've got a pretty general question but I'll try to relate it to a few
specific situations.
*Is it possible to design the structure (i.e. the fields in my tables, the
layout of forms, the queries, etc.) of my database, then selectively "load"

I am new to ACCESS and want a field that a user can enter in info. which will
search my database and then bring over specific info. related to that search
criteria.  I understand the query side of it, but not on the creation of such
a field nor the macros that might have to be ...

I have a text field that has the folling data:
6868- 1
6560-  2
6566-2

When I start a Memo using Word Pad and then store it on my Desktop for future
completion,  then when I return the Memo so I can complete the text I cant
add any wording as I try to complete the Memo.    

I understand that in Excel, there are formulas used to calculate values.  I
don't understand how to use expressions and I just want to calculate a total
- simple addition - for columns.

I have a form which I want to show in spreadsheet format.
I changed the view property to 'Datasheet'. When I open
this form in the Database window, I can see it in
Datasheet view. However, when I open the form in

My appologies for the basic question.  
I am in middle of creating a query on two tables.  Both have STATE field so
I just created a relationship.  First table has Eff Date,  the second table
has StartDate and EndDate.   I want to pull SALARYGROUP which is on the

I am hoping an Access guru can help here.  I have two tables:  Employee and
another as IDCode.  The IDCode consists of two letters each, and goes from
AA, AB, AC..AZ.  I want only one code to be assigned to one employee.
Furthermore, once a code is used, it needs to be marked as ...

Please help me determine how to save a calculated form value to its
appropriate place on a table?  This seems rather remedial but I'm stumped.
Basically, I want the total of A+B+C on the form to show a running total on
the form and also have it save that total value to the ...

I want to have default values set at what I entered in the same field on the
previous record. How do I do that?

I have two tables, Table of Events and Customer Registration. In Table of
Events there are two fields Date (date/time) and Time (morning/afternoon).  
There are only 16 available seats per session, a morning and afternoon
session. Table of events is a subform within the Customer ...