Hello.  I'm a newbie when it comes to using Access as the front end for a SQL
Server database.  We have an Access application that was developed using
local Access data, and we have recently moved the data to SQL Server.  When
the data was in Access rather than the linked SQL ...

Hello.  I've just created a new Access ADP project connecting to a SQL Server
database on another server.  When I add a new form based on a single table,
using the wizard, it disables the "Add New Record" button in the navigation
buttons ("Delete Record" button too).  And for the ...

I have been an .adp user for years.  I upgraded to SQL Server 2005 last year,
and while I could no longer make changes to my database using Access 2003, I
still was able to make fast updates to the data.
I recently upgrdaded to Access 2007, excited about full SQL Server 2005

I have just upgraded to Vista and installed Access 2007 and SQL Express to a
named instance.  After figuring out how to create an Access Project (why did
they make that difficult?) I tried to link to an existing DB in SQLExpress
using the connection dialog box that pops up.  I ...

In my SQL "INSERT INTO" string, I would like it to insert today's date if
three of the bit fields are all False, but the iif statement doesn't work
(the datToday variable is declared above and outputs correctly in the string):
...,(iif([UFIR]='False' AND [Ethics]='False' AND ...

I am trying to maintain a historical table with monthly calculations.  In the
form where you enter the monthly total for allocating, I declare variables
for most of the calculations:
Dim curTotal As Currency

Is it possible to have an Access linked table, link to a SQL query, instead
of directly to a SQL table?
This way, I can securely filter the data without a lot of heavy coding.
Thanks beforehand,

Currently my company has outsourced IT and we have to access all of our
information via a Remote Desktop. I have an Access Frontend (2003) and a SQL
Server (2000) backend running on Windows 2003 Terminal Server. The problem is
that the SQL Server is not always saving information and ...

Hy guys I have been managing successfully a medium size ADP project with
Access 2003 in the last 3 years and considering now if it is worth it to
switch to Access 2007, but reading bad news about it.
So just for what is done I was considering to convert the project to VB

I have an Access 2002 ADP that is about 191MB which has a SQL Server 2000
back end..
The ADP runs OK and it compiles without any errors but the compilation
process corrupts the ADP so I have to revert to a backup. When I try to make

I create a report and put the following VBA code:
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
   MsgBox "hello"
End Sub

Excuse if this is not the correct group -- I am not using an adp, but an
upsized mdb file with linked tables.  There seems to be no group made
for Access-SQL Server discussions other than this one.
Have been running an Access front end (mdb) on a SQL Server back end for

I passed around ten hours on this one: we have a SQL
Server 2000 station, to which about 20 client connects to
via an ADP solution (Access 2003).
When inserting with conflict, some users goes through our

I am using SQL Server 2005 Express and the Management Studio as the backend
for an Access 2003 database. I would like to use trusted authentication. So
far have done this:
Created a windows group called dbusers

I have created a computed field in my SQL table and I'm using MSAccess as my
front end.
When I update my form with new values the values change, but not my computed
field in the form