[SOLVED] Sharing File on server

[browie]

Is it possible to have a network use the same file at the same time and all
changes saved to the 1 file. I am writing a database so 7 people can use it
at my workplace but the problem is that if only 1 person can access it at a
certain time I will have to rethink my stratergy.

Thanks

Greg

[JamieMorien]

It is a built in function of MS Access. No need to do anything special. What is the problem in implementing this?

[Anne Troy]

You can share workbooks, but there are limitations.
See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"browie" <[email protected]> wrote in message
news:[email protected]...
> Is it possible to have a network use the same file at the same time and
> all changes saved to the 1 file. I am writing a database so 7 people can
> use it at my workplace but the problem is that if only 1 person can access
> it at a certain time I will have to rethink my stratergy.
>
> Thanks
>
> Greg
>

[William Benson]

I am guessing he is creating a database in Excel, not Access.

So, why can't you save it as a Shared Workbook?
Tools - Share Workbook, click "Allow changes ..." on the Editing tab.

"JamieMorien" <[email protected]>
wrote in message
news:[email protected]...
>
> It is a built in function of MS Access. No need to do anything special.
> What is the problem in implementing this?
>
>
> --
> JamieMorien
> ------------------------------------------------------------------------
> JamieMorien's Profile:
> http://www.excelforum.com/member.php...o&userid=19499
> View this thread: http://www.excelforum.com/showthread...hreadid=399320
>

[browie]

Yeah thanks for that, I looked throught the options and found it. Feel like
a bit of a twit.

Thanks for your help

Greg
"William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in message
news:%[email protected]...
>I am guessing he is creating a database in Excel, not Access.
>
> So, why can't you save it as a Shared Workbook?
> Tools - Share Workbook, click "Allow changes ..." on the Editing tab.
>
> "JamieMorien" <[email protected]>
> wrote in message
> news:[email protected]...
>>
>> It is a built in function of MS Access. No need to do anything special.
>> What is the problem in implementing this?
>>
>>
>> --
>> JamieMorien
>> ------------------------------------------------------------------------
>> JamieMorien's Profile:
>> http://www.excelforum.com/member.php...o&userid=19499
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=399320
>>
>
>

[William Benson]

No need to be so hard on y'self Greg.

"browie" <[email protected]> wrote in message
news:[email protected]...
> Yeah thanks for that, I looked throught the options and found it. Feel
> like a bit of a twit.
>
> Thanks for your help
>
> Greg
> "William Benson" <wbenson1(SPAMSUCKS)@nycap.rr.com> wrote in message
> news:%[email protected]...
>>I am guessing he is creating a database in Excel, not Access.
>>
>> So, why can't you save it as a Shared Workbook?
>> Tools - Share Workbook, click "Allow changes ..." on the Editing tab.
>>
>> "JamieMorien" <[email protected]>
>> wrote in message
>> news:[email protected]...
>>>
>>> It is a built in function of MS Access. No need to do anything special.
>>> What is the problem in implementing this?
>>>
>>>
>>> --
>>> JamieMorien
>>> ------------------------------------------------------------------------
>>> JamieMorien's Profile:
>>> http://www.excelforum.com/member.php...o&userid=19499
>>> View this thread:
>>> http://www.excelforum.com/showthread...hreadid=399320
>>>
>>
>>
>
>