Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

modify a table without using Access 2007 ?

0 views
Skip to first unread message

Hollywood

unread,
Aug 14, 2007, 8:59:05 AM8/14/07
to
Good day dear members of the comp.databases.ms-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

John Marshall, MVP

unread,
Aug 14, 2007, 9:17:25 AM8/14/07
to
You could still use Access, just create a new table for the additions and
only give your personnel access to that one table.

John... Visio MVP

"Hollywood" <freep...@gmail.com> wrote in message
news:1187096345....@l70g2000hse.googlegroups.com...

Hollywood

unread,
Aug 14, 2007, 9:22:35 AM8/14/07
to
On 14 août, 15:17, "John Marshall, MVP" <lancu...@stonehenge.ca>
wrote:

> You could still use Access, just create a new table for the additions and
> only give your personnel access to that one table.
>
> John... Visio MVP
>
> "Hollywood" <freepos...@gmail.com> wrote in message

>
> news:1187096345....@l70g2000hse.googlegroups.com...
>
>
>
> > Good day dear members of the comp.databases.ms-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- Masquer le texte des messages précédents -
>
> - Afficher le texte des messages précédents -

Ok, in that case should I provide with Access 2007 logins and password
for every one ?

Rick Brandt

unread,
Aug 14, 2007, 9:29:03 AM8/14/07
to

Perhaps a good place to use the HTML Mail forms feature that Access 2007
has? You mail them an HMTL form in an Email. They fill it out and return
it to you. You then can pull the entry into the database. Sorry, but I
have no details about how that works.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


Hollywood

unread,
Aug 14, 2007, 9:51:54 AM8/14/07
to

Thank You Rick for your kind advice. I prefer linking the Access 2007
database to an html form on the server. The personnel will enter their
entries and it will automatically pull it into the correct table on my
data base.
Please can you tell me how can I do so on access 2007 ?

Thanks again.

Octavio

Rick Brandt

unread,
Aug 14, 2007, 1:49:36 PM8/14/07
to
Hollywood wrote:
> Thank You Rick for your kind advice. I prefer linking the Access 2007
> database to an html form on the server. The personnel will enter their
> entries and it will automatically pull it into the correct table on my
> data base.
> Please can you tell me how can I do so on access 2007 ?

Well you can certainly use web authoring tools to create a web page that
would do this. However; that would not actually involve the use of Access
at all. You would use tools geared for creation of web pages that can
interact with databases. That would involve products like ASP, ASP.Net,
PSP, ColdFusion, etc..

0 new messages