He also loaded Microsoft Visual C++ Redistributable and Microsoft .NET
Framework 1.1, hotfixes and service packs for same and Microsoft User Mode
Driver Framework Feature Pack 1.0. If these don't do anything, again, I'd
like to unload them. All I do is music and e-mail on this, ...

Hi all. I have developed a SQL 2005 ADP that contains a LOT of Data. We are
currently experiencing some interesting performance issues over the network.
I am interested in finding solution for optimizing my DB and any other
suggestions that could help to improve the performance ...

Is it possible to make a form a OLE drop target? so the user would be able
to drop an object on the form, and I'd write the code to handle it.
I see no form properties to that effect, but maybe some 3rd party add-in or
win32 coding would make it possible?

I need to Connect to the SQL Server Database for data extraction without
using linked tables.  The SQL Database and Access DB are local.
I keep getting the following Error
Named Pipes Provider: Invalid Parameters -87

Okay, for presentation purposes in my Access project, I've got a few
different views that use functions to group fields from different records
together in the same field in a view.
For example:

I have an adp project that I upgraded from an Access mdb database.
In my project I have a form and a sub form that represents a parent and
child relationship, say orders and parts.  The order form contains a subform
whose control source is a query against the orderparts and parts ...

I an adapting my .mdb Front End to an adp with a SQL back end. I have a user
form with a lot of list boxes. In the old mdb version, when an item was
selected from a list box, the associated data would appear instantly in
specified areas on the form. For example, if a client is ...

This probably doesn't belong here, but it was the closest I could find.
I have developed a shared database for the accounting, marketing, and
payroll departments. I have "split" the database and understand how to
distribute the front-end to each department.

I have an  Access adp front end connected to SQL Server back end. I have a
form that pops up when the user types a person's last name. It shows all
people in our database with that last name. So far so good.
I want to make it easier on our users though, and not require that they

I've set up a number of forms with filter based on forms in access such as ID
= [Forms]![form]!id. however i have been trying to migrate this the access
project, and this seem to cause an error. can anyone tell me how to get
around this ?

SQL Server 2005. The function below compiles fine. If the two dates
are same return 1 (true) else false.
But the testing gives an type error

have a problem

We found a number of serious performance bugs in Acess 2007 ADP that didn't
get fixed in Office 2007 SP1.  Application runs fine in Access 2003. Most
serious problem is that if we so much as touch a record source or execute an
on-the-fly query Access 2007 seems to instruct SQL ...

I have a tough question which I spent a lot of time but I couldn't find
figure out how to solve it.  I have two tables.
TableA:
Name, Product1, Product2, Product3

some years ago I created a client server solution with an SQL server 7 as
backend and Access 2000 project (.adp/.ade) as frontend. The client platforms
were NT 4.0 WS or W2k (always with MDAC 2.5). Everything worked "fine" for
many years until I caught  someday upgrades to MDAC 2 ...