I wrote an ACCESS 2003 app which uses SQL Server 2005 Express Edition.
Everything works fine when I start my app as .ADP. when I convert it
to .ADE and start it,
ACCESS displays an error-messagebox when I call the function

I've been working around this problem for way too long.
Any help on this would be very much appreciated.
I'm very comfortable with building class modules.
What I'd like to be able to do is...

An access 2003 mdb uses odbc to connect with sql server 2005. Before any
operations are attempted I'd like to make sure the odbc connection is
good, ie not down due to network or server issues. Is there a simple way
to make this test? I'm using sql authentication.

Hello i have an access database and i want to exchange data with an existing
database in SQL Server 2005 how can this happen?

Hi, I am trying to run this query,
UPDATE forums AS F INNER JOIN posts AS K ON F.[id] = K.[forumid] SET
F.[posts] = Count([K].[forumid])
And I am getting this error ;

In setting a forms record source via code, I sometimes get execution errors
on subsequent lines of code that on the face of it make no sense.  After
testing / debugging it occurred to me to insert a call to sleep for a short
period of time waiting for the ADP/SQL Server to fully ...

I have an ADP application run for some time at my work.
Suddnly i can't use table_based functions anymore. When I run them they
don't do anything
What can cause it? help

Hoping you can help
I have a table where I'm trying to get a %.  The total % should always equal
one, but it doesn't.  Often is .9999 or 1.0001.
hours to proj A / total hours = %

I got a DB for Access 2000 Runtime that used to run in Windows XP.  I saved
DOC, TIF and PDF files in an OLE object (named OLE Attachment.  Files are
stored in a Windows 2000 Server).
I decided to run the BD in Windows Vista.  Everything was working correctly

In my ADP (on Sql 2000) i have long time running report. In my office
everything is ok but when I deploy application to the workstations in
my customer office there is timeout error. As I know I shuld change
"connection timeout" and "general timeout" properties of my

I have upsized my Access 2003 database to SQL 2005 and everything seems to be
working just fine. My problem is that when I use the Microsoft Custom Startup
Wizard from Visual Studio 2005 Tools for Office to create a .mde file with a
startup form specified I get an error that the  ...

I have an adp application that was automatically generated upon an upsizing
of an Access database to SQL Server 2000.
For the most part everything went remarkably well. However, I just
encountered an error when I tried to add a new record.

I would like to insert a row into a table, one of the columns is a
uniqueidentifier (primary key)  for my insert I have the following code.
dim varExhID as variant
   varExhID = newid()

NEED A LOAN
Follow what to do below and in two weeks you'll have at least $18,000
because most people will respond due to the  to the low investment and high
profit potential!

Acc 2003 / Sql Server 200
I have a datasheet subform and I want to allow record selection and deletion
of selected records.  That part works fine.  What I would like to do is to
prevent deletion of one particular record (based on record values) that may