Within SQL Server 2005 (SP1/SP2) the ability to host .adp projects over a
SQL Server 2005 back-end was made possible.
I have converted a couple of legacy .adp projects from SQL Server 2000
back-end to a SQL Server 2005 back-end.  In early A-B testing, one user,

Need help making a pretty simple report...but I will post my question
in here forst because it is probably a noob question anyway. Let me
know if I need to take this to a different forum. TIA
I am creating a report from an Access database for scholastic

how does this mail thing work

I'm trying to help out my local pool/free poker bar with a database.  It's
pretty simple, there are one or two tournaments per day, and the top 16
finishers get points.  These points accumulate for 3 months, and people like
to track their progress.  Each place gets a different ...

2003
The following command when executed, works fine:
dBs.Execute "INSERT INTO CHOOSEOffsets SELECT TOP 1 * FROM CHOOSERev" & _
   " WHERE "  & NextActualAmt & " + " & StartActualAmt & " = 0 "

test message

When I tried to run a database with reports using the 2007 run time engine  
on a computer that did not have Access loaded I was able to get the form on
the screen but was unable to see any reports.  I am able to enter data but
there is no way to access the reports.  Someone said ...

I'm using 2 PCs. Both Vista. My 2nd PC seems to have corrupted my database
and lost the VBA code when I tried to open it without setting the location in
the trust center. Once it can't find the VBA the database seems to be
corrupted. I can't get it to work again. Switchboard ...

I am running short on memory  what would anybody suggest I have been looking
at a portable hard drive system so to backup all my files and photos.
The computer as 1gb and the space left is 3%.
Any ideas

Hi, I have a database that I have created in a normalized structure. The data
is information I've imported in from excel and all data tables have the same
amout of records or row count.
I've created a primary table and are releating to the other tables on the

2003
I want to copy one record of TableA which meets conditionX to TableB
PLAN A      
Originally I thought that the following VBA code would work:

I can add a calendar in my form.
Is there a way that I can add a text box or something that will fill in with
a sum of a table column when I just click on a date on the calendar?
Thank you,

We as vocational teachers must strive to encourage young people that there
are places for all people in our society those who seek  employment as soon
as they graduate will be benefical to our nation also.

I've got a split Access 2003 database where the back end is on a shared
network drive and the front ends are on the users' C drives.  I've noticed
that sometimes the back end mdb file thinks there is an open connection with
one or more of the front ends, even after those front ...

Is there a command that can be used to retrieve the path of the current DB?
I found that Application.CurrentProject.Path can be used with msgbox to
display the current path, but I am looking to be able to set the value of a
const in a modules declarations so that it can be used ...