Access 2007 DB Intranet Deployment

[Treble_Mebbel]

Hi All,

I am new to the forums, and very much new to Access as well.



I desperately need help, and would really appreciate any feedback anybody has for me here.

The project I am working on will look like this, or rather this is what I have in my mind.

Environment: Web-based (Intranet)
Tool: Front (Web Tool, input) Back (DB on shared drive, collect)

The users within this group will need to have a web tool/ app that feeds their input into the Access DB on the shared drive.

Type of information is fairly simplistic.

Username (login ID)
Activity Type
Data (automatically populated)
Reference number (case/ or other)

Once submitted the information will be loaded into the DB tool, which will allow me to pull frequent information off it using pivottables.

I just have no idea on how to start with this, what best practice would be, and how to deploy this so it works within a multi-user environment.

Is there someone that can shed some light on this for me.

Thank you in advance!

Kind Regards,

Michael

[June7]

Possibly no need to use web for intranet deployment of multi-user database if all users are able to map to the data server. This thread discusses how I serve split database on internal server http://forums.aspfree.com/microsoft-...tc-324677.html

My project doesn't require users to 'login'. I identify the user by their network username. I have code that obtains username from the network with Environ("USERNAME") - yes, type it exactly as shown. Access will not recognize the Environ function but VBA will. I don't bother with password because I take it for granted if they are validated by network they are valid users for the database. I have a Users table that has username and initials (so far everyone's initials are unique, you might use an autonumber field). I set a textbox on main menu form to user's initials so always available for reference because the main menu form never closes.

[boblarson]

My project doesn't require users to 'login'. I identify the user by their network username. I have code that obtains username from the network with Environ("USERNAME") - yes, type it exactly as shown.

If you use Environ("username") I would highly suggest that you use the VBA. part before it. The reason? I've seen it fail on some systems after upgrades. So, using

VBA.Environ("username")

is actually better in that it won't fail on those systems when it would otherwise.