I'm trying to determine if any matching records exist on a LIKE query
performing a partial match of last names to a remote back-end database in
the most efficient manner possible.  LAN Traffic appears to be the
bottleneck.  This column is already indexed, and all I'm trying to ...

We have 30,000 MDBs scattered across our intranet created with Access
versions 97, 2000, 2002, and 2003, and using various Jet engines.  Some are
secured; some with their own MDW.
We would like to create a script that will check each MDB and report the

Can an access database be compiled to a standalone exe file for
distrubution to others?
if so, how?
Thank you for your help

I am currently taking a db course and my class is paired us into
groups of 4s and our instructor had us download a template from the
microsoft Access site for education to create and modify a database
for a made up school. This was our objective as it was from a business

There is a form in an Access Project (.adp, Access front end with SQL
Server) for entering data into a table for temporary storing. Then, by
clicking a botton, several action stored procedures (update, append) should
be activated in order to transfer data to other tables.

I am planning to move my Access databases to SQL Server and still
using Access as Front-End.
I did a search on Amazon.com to buy a book but the list is so huge
that I can't distinguish what would be better.

I need to create an object (a recordset) that will not go out of scope
outside the sub that creates it.  I've tried placing the Dim statement
in the General area and in another mod as Global; neither works.
(I'm creating the recordset with dynamic SQL.)

Can anyone please tell me why the following code works fine in
Win98/Access97, but fails to recognize files with a ".zip" extension in
WinXP/Access2002/2000?  It correctly lists the name of each ".txt" file in
the folder.

I have a  Microsoft Office Professional & Bookshelf for Windows 95
CD. (version 7.0)  This version of Office Pro includes  version 7.0 of
Access95.
Pre installed  on my new computer is,  Microsoft Office Basic Edition

I've got a SQL Server database. Nearly finished. It's going to go on a
single non networked machine. One day somebody might get access to it over
ADSL (probably TS), but for now it's a single user no lan.
The machine will actually be running the MSDE. Windows XP Home.

I have created a Project Management database for recording changes,
variations, site instructions site notifications etc ...
Basically I have a form with a "Dmax" field (ID) for the main form and a
number of tabs that are linked by the ID. I need to be able to create

I had a consultant develop a web-page reporting system for me, and
last week I sat down and reviewed the undelying code.  I have never
seen something so complex for a system so simple.
The system, basically requires a user to login, and based on their

The table in question now has around 25000 records (simple -only 3
columns)
Records are added with a simple insert statement :
INSERT INTO SS_REQUEST_SERVICES ( REQUEST_ID, SERVICE_ID ) values(?,?)

I am having a problem working with one combo box that is filtering
another combo box.
My table is tblResearch.  There are two field in this table; one
is[StudyCategory] and the other [Study].  I have a form called

Thanks to this forum, I was FINALLY able to create an employee
scheduling database on Access 97 having zero experience doing this
kind of thing.  Now that I'm about 95% there, I have two final issues.
We have a temporary labor company.  The three primary tables that I