Re: FN-FORUM: Access V Excel

date posted 28th June 2007 11:40

sounds good to me, are you available for a few pointers for form creation ;)
--
http://www.punterspower.co.uk

>
> Hi,
>
> You can have more than one person writing to an Access DB. You have to
> make
> each person open the database in shared mode rather than exclusive. I've
> had numerous arguments over the years about how good Access is for
> multi-user systems but I stand by my 5 users or less policy. Any more
> than
> 5 users and you are just asking for problems. To allow multi-user access.
> The database file(s) need to be on a shared drive and Access installed on
> the client machines. You can also use an application sharing solution
> like
> Terminal Server.
>
> As far as Access vs Excel goes, it's a matter of complexity. For a couple
> of tables, Excel is fine, but for more tables or for more flexiblity for
> calculations, use Access. I generally, build an Access Database and use
> Excel as an import/export tool. For import, it can validate data, and for
> export, it can be used to visualise the data easily. Also users are more
> comfortable with Excel for data entry and it's very easy to Access and
> Excel
> using VBA and/or ODBC (or ADC etc.).
>
> Hope it helps,
> Nigel
>
>
> ----- Original Message -----
> From: "PuntersPower" [EMAIL REMOVED]
> To: [EMAIL REMOVED]
> Sent: Thursday, June 28, 2007 10:52 AM
> 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
>
>