modify a table without using Access 2007 ?

[Hollywood]

Good day dear members of the microsoft.public.access newsgroup.
Please I need your help on the following.

I'm the administrator of an Access 2007 database.
I would like my enterprise personnel could add entries to one specific
table by the use of an interface or form without launching the data
base (because the data is confidential).
We do not have Windows Share Point.
Please how can I do so ?

Many thanks.

Octavio

 

[Joseph Meehan]

Good day dear members of the microsoft.public.access newsgroup.
Please I need your help on the following.

I'm the administrator of an Access 2007 database.
I would like my enterprise personnel could add entries to one specific
table by the use of an interface or form without launching the data
base (because the data is confidential).
We do not have Windows Share Point.
Please how can I do so ?

Many thanks.

Octavio

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.


I guess you could link to a spreadsheet and let them use the spreadsheet
or maybe link between two database (mdb) files, but I would (ad have) used
the built in security.

 

[James A. Fortune]

Good day dear members of the microsoft.public.access newsgroup.
Please I need your help on the following.

I'm the administrator of an Access 2007 database.
I would like my enterprise personnel could add entries to one specific
table by the use of an interface or form without launching the data
base (because the data is confidential).
We do not have Windows Share Point.
Please how can I do so ?

Many thanks.

Octavio

See:

http://groups.google.com/group/comp.databases.ms-access/browse_frm/thread/11325f226a058f0f

Subject:

modify a table without using Access 2007 ?

James A. Fortune
(e-mail address removed)