Sharing Access file

[Rakesh935]

Hello,

Well I want to create a access file which would happen to be one of the database for my organization.

My question is which way would be the best way to share the access file among multiple users.

I tried doing split database but unfortunately i figured out, that same record is reflecting for update when multiple users are working at the same time.

Requesting your help in creating the database.

Thank you,
Rakesh

 

[Rakesh935]

An access table having more than 70,000 records (line items), needs to get processed. In order eliminate scrolling of data I executed a SQL query which will show only 1 record (line item) at a time, once after processing the record and after clicking refresh the next new record will reflect.
Apart from the data in the table I have added another two more new columns in the table (i.e. User name – which is the system name and Date of process - system date) which will be capturing automatically. Additionally, considering huge volume the access file will be shared between at least 20 people simultaneously to be worked.
Hence, the requirement is to capture who has worked in what record and on what date plus all people working in the file must see one record only (any 2 or more persons mustn’t see the same record) and after processing the record the user must click the refresh button to get a fresh record for process.
Requesting to guide me in order to create the tool.
Note:
The new record showing criteria would be – show next record for which User name is blank.

Hope this clarifies.....

Thanks,
Rakesh

 

[Rakesh935]

Hello,

Been trying to get the force save done....but so far been a good looser in doing it.....i am really confused how to proceed further......

Attached is the access file which i have done so far, requesting to please have a view of it and guide me for what else do i need in order to get it work.

Thanks
rakesh

 

[Rakesh935]

Oh God!!!

Before starting up this tool i thought this would be a cake walk but now m realizing its getting more and more complicated :banghead:.

Anyways, one last help....is it possible.....to make multiple users see one unique record i meant if 10 users are using the copy of the tool at the same time then they must see only one unique record for process and subsequently two or more users mustn't see the same record for e.g. if "A" is processing a record then "B" shouldn't see the same record for process which is "A" is processing or vice-versa.

In other words the records must get locked under the particular user name.

If this can be possible then what should be the VBA code for it and where it should get executed.

Please help me for the above requirement.

Thanks
Rakesh