When I open an SQL 2005 table from within the ADP, it takes 3-4 minutes to
open it. This happens only once, and only for the first table that will be
opened.
Looking in the profiler I see 100's of statements like this:

I create Access Data Project Database. I set properties in Data Link to
connect to SQL Server, but  I don't want to save password. When I open
database, the Logon form show automically. How can I hide this form. Because
I write code connect to SQL Server.

Hi @Newsgroup,
I got the following problem. I want to copy a table from Database X to
Database Y in SQL Server. I want to use a stored procedure (Create Table
query in Stored Procedure) in ADP to do the job. I enter

can we hide objects (table, form, etc) in an ADP?

When a trigger send a message with RAISERROR I can't see the message on pc
from hp, acer, ... if the pc has been installed with the default
installation's program.
If I format the hard disk and install manually with a MS' cd I can then see

I have a SQL Server 2005 database I created several months back. Over time it
has grown rather large in size, for example my LDF File is now 400MB. I've
written a stored procedure that will delete all the data in all tables and
reseed my identity columns to zero.

This was also posted to microsoft.public.access.odbcclientsvr
I have experienced this problem from time to time.
In access 2000 or 2003 I have a linked table (to SQL 2000) which was working
fine.

I'm converting an adp file to ade and I get the msg that MS is not able to
convert the db to ADE. The VB compiler runs w/o a problem and so does the
adp file.
Where should I start looking for a possible solution?

I have an SQL Server Database with about 125 tables. Each table has an
Identity Column and there are many Relationships setup. I need to create a
stored procedure thta will step through each table and delete the data from
each table and reseed the Identity Column to 1.

Hi Friends,
I have an  ADP database with backend SQL,
I have an unbound textbox and a command button and need to filter data on a
subform based on any character entered in the textbox.

I am new to access, can anyone explain me is there a way we can auto populate
some of the fields in the form from the existing table
Thanks
D

    I am sort of going borderline insane with a problem I am currently
facing. I have written a stored procedure on SQL SERVER (EXPRESS) which
takes 3 parameters and returns a single column. The expected returned
results is a single row. The SP runs successfully and the result is

I have an Access 2003 .ADP project tied to an SQL Server database that
I created using the Upsizing Wizard.  What do I have to do in order for
the user to get prompted for SQL Server authentication?
The "blank password" checkbox in the File|Connection dialog does not

When saving a check from a form into a SQL table (having a field as int), it
is stored as -1 instead of 1.
What's the workaround?
TIA

I know there are other ways to connect to SQL server but I am wondering
why SQL server 2005 databases cannot be accessed through Access 2003
projects.  Is it to force people who prefer the Access interface to
upgrade to Access 2007?