multiple users

[jonamua1971]

i have a database which is shared on the network. i have one problem right one. when one is using the database, another person cannot access it. what can i do to enable multer user access it at the same time.
Any help will be highly appreciated.

 

[dcobau]

you should have the tables in 1 db (back end - BE) and the user interface (front end - FE) in a 2nd db. A copy of the 2nd db, linked to the 1st db, should be installed on the hard disk of each user. This way users can access the BE at the same. Access will still block some of the records used by users (I cannot recall the details off hand) but will allow the majority of records to be available. Look up help on split database.

Dave

 

[jonamua1971]

thank you so much for response. we are on thin network. so how can we do that. im bit confused. i have never done it, though i know what to . my concern is how do i do it in thin network enviroment. the administrator told me he cannot do it with ntfs permisssions. the users are all trying to access the database at the same time which is stored on the server. if i split the database will it change or delete the data?? thanks inadvance for your help

 

[boblarson]

I would highly suggest each user get a copy of the front-end and not have multiple users opening the same file. With a front-end backend situation, your front ends can be linked to the same database. There is a Utility within Access to split to front-end backend. The splitter basically just takes your tables out of your database and puts them in a new backend file and then links the tables in the front-end.

Check out this post for more information (and for a free tool I wrote to enable auto updating for front-ends so you never have to send a user a new front end; they can get it automatically when you modify your master).
http://www.access-programmers.co.uk/forums/showthread.php?t=124694

 

[jonamua1971]

thanks B
I will try that tomorrow.

 

[jonamua1971]

i went through the procedure you showed but its intended for full network enviroment. i am on a thin client set up. so iam a bit confused how to set it up. the database is located on the main sever which is accessed by many users but not more than fifteen. do i split the database from its location, or do i do it from a different location and transfer?? please help
thanks so much for your help

I would highly suggest each user get a copy of the front-end and not have multiple users opening the same file. With a front-end backend situation, your front ends can be linked to the same database. There is a Utility within Access to split to front-end backend. The splitter basically just takes your tables out of your database and puts them in a new backend file and then links the tables in the front-end.

Check out this post for more information (and for a free tool I wrote to enable auto updating for front-ends so you never have to send a user a new front end; they can get it automatically when you modify your master).
http://www.access-programmers.co.uk/forums/showthread.php?t=124694

 

[dcobau]

Split the db up and keep the tables on the main server. A copy of the FE should be kept as a master (wherever you wish) and a copy should be placed on the hard disk of each of the users pc. Each FE should be linked to the tables in the BE.

Dave

 

[MicroE]

Dave - jonamua1971 is on a thin client – so there is no local hard drive.

You can create a folder for the application in each user’s home directory (usually my documents) and place the FE there.

 

[The_Doc_Man]

There is still the issue of (A) workgroup security and (B) share permissions.

In reverse order, your users MUST have full access or no less than modify access (using file object >> right-click >> properties >> security if you are on Win NT, 2K, or XP Pro). You can search the forum for the issue of permissions in the target folder.

However, none of that does any good if everyone comes in through the default workgroup file, because in that file, everyone is Admin and has Open Exclusive access. You don't want that, either.

 

[jonamua1971]

thank you all for your response. i will try that.