Re: FN-FORUM: Access V Excel

date posted 28th June 2007 13:00

Hi,

SQL Server is always set for shared priv (except the developer version, I
think). The problem is probably when you open the Access (MDB etc.) files.
Check the open commands and make sure they have shared in the connection
string. I can't remember the correct one off the top of my head, but if you
do a search for connection strings and shared, you should find some
examples.

Cheers,
Nigel

----- Original Message -----
From: "PuntersPower" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Thursday, June 28, 2007 12:40 PM
Subject: RE: FN-FORUM: Access V Excel


>
> 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
>>
>>
> --
> 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
>
>