Question multiple user file

[hotmalepiyush]

hii,
i am new to access. i must say i am really amazed by its power. i have worked on a single user file so far. now i need to implement a multiple user file. i have no idea how to get started.. i read that i should have my tables on server and front ends on clients.. but how do i connect different Access running on the lan. please give me a head start asap.

piyush

 

[NigelShaw]

Hi,

ive been doing access non stop for about 12 months now and im not at all ready to delve into the multi user environment.
its not as easy as " connect this to that and hey presto, it works"

there is alot of understand how code works, knowing what your objects are and so forth. from my experience on this forum too, everyone is very knowledgable but wont actually do it for you, i suppose the ideas is to offer a suggestion of how you think it might work and ask for guidance rather than "i need it ASAP"

sure, small things can be directly asked like "how do i run a query between 2 dates" but big stuff?

there are some good books around

Access 2007 VBA ( diamond & spalding) is very good and covers your need. i got mine from borders.

good luck

NS

 

[KenHigg]

Put your tables in one database file and put it on the server. Then put everything else in a second database file and connect to the server tables with file->Get External Data->Link Tables. Then put a copy of this database file on each workstation.

 

[hotmalepiyush]

hey ken,
thanx for the start..

 

[KenHigg]

Glad to help -

 

[hotmalepiyush]

i have shared my tables in one computer(filename: academy).. and then in another pc.. i created another database..(filename: acads).. and linked it ith academy.
i have given all read write permissions for the folder containing the tables file..
but i need some kind of discretion...
for example if 5 different users are updating the tables.. they can only change the records which they have added.. but can view all... can this be achieved using Access

help
piyush

 

[khawar]

first of all add information with data that who added it then on the form used for editing get the name of the user who is logged in and filter the data added by that user

 

[hotmalepiyush]

first of all add information with data that who added it then on the form used for editing get the name of the user who is logged in and filter the data added by that user

i am not clear at all how to do this..

 

[khawar]

In a multiuser environment you also have to track the users logged in and what transaction is posted by which user

this information will be required to get the entries by a specific user and later on to show the user only those entries which were posted by him

 

[hotmalepiyush]

In a multiuser environment you also have to track the users logged in and what transaction is posted by which user

this information will be required to get the entries by a specific user and later on to show the user only those entries which were posted by him

this is what i am asking..
how to track the users logged in and what transaction is posted by which user

 

[khawar]

When some one log into the access (manually) save the user name some where and when that user post some record get the name of saved user and save it with the record being posted in a column named posted by which will then be used later on to track that the record was posted by whom

 

[hotmalepiyush]

i am new to access and have limited knowledge of VB. how do i save user's name manually

 

[khawar]

Zip file contains 2 access databases named

Multiple User Fe (Front End)
Multiple User Be (Back End)

copy Multiple User Fe to two different locations refresh links to backend (press shift while opening)
place back end file any where you want (preferably on the server)

Then login from both Front ends using different user names

you will see user is able to see only those transaction which are entered by him
and also new transactions entered by the name of user currently logged in

this is just a sample to get you started

 

[hotmalepiyush]

hey khawar.. its asking for user name and password.. please let me know that so that i can open the files

 

[khawar]

Select user name from the list and password for both users is 12345

 

[hotmalepiyush]

list is blank dude

 

[khawar]

I think you have not read the instructions
link the backend first the it will show data in the list

 

[hotmalepiyush]

replication

while browsing the forums.. i found something cvalled replication..
i have split the DB into front end and back end.. and placed copies of FE on different desktops.. do i need replication.. it seems quite complex..

comment please

 

[khawar]

Have you linked the backend and logged into it

 

[hotmalepiyush]

as of now i am working on the same PC and still designing the forms and queries.. i have linked and logged into the BE but not on network.. on the same PC.. earlier i tested linking a table on another PC and was successful.. but at that moment i had no securities enabled..