Access : Multi User Environment

[irfanali]

Hallo All,

I m trying to create a Multi User Data Program on Access, where my team members would input data on a daily basis.

Well the Problems start now :

- How do i create a Multi-user Environment, so that my Backend is on the Sharedrive(Local Server) and the Front end on the respective user systems?

- Well, once i achieve that, then how do i hide the Access data like Tables, Queries and Forms from Viewing by the user on the Front end?

- Also, how does one display a Internet Browser on a Form, which opens up the Google homepage, everytime the form is opened?(Which Activex Control and what Code)

- Last Q, like the Internet Browser, how do i integrate SAP in to a Form?Which Activex Control and what Code)

I know there are a lot of Q's, but sometimes when you gotta ASK, you gotta ask? :))

Irfan Ali

[ADezii]

Hallo All,

I m trying to create a Multi User Data Program on Access, where my team members would input data on a daily basis.

Well the Problems start now :

- How do i create a Multi-user Environment, so that my Backend is on the Sharedrive(Local Server) and the Front end on the respective user systems?

- Well, once i achieve that, then how do i hide the Access data like Tables, Queries and Forms from Viewing by the user on the Front end?

- Also, how does one display a Internet Browser on a Form, which opens up the Google homepage, everytime the form is opened?(Which Activex Control and what Code)

- Last Q, like the Internet Browser, how do i integrate SAP in to a Form?Which Activex Control and what Code)

I know there are a lot of Q's, but sometimes when you gotta ASK, you gotta ask? :))

Irfan Ali

Here is an overly simplified response to a rather extensive set of questions. I
hope it helps or at least points you in the right direction. To respond in
sequence:

Set the Default Open Mode of the Back Ende Database to Shared via Tools, Options, Advanced, Default Open Mode (Shared is the DEFAULT). Have all the data (Tables) reside within a Database on the Share Drive (Back End). Create all the Application Objects (Forms, Reports, Queries, Macros, Modules) on the Local/Front End Database. Link to the Tables on the Back End Database via Tools, Database Utilities, Linked Table Manager. Multiple Users may now access the same data.

Right Click each Object you wish to hide in the Database Window and select the Hidden Check Box. Select Tools, Options, View, Show, deselect Hidden Objects (this is the DEFAULT). Reverse the process to View them again. Be sure to restrict Menu Access so this Option cannot be again activated by the typical User.

Insert, ActiveX Control, Microsoft Web Browser. Use the Navigate() Method of this ActiveX Control appropriately.

[NeoPa]

To hide the database window go to Tools / Startup. The options there give you plenty of control. Be careful though, to leave yourself a back-door, otherwise the one locked out could be yourself.
Otherwise, ADezii has the answers again :).

[irfanali]

Thanks a ton for the Reply Guys !!
Saved me a Lot of Trouble and Of Course, lot of my HAIR for the future :)

[elainenguyen]

Multiple users:
1. create a User table, at least contains, name, username and password
2. Create a log in form with 2 txt boxes re: username and password. Create a cmdLogIn Button. Put VBA code in the cmdLogIn Button in the On click event.
In the code compare the user input with the current users on your user table.
good luck!

[blyxx86]

Here is an overly simplified response to a rather extensive set of questions. I
hope it helps or at least points you in the right direction. To respond in
sequence:

Set the Default Open Mode of the Back Ende Database to Shared via Tools, Options, Advanced, Default Open Mode (Shared is the DEFAULT). Have all the data (Tables) reside within a Database on the Share Drive (Back End). Create all the Application Objects (Forms, Reports, Queries, Macros, Modules) on the Local/Front End Database. Link to the Tables on the Back End Database via Tools, Database Utilities, Linked Table Manager. Multiple Users may now access the same data.

Right Click each Object you wish to hide in the Database Window and select the Hidden Check Box. Select Tools, Options, View, Show, deselect Hidden Objects (this is the DEFAULT). Reverse the process to View them again. Be sure to restrict Menu Access so this Option cannot be again activated by the typical User.

Insert, ActiveX Control, Microsoft Web Browser. Use the Navigate() Method of this ActiveX Control appropriately.

I never would have thought to have seperate databases, one for the tables, and one for the forms/reports.. i forgot that it's possible to link multiple databases.

[NeoPa]

Think it now then Blyxx86!
This is a very handy technique and comes highly recommended for various reasons - not least is the cost of disk space having multiple versions of your code (front-end db).

[1BrnHny]

Would this solution also allow simultaneous data entry?