I am trying to build a database in Access 2003 which can connect to
information in a SAGE system.  Should I use ODBC, and if so, which
driver is required?  Is there another way of connecting?  Which is
best?

Environment: Windows XP, MS Access 2003.
I'd like - in a report - to save space , when there is no company
data.
When there is, I print out company name, address, telephone number and

I have a DLookup field (DrgNo) in a query (qryItems) which is used in the
attached (part) function.  The purpose of the function is to concatenate the
contents of a field in a query.  The arguments are passed to the function
successfully but the code fails at the line

I have Access 97, 2000 and 2003 all running on a Win XP box after having
just reinstalled XP. Among other problems, I find that Access 97 will
not compact a database in code ...
DBEngine.CompactDatabase dbSource, dbDestination

I've been using Access 2000 for a while but this is my first time
trying to connect an Access Front End to a SQL Server back-end.  I've
created a few tables in SQL Server (2005 Standard) in a database file
I call CustInfo.mdf.  I go into into MS Access and create the ODBC

i have a problem connected with syntax error- in query i have that:
SELECT DMax("Data","Pracownicy na stacjach","Lokalizacja stacji = " &
[Lokalizacja stacji] & "  And Zmiana = " &[Zmiana] & " And
Data<=#"&Data&"# ")

I have one of those unanswerable 'why' questions.
The 'control wizards', like for buttons and such, make extensive use of the
'DoCmd' keyword.
E.g. if you use the button wizzard to add a button to a form, and tell the

I have two tables related to sales transactions and assigned areas.
The tblSalesArea has SalesAreaID an autonumber
                       StartZip, Text
                       EndZip, Text

I have a form called "customer_frm" with many records in it.
I would like to have a form that has a combobox listing all the
customers, and a button that open the "customers_frm" to the specific
record I have chosen in the combobox.

Does anyone know of a good crystal reports newsgroup? I tried Google and did
not find anything.
Thanks!

I have a PC which has Full Access 2007 and the 2003 Runtime one and
need to use both. When you start one up after using the other you have
to run through a set up routine.
Does anybody know how to stop this as the 2007 set up takes a while

Here is the following scenario.
I do have a master table with related subforms from wich I need to
create a revision.
But I need to duplicate the content of the subforms and link them to

on sql 2005, I've got a view with select permission granted, the view
just "select * from table"
using odbc in access97, I linked this view and I create a query to
retrieve certain fields

I am designing a Housing Database to track rent payments for Non-For-
Profit organization and they calculate/figure the tenant/client's Rent
payment based on how many room mates.  No Problem, Rent is set at apt
#1 for $750/month, 3 people share the apt so $750/3 yields $250 for

In a DB cataloguing journal articles, tblCatalogue links via an M-M
transition table to tblAuthors identifying the article author
name(s).  I wish to extend the DB to cover persons cited in the
articles, thus requiring a new table (e.g. tblPersonsCited).  However,