M Zahid
asked on
Access Data based linked with Excel file
Hello Sir / Madam,
I have Access Data base & linked with the 2 different Excel file for test run, & which runs perfectly however when I try active Share Workbook for the multiple users can work on the excel files but I cant.
Therefore kindly help is there any option where I could share the excel file with the access database linked?
Thx,
I have Access Data base & linked with the 2 different Excel file for test run, & which runs perfectly however when I try active Share Workbook for the multiple users can work on the excel files but I cant.
Therefore kindly help is there any option where I could share the excel file with the access database linked?
Thx,
It's my experience that you can't.
If either Excel or Access has the file opened, at the best the next application (Excel or Access) can gain read-only access.
If either Excel or Access has the file opened, at the best the next application (Excel or Access) can gain read-only access.
ASKER
thx for the response Sirs,
@Ryan file are already in the shared directory but only one user can use or update & i cant active Share Workbook option for multiple user.
@Gustav not getting the read only even boht Excel or Access are edit able, but problem same as above :(
@Ryan file are already in the shared directory but only one user can use or update & i cant active Share Workbook option for multiple user.
@Gustav not getting the read only even boht Excel or Access are edit able, but problem same as above :(
Then you must find another way to set this up.
Have in mind please, that Excel in its core is a single user application. The shared feature is somewhat half-hearted, and the on-line version (Office 365) is a completely different animal behind the scene.
Have in mind please, that Excel in its core is a single user application. The shared feature is somewhat half-hearted, and the on-line version (Office 365) is a completely different animal behind the scene.
Access does not play well with others and will not share a file that is already opened - period.
If you have to import this data while others have the file opened, you can use FSO to copy the file to a temp folder where you will have complete control. You can then link to the file and do your thing. At the end, delete the copy.
If you have to import this data while others have the file opened, you can use FSO to copy the file to a temp folder where you will have complete control. You can then link to the file and do your thing. At the end, delete the copy.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes. An Access database with tables (called and backend ) can be linked to multiple frontends - the Access application with forms, reports, etc. - one copy for each user.
ASKER
can i have some example file to see how is work & all plz?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.