corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » anyone know for a.. (i.t people)


New Topic

New Poll
  <<  1    2  >> Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author anyone know for a.. (i.t people)
Bart
Member

Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
5th Apr 05 at 08:44   View User's Profile U2U Member Reply With Quote

for a telephone database.. preferably in microsoft access?

willay
Moderator
Organiser: South East, National Events
Premium Member


Avatar

Registered: 10th Nov 02
Location: Roydon, Essex
User status: Offline
5th Apr 05 at 08:53   View Garage View User's Profile U2U Member Reply With Quote

what exactly do you want, find who owns a certain number, or what region of the UK are they in?
Bart
Member

Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
5th Apr 05 at 09:00   View User's Profile U2U Member Reply With Quote

sorry, i should have been more specific.

Im after starting my own personal database, to collate my own phone numbers.
But id really prefer to do this in microsoft access.

Adam
mjw_2k2
Member

Registered: 18th Sep 03
Location: Anglesey, North Wales
User status: Offline
5th Apr 05 at 09:07   View User's Profile U2U Member Reply With Quote

ok in ms access (office xp 2002) you can create a database which includes names contact numbers etc, using the built in wizard its quite simple to do, what version of office do you have? if u aint got xp version u2u me
willay
Moderator
Organiser: South East, National Events
Premium Member


Avatar

Registered: 10th Nov 02
Location: Roydon, Essex
User status: Offline
5th Apr 05 at 09:09   View Garage View User's Profile U2U Member Reply With Quote

use excel.... or outlook
Bart
Member

Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
5th Apr 05 at 09:11   View User's Profile U2U Member Reply With Quote

quote:
Originally posted by willay
use excel.... or outlook

i would rather use access, im also planning on sharing it with my colligue in the next office as we do alot of the same thing.

quote:
Originally posted by mjw_2k2
ok in ms access (office xp 2002) you can create a database which includes names contact numbers etc, using the built in wizard its quite simple to do, what version of office do you have? if u aint got xp version u2u me


I have office 2003 pro.
Should that have it?

Adam
Andrew
Member

Registered: 5th May 04
Location: Skoda Octavia Estate, Ford Puma
User status: Offline
5th Apr 05 at 09:12   View User's Profile U2U Member Reply With Quote

Dead easy to set up one in Access or even SQL.
Bart
Member

Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
5th Apr 05 at 09:13   View User's Profile U2U Member Reply With Quote

oooh.. dont tell me how easy it is... help me along then

I aint used access since i was at school lol
willay
Moderator
Organiser: South East, National Events
Premium Member


Avatar

Registered: 10th Nov 02
Location: Roydon, Essex
User status: Offline
5th Apr 05 at 09:13   View Garage View User's Profile U2U Member Reply With Quote

quote:
Originally posted by Bart
i would rather use access, im also planning on sharing it with my colligue in the next office as we do alot of the same thing.



Share it? Then try something like MS Exchange server, which can let you share contacts

Don't make more work for yourself.

[Edited on 05-04-2005 by willay]
Bart
Member

Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
5th Apr 05 at 09:14   View User's Profile U2U Member Reply With Quote

quote:
Originally posted by willay
Share it? Then try something like MS Exchange server, which can let you share contacts

Don't make more work for yourself.

[Edited on 05-04-2005 by willay]


dont use exchange server at work... not yet anyway
Andrew
Member

Registered: 5th May 04
Location: Skoda Octavia Estate, Ford Puma
User status: Offline
5th Apr 05 at 09:16   View User's Profile U2U Member Reply With Quote

You cannot share an Access DB unless they are used seperate.

The wizards are better from version 2000 and onwards but i always do it manual.
willay
Moderator
Organiser: South East, National Events
Premium Member


Avatar

Registered: 10th Nov 02
Location: Roydon, Essex
User status: Offline
5th Apr 05 at 09:17   View Garage View User's Profile U2U Member Reply With Quote

quote:
Originally posted by Bart
dont use exchange server at work... not yet anyway


Then think ahead,

Get exchange running, get it working nicely with Outlook, shared contacts. Then you can allow people to view their mail from home using some sort of http+IMAP setup, if you havent got something like already.

think ahead!

Bart
Member

Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
5th Apr 05 at 09:18   View User's Profile U2U Member Reply With Quote

quote:
Originally posted by Peugeot Nut
You cannot share an Access DB unless they are used seperate.




Well, we currently use an access program as a job book, which everyone has access to
Andrew
Member

Registered: 5th May 04
Location: Skoda Octavia Estate, Ford Puma
User status: Offline
5th Apr 05 at 09:19   View User's Profile U2U Member Reply With Quote

How have they managed that? I seriously would like to know!
Bart
Member

Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
5th Apr 05 at 09:20   View User's Profile U2U Member Reply With Quote

quote:
Originally posted by willay
quote:
Originally posted by Bart
dont use exchange server at work... not yet anyway


Then think ahead,

Get exchange running, get it working nicely with Outlook, shared contacts. Then you can allow people to view their mail from home using some sort of http+IMAP setup, if you havent got something like already.

think ahead!




that would be nice, but thats going up a different path...
*buy a server
*licence each pc to it (expensive)
labour cost to impliment this (expensive).

but its on the cards sometime, just not yet i think
Bart
Member

Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
5th Apr 05 at 09:22   View User's Profile U2U Member Reply With Quote

quote:
Originally posted by Peugeot Nut
How have they managed that? I seriously would like to know!


im not sure, there is a dude who has set it up (Doesnt work for the company).
There is a single mde file on each of our root dir and then there is another couple of files on the shared mapped drive.
I know that the job book wont open if the mapped drive (snap server) is turned off, so they must talk somehow.
Andrew
Member

Registered: 5th May 04
Location: Skoda Octavia Estate, Ford Puma
User status: Offline
5th Apr 05 at 09:26   View User's Profile U2U Member Reply With Quote

That deffo Access? I was told at uni that you could not share a db in Access and would have to use SQL. I did try and do it at one point to but couldn't see any tools to do it

IF you could find out how's it's done i would be really greatful !!!
Bart
Member

Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
5th Apr 05 at 09:28   View User's Profile U2U Member Reply With Quote

i'll see what i can do
Andrew
Member

Registered: 5th May 04
Location: Skoda Octavia Estate, Ford Puma
User status: Offline
5th Apr 05 at 09:30   View User's Profile U2U Member Reply With Quote

Cheers dude
willay
Moderator
Organiser: South East, National Events
Premium Member


Avatar

Registered: 10th Nov 02
Location: Roydon, Essex
User status: Offline
5th Apr 05 at 09:31   View Garage View User's Profile U2U Member Reply With Quote

quote:
Originally posted by Bart
quote:
Originally posted by willay
quote:
Originally posted by Bart
dont use exchange server at work... not yet anyway


Then think ahead,

Get exchange running, get it working nicely with Outlook, shared contacts. Then you can allow people to view their mail from home using some sort of http+IMAP setup, if you havent got something like already.

think ahead!




that would be nice, but thats going up a different path...
*buy a server
*licence each pc to it (expensive)
labour cost to impliment this (expensive).

but its on the cards sometime, just not yet i think


So? Money isnt suppose to be your problem, thats your bosses.
Bart
Member

Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
5th Apr 05 at 09:35   View User's Profile U2U Member Reply With Quote

yer, tis my problem.
Ive just upgraded EVERYONES pc at work, and spent a fortune, and got them out of the licence trouble they were in when i first joined (well nearly now).
willay
Moderator
Organiser: South East, National Events
Premium Member


Avatar

Registered: 10th Nov 02
Location: Roydon, Essex
User status: Offline
5th Apr 05 at 09:42   View Garage View User's Profile U2U Member Reply With Quote

look for an open source alternative then.
Bart
Member

Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
5th Apr 05 at 09:43   View User's Profile U2U Member Reply With Quote



excel?
willay
Moderator
Organiser: South East, National Events
Premium Member


Avatar

Registered: 10th Nov 02
Location: Roydon, Essex
User status: Offline
5th Apr 05 at 09:44   View Garage View User's Profile U2U Member Reply With Quote



Does it have to run on Windows or do you have some linux/sun/bsd boxes knocking about?
Bart
Member

Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
5th Apr 05 at 09:49   View User's Profile U2U Member Reply With Quote

ideally run on windows.

But there is a snap server with linux, but very basic

  <<  1    2  >>
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
Schumacher brothers Shelly General Chat 28 1351
22nd Apr 03 at 12:14
by Cybermonkey24
 
honda owners are fcuking snobs kz General Chat 21 1018
7th May 03 at 08:10
by LoudandLow
 
i dont suppose... (NW?NE meet!)... L33 LEG North West and North Wales 67 1307
8th Jul 04 at 17:04
by Bling Bling Pimp
 
Richbrook steering wheels *NOW 79.95* ENDS TODAY! cargraphics4u.com Parts Offered 33 2097
28th Aug 04 at 14:05
by lee gsi
 

Corsa Sport » Message Board » Off Day » Geek Day » anyone know for a.. (i.t people) 28 database queries in 0.0156920 seconds