I hope someone can help because this has been troubling me for a
while.
The situation is that I am trying to incorporate an access database in
frontpage using asp etc. I can succesfully do this and there is no

I have tried repairing my Access installation and updating
to the latest rev. No help. I cannot use any of the
wizards as I get the error that the wizard cannot be found
and that there is a syntax error in the declarations

Is it possible to have a variable be a number field and
not drop a preceeding 0?  
For example, I have ID numbers that start 0123456 but the
front 0 drops out.  I'd prefer not to have the field be

I have two monitors plugged into one graphics card and
both monitors appear to be working fine.  However, this
does not allow me to open two separate Access Databases
(one for each monitor).  All the monitor settings are

If I had accidentally set up a password in Access and
forgot the password, is there any way to retrieve? Or does
it store somewhere we can open it? Please help.
Sam.

How do I make a pic show up in access page view when the
directory is there?  Example is:  no picture, just
C:\Business\Website Pics by ID\92275a.jpg.
I want the pic to show up next to the product info on that

I have a invoice table with an autonumberID.
How can i add the fields "ordernumber" and "invoicenumber" as a autonumber?
Access only alows one autonumber to be present in a table.
And how do i make my own autonumber starting from a e.g. 2003001

i am trying to create a database that will allow me to
assess someones circumstances on a day to day basis i.e.
giving them x amunts of pounds or dollars depending on
their circumstances. I want to be able to create a

G'day everyone.
Wondering how I limit someone from entering in non numeric or alphabetic
characters into a textbox on a form. Do I do this within a form or in my
table design.

Does anyone know how to unlink a table?  I am copying a
cost study table and renaming it.  I want it to be
accessible for future reference, but I don't want it to be
altered each time I open Access.  I tried right clicking

I have a situation where I would like to create a many-to-
many relationship in my database.  I will need one table
to house contacts and one table to house addresses.  My
junction table will hold the contactID and addressID.  

help with this ??
I am not sure how i would set up the table structures and
confused about what kind of referential integrity would be
enforced.

I've been asked to prepare a DB for our Nursery dept. It's a form for visiting parents  before their child joins the school. I have many lookup tables linked to the main table e.g. "Interest in Reading" may be (i)nil (ii)indifferent (iii) high. Each choice scores; i.e 1point for ...

I am a novice when it comes to mdb development and am
currently looking for assistance with
converting/understanding the difference between a “web-
based” vs. “split” databases.  Can anyone please explain

Subset of Database Tables/Fields are as follows:
Table1 Field1 and Field2 values can occur multiple times in the table
Table2 Field1 has a unique value in the table
Table3 Field1 and Field2 when combined have a unique value