In MS Access 2003 What are some methods of restricting users to only
see their data in a shared database?   Or if in SQL Server 2000 (or
2005) is this functionality available?
What I am doing now:  I have a login form that has a dropdown for the

I downloaded an access database from Microsoft and added some fields.
I've also added the tables  but when going back to the form the additional
fields do not show up. Please help

Am self-taught through tutorials about Microsoft Access.  Just today got my
head about multi-table relationships and subforms.
In an example on the tutorial, in a Form, you could select a value from a
drop down box and the other boxes would automatically fill with the details

Is it a requirement or just good form to clos a recordset before setting the
instance to nothing (or both)?
E.g. if I "set rs=db.openrecordset(sSQL)", do I need to "rs.close" it when
I'm done with it before I "set rs=nothing", or does the latter pretty much

A Project has 3 stages:
1.  Prospect
2.  Estimate
3.  Detail

In my databse I was try to add a field, and it said that I have too many
fields. But when I went and deleted one that I never use, it still says I
have too many.  Even if I go to one and change the name and properties of an
existing field, it wont let me save.

I have a dependant's table with the fields for spouse, children, and
additional (if you care for your parent's or other).
Should these three categories have their own table?
When I view the data in the table, one record may have multiple rows, for

I use a subform to enter transaction information.  If the field,
[GrossAmount], is greater than 9999, I would like a subsequent field on the
same subform, [CashIn],   to autofill the same amount as the [GrossAmount]
field so the user doesn't have to enter the data twice in the ...

I'm trying to develop a database to log inventory that is has unique serial
number but incremented in numbers of 25.
I what a form that allows the user to input the starting number, the number
of items and have access populate that data based on the users entry.

Access 2007
Trying to create an input form which has a field which will populate a
multivalue field in a table. However I cannot get the wizard to display the '
allow multiple values check box '. This is true for the table and the form.

Hello anyone/everyone,
I'm trying to set up a form/report that allows me to move an item from
one point in the list to another. For example, if the list consists
of:

Just a quick question.  I am trying to just change the font of a few words in
Access 2007 but it will only let me change the font of the whole database.  
Is there just a way to change a few words?  Thanks.

It appears that my back table isn't deleting the main record and the related
sub-records when you delete the main record from the form. I've double
checked the relationships and all are correct with referential integrity
turned  on (one to many)with cascade deleting selected. If ...

I have a database with a lot of tables.  One of my main tables links to most
of the other tables.  I tried to create a relationship that has Enforcce
Referential Integrity set but I receieved an error:
"There are too many indexes on the table.  Delete some of the indexes on the

I have some 140 MB's worth of journal articles. I need a searchable database
that shows the author, journal name, date, a brief summary, key words, as
well as the file name on my computer. I've never used access, but i'm a quick
study.