I'm currently working on my first Access Project using Access 2000.
(I've done a fair amount with Access before, but not Access Projects).
I seem to have connected to the SQL Server database fine (it's on a
remote web site). However, when I try to use "Design" or "New" to

Hello.  I've built an ADP using Access 2002 SP3 and MSDE 2000 SP4.  I
have a main form with 32 separate fields, 8 option groups (3 radio
buttons each), 16 checkboxes, and 6 subforms.
When I go into Add mode and type in the very first character of a new

I have a form used to search for records between curtain dates. In that form
the user types 2 dates, then runs the search using a 'search' button, and he
should see all the records which are between the dates typed.
The controls in the form are:

I have got an updateable snapshot based on a view. When close the form, it
automatically sends out the following script to update the underlying table.
exec sp_executesql N'UPDATE "arpos".."tafe_hdr" SET "ref2"=@P1 WHERE
"seqno"=@P2 AND "created_date"=@P3 AND "enrolmentno"=@P4 AND ...

I've tried to follow any kind of tips for the solution og this problem, but
I cannot use the repair tools because of the system table "sysdepends".
What can I do? The regular integrity check, database and transaction log
backups fail every single day!

I am trying to build a user interface (form) that will allow a user to view a
datasheet based on a SQL code entered (Select, Union, Exec Stored Procedure
etc.) in an .adp.
In an .mdb this can be done by creating a passthrough query that is saved,

To all,
I have an Access mdb application with a SQL backend.  The app maintains
links to about 50 SQL tables.
How much of a load on the SQL DB, are the linked tables in Access?

THE  > SUPER-MONEY-SOURCE <
This special program is acquire copyrighting-protected, only with the
participation you the copyrighting at this program.  Prohibited utilization
leads to the notice!

I have a newly developed MS Acess 2003 project regarding Employee Management
System. I have splitted the FE and BE. The BE resides on the Network Server
and is working fine. As the company is installing/moving out to to MS SQL
Server 2K, they want my BE to be in MS SQL and so with ...

I have a form that is based on a view on SQL server. When I edit the record,
instead of updating the view (which is updatable), the sql script generated
by ADP actually updates the underlying table that makes up the view.
Now the reason I wanted to use view is so that I could ...

I have linked a table from SQL Server 2005 Express to Access 2003 to
make a test.
But when I open the table in Access 2003, all fields display "#Deleted"
This is not happening when I link to an SQL Server 2000 database.

I upsized my Access .MDB file to work with SQL Server 2005 using the Upsizing
Wizard.  After doing so, when I pull up the DB in Access, it shows the
original tables with the original spreadsheet-type icon, plus a new set of
tables with an arrow pointing to a globe-like green icon ...

I just started reading this group and disapointed to read that it sounds
like ADPs are being hung out to dry.
I was not impressed by this. ADPs would allow someone with a bunch of Access
programming background (like me) to leverage that knowledge to work with a

This is my first attempt to try and migrate an existing Access database (a
standard Access database mdb file) to an Access Project adp file.  All data
transfer, table, view, stored procedure and function creation aside, I'm
having problems with a form that contains two combo ...

Is it possible to base a report on a temp table created in SQL during the
session?
the temp table name would change each time as it has the SPID(?) added to
the name.