I am attempting to set security on an Access application.  I have read
all documents and have followed the wizards and everything.  I have
multiple forms, queries.  I have 2 groups and have set the tables and
forms to them along with the users to the appropriate group.  It will

How can I copy an security database on another computer?
On my computer, User permission run , but when I copy database (2002)
in another computer, database is opened without problem with full
permission.

I was wondering if any one could advise where I am going wrong.
I have a db where the main table has two fields that a set to memo
I also have a form which allows the addition and editing of these
fields, however the max number of characters being displayed is 255. I

I have a database used to record results of laboratory tests, the tests are
standard but the priced paid by the customer can vary. Currently I have a
standard price included as a field in the Test Table but this is difficult
when prices increase across the board as I have to ...

I just A/B'd my app:
------------------------------------------------------------
- Front end on C in both cases
- Back end on C in one case

Just for kicks and giggles, anyone know of websites that have good
examples of scripts you can do with access forms!?
I am looking for ideas, and examples that I can encorporate different
types of things into the access form that I have here, since I am in

I have read some help articles on sub forms, however, have yet to find the
solution that helps me.   Some groups have stated that this is not known,
however I know there has to be an easy solution:
I have a form that also has a subform.  The two are linked by a field,

  I've designed a database with 50 users,Everyday i should come early
before the users login to the application in order to compact and repair the
be,as i cannot do this if a user opens his fe.
  The quesion is

We have several users who have been using an Access db 2000 version.
Recently a machine was upgraded to Access 2007. Now whenever the user with
the 2007 is on the db, two of the other users cannot access the db at the
same time. The third user where the db is physically located ...

When I open this form I get a "Data type mismatch in creteria expression" and
when I click on the button on the form I get "The expression you enetered
refers to an object that is closed or doesn't exist" error in the code. When
I click on Debug, it takes me to this line of code:

I have an Order form which when completely filled out sets a check box in
the table to "Lock" the Order. In the current event I have the statement:
   Me.Allowedits = Not OrderLocked
In rare cases the Order can be edited anyway.

From:  Silvia Carbonella
Salve,oggi 28/01/2008 io Silvia Carbonella nata il 08/09/1980 a Quito
Ecuador e prestato servizio dal 10/01/2005 al 09/01/2008,ho inviato la
domanda per partecipare all'11 concorso marescialli per la Marina

I have a query which has the following iif statment:
Accrued Vacation: (([Consolidated]![Regular Day (REG)]/8)/24)
This tells me how many hours have been accrued for vacation in 2008
I have another  iif statment in this query which is:

I have set up a little invoice database and things are going quite
well. My only issue is the display of the address.  Each line of the
address is stored in a table separately (this is important for other
things I need to do with the data).

For our project at work, we have had an Access Database developed for
multiple users.
It's split into a "front end" and "back end" as described previously in many
of the threads in this newsgroup.