Recent content by starson79

Right I'll try again - just lost the previous post. I wasn't sure what search terms to use to research this problem so I'm hoping that someone here will have some ideas. I've got an Access 2003 database. A user might have a project record open in the database - and then navigate away / leave...

Hi - it's a Project Management System essentially. Right through from Customer Enquiry to Invoice, Stock Management, workload per Employee, After Sales Service. I'm being trained up as an in-house developer - to save on costs otherwise spent on a new CRM system. The employees have been stuck...

Hi All First of all just to say hello to fellow database gurus (I wouldn't say I'm a guru - yet!) I'm feeling the pressure to produce a new database system for a new employer. First time I've managed my own database project and I'm struggling to organise myself and to cope with the...

Hi, Yeah from what I can see there are a few gigantic tables with many many tiny tables (one field to be precise!!). Yes I did think this would be a complete overhaul when I first looked at the database - I just didn't think the previous "database developer" would have left out normalisation...

Hi I've tried searching the Net for this but not come across any useful answer. I have just taken over several existing databases which I need to tidy-up / upgrade - whatever you can think of. After some investigation I realise that no table relationships have been defined whatsoever. However...