Re: FN-FORUM: Access V Excel

date posted 28th June 2007 13:03

Hi,

I am available, contact me at [EMAIL REMOVED] directly to organise it.

Cheers,
Nigel

----- Original Message -----
From: "PuntersPower" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Thursday, June 28, 2007 11:59 AM
Subject: Re: FN-FORUM: Access V Excel


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