RE: FN-FORUM: Access V Excel

date posted 28th June 2007 12:23

so, would I be correct to assume the MSSQL DB not having the correct
shared priv is the problem for not allowing 2 people at the same time to
edit data?
--

>
> Hello Andrew,
>
> Sorry should have finished reading you email before I replied. In answer
> to
> your question about multi-user access it does not need to be on a server
> at
> all it could be on a peer to peer system but the key thing you have to do
> is
> split the database so you have a backend and a front end to you access
> application and you put the backend into a shared directory and put the
> front end on the users machine.
>
> Mark
>
> Mark Robinson
>
> Software/Database Developer
>
> Telephone number 0208 133 4150
>
> Call me!
>
>
>
> This e-mail is intended for the above named person only and should be
> treated as confidential. If this has come to you in error you should take
> no
> action based on it,nor should you copy or show it to anyone; please
> telephone us immediately.
>
>
>
>
> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] Behalf Of
> PuntersPower
> Sent: 28 June 2007 10:53
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM: Access V Excel
>
>
>
>
> Does any have a preference for Access over Excel and main reasons why?
>
> I've recently built a supplier DB in Access using Access Project Backend
> MSSQL for sharing reasons, the only problem is only one person at a time
> can access Access for writing data, which is the main reason I didn't want
> to use Excel.
>
> To have multi user write priv on Access would it have to be installed on
> the server?
>
> Andrew
>
> PS. Anyone know of a really good advanced Access training course in the
> Midlands?
>
> PSS. Does anyone know how to retrieve deleted emails from outlook?
>
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>