I need to replace a wildcard character ($) in one field
with the contents of the ID field in the same record.  My
database is 3000+ records, so doing this by hand is not an
option - or at least not a good one.  For example:

I'm using VB6 to connect to an Access database.  When designing a  table in
Access, if I set a text field size to a value, the data returned from a
query from that column has a length of only the data in the field.   Using
DDL to alter the field size results in data that is ...

I have a Jet database on a central server.
The database is accessed by 2 or more instances of the same application on different PCs.
If the database is edited/updated by 1 instance of the application on a PC how can I tell the other PCs to refresh their screens/recordsets.
Is there ...

I would like to add a field to my Customer Contacts table that automatically
sets to the date the record was entered plus another date field that resets
automatically to the date a record is altered. Can I do this and how?

  I am looking at designing a new database for a company
that has several grain processing mills in several
locations.  All of the ordering and billing is done at one
location for all mills.  Currently the orders milled at

Hello all...
I have an application that needs to be able to associate a name with a
variation of the name.  For example Elizabeth vs Liz/Beth.
I was thinking of building two tables:

will the database designed in access 2000on windows 2000
server is compatibile with access 97 on windows 98

Does anyone know why I would get an error in my access
database when I try to add a column, "TOO MANY FIELDS
DEFINED"???

When I view the tables in Northwind there are some kind of
subtables in there... for example, in the Customer table
you can click the "+" next to the Customer ID and see
their orders.  How do you do that?  It's probably basic

Hi People,
I have a table called tbl_ProjectDetailsLinked, this table
is a linked table from Excel that consists of a number of
fields and corresponding data. I have also created a query

I'm trying to find out what the maximum physical size you
can have for an Access v2.0 MDB file.
I have heard it is 256mb, but can anyone confirm this, and
maybe point me to where this information can be found?

when i add a new field to the table it dosent show up in
the form where i enter the data?

I am trying to design a database for my company, but my
knowledge of access is somewhat limited.
I have two tables: Customer (which holds all of the
customer information) and Product (which holds all of the

I created a table with a field name of Start Date.
There are a number of queries and html pages set to get the data in that
field.
I want to create another field in the same table called StartDate without

For xample if i have a Field Zip Codes and i want to make sure that you can
not add more than 8 numbers in it how do i do that. Also if less that 8
numbers are added, the starting digits should be 0 as default.
Any idead how can i do that. so for eg i entered 12345678 it should