Is there an SQL statement that will search a table's attribute types
and report if there are any text, Blob, or memo fields?
Are there any other Access data types that can hold text information?
Thanks

If I work on my app on my standalone, things are always fast.
If I have an non-split app on the network it runs fast.
If I split the app and have both the front end and backend on the
network the app's speed drops to a crawl.

I was wondering if anyone had any tips for some software that will do a
global search and replace for table names and field names in access (across
a split db would be nice also).
Thank you

I recently installed my Access 2003 app onto my new PC with Vista
Business. Now when I close various windows within the program, I see a
white block where a particular window was along with the red X from
the upper right hand corner of the closed screen.

SPUR (Special People United to Ride) is a nation-wide organization
that puts children with disabilities on horseback for 45-minute
sessions.  It is heavily into volunteers to guide the children.
    I wrote a program in A2K for SPUR/Monmouth County NJ  to keep

I have an Access 2003 database that has several reports with charts on
them that all work fine under A2003.  All but one works fine under
Access 2007.  On this particular chart the chart columns extend out to
the right of the chart container all the way to the edge of the report

Having some trouble with an unfinished database.  I'm a moderate user,
not a beginner, but I'm training myself more advanced options.  I have
an unfinished database that I set the startup properties to disable
all the menus (oops.)  How can I get back in to edit the database.  I

Pls open the web site
http://indianunivresults.blogspot.com/
and also click the advertisement

I have at home and at work a program that adds info to a local Access
data base. That means that my home Access and work Access database are
not in sync.
My question - how to sync both databases?

I have run into a problem with the new rich text control in Access 2007.  It
seems that you can only choose from 6 preset font sizes when entering or
editing text.  The sizes are 8,10,12,14,18,24,36, which as I understand it,
corresponds to Font Size=1 through Font Size = 6 in ...

I have a query that I export as a csv file.
The problem is I want to create a Fieldname such as "CAT:STREET" from
a field currently named "STREET"
For obvious reasons it don't like the placement of the ":".  Any

I have a table that tracks client contact.  I want to create a report
that checks to see if contact has been made in a specific month
(passed parameter).  If no contact has been made for that month, then
display the client's name and move on to next client.  I can do this

I am trying to use this with a name field that has the entire name in
one field in a report that is actually a letter. In the letter, of
course, I need to address the recipient by first name in the greeting
line. Can I create a statement to use only the left-most word instead

A97
I have a database called DB1
My desktop icon properties open it like
  C:\MSACCESS.EXE C:\Apps\DB1.MDB /wrkgrp C:\Apps\DB1.MDW

I'm going to implement an archival database for my app.  I have Table1
and Table2.  Table2 is a duplicate structure of Table1.  I appended
records with "ID between 1 and 100", then "ID between 300 and 400" then
"ID between 225 and 250".  It appears they keep the same ID.