What the maximium size MSDE Databse can grow to.  I'm
currently using MSAccess and know the max is 2gig and I
feel I might be better off trying a MSDE database instead
for my project.  Can anyone help

I have a table that has a currency field "Amount" which
is a calculated field. No matter what I try, it won't
round to 2 decimal places. The extra digits are causing
my numbers to be off down the line. Does anyone know if

Hi,
Example:
In a form, I have Names and Phone number. A name can have
10 Phone numbers and for a phone number, it can have a

Getting around to the time-accounting aspect of my 'project' mobile.mdb, it occured to me to offer these specs to you gracious folks:
(I know alot more coding --the macros are baffling so far)
--When the .mdb starts, it will write Date to field 'Startup' in tblSometimes?
--When the  ...

I'm just finished developing my own database in access
2000, but my problem is that someone can still see my
coding i did in visual basic. I have a start-up form does
load and then after that the switchboard, but if your

I use a form to input data into a table. At the bottom of
the form I have it set up to show what record number is
being used. The formm has a line that looks like this:
Record Number ___ of 38218

I am hoping someone can help me, I am trying to create a
relationship in a database and I am having a lot of
trouble. I am trying to make is so in my database when I
enter information into my assets table, some of the

How does one best outfit Access2003 so
--
When the .mdb file opens, it writes a =Now() Date to a field in Table?
When  the  .mdb   closes, it writes a =Now() Date to a field in Table?

I am attempting to create a database that will hold a trial balance then use
queries to "assign" the accounts to pages and lines on a report (a statutory
type of report).  For each page, I will need a line number and description,
a subline number and description (if applicable) and ...

I need to make a local table with the same structure as a
linked table. All of the methods I have tried (export,
import, cut/paste, copy, etc.) all create the new table
as another linked table. I am sure there is a simple way

Hi group,
In the database I am developing I have one table listing diseases and
another table listing symptoms. One field in the diseases table links
to the symptoms table. My problem is that a disease may be associated

How do I code in the "Create Table" Statement to turn on
unicode compression in Access VBA 2000. I have tried "With
Compression" but with no luck. Thanks.
Steve

I need to know if it is possible to index a combination of
fields in a table.  For example: [Date] & [Shift]

The first three Field Names of my tblModules has the following information...
BMKey......Autonumber, Indexed (No Duplicates)
AddrID......Number, Indexed (Duplicates OK)
MonicsID...Number, Indexed No, Has a Lookup Table

I had a Paradox database called Rolodex that I imported
into Access.  When I did this it asked me if I wanted to
create a Primary Key field and I said yes.  Access
created a Auto Number column and set it up as the Primary