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... Visio MVP
"Hollywood" <freep...@gmail.com> wrote in message
news:1187096345....@l70g2000hse.googlegroups.com...
Ok, in that case should I provide with Access 2007 logins and password
for every one ?
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
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
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..