Multiple Entries

[Banderas23]

I have been working on a database for a friend as there is major security issues where staff members can access the database. I haven't used access in over 15 years and need some help re-building a new database.

I have built a login section which works fine using some VBA and can lock down most of the database. So only entries can be added using a form.


This is what I need help with before I keep on doing the database up.

I need a database that I can add entries into from multiple machines using a form only so the back end is protected.

The forms need to have a way of having a login so when the data is inputted I can record which user is adding the data as a login stamp with time and date.

Am I right in thinking the only way multiple entries can be added is by building a web database and sharing this on sharepoint?

Or is it possible to have the database sat in a shared network location and have the forms link to the database back end only?

Any help would be great!

Antony

 

[jdraw]

Or is it possible to have the database sat in a shared network location and have the forms link to the database back end only?

This is possible. Front End with Form and some logic to secure who is using the Form/front end. Every user has his/her own copy of the front end. Front end is linked to Back end. Back end on a shared network drive.

See
http://www.fmsinc.com/microsoftaccess/databasesplitter/
http://www.fmsinc.com/microsoftaccess/performance/linkeddatabase.html

Good luck.

 

[Banderas23]

I thought this was the way to do it. My database still allowed me to change the data as it shows the links. I've had to hide the tables from view and then look at securing that down.

Hopefully that will work.

Cheers for the response.

 

[jdraw]

You should also review this article.

 

[Banderas23]

Excellent, now I don't have to lock down individual elements. Simple save function and hey presto.

Thanks for the info amigo.