A thought about Microsoft

entwisi said:
heh, now for the benefits of Linux ownership - Support

Whats your database run in? Access or something else (Sql server?)

You'll find thousands of people who will happily help you for nothing in the Linux community. You will also find that people share their experiences freely and if they find a solution to a problem often fully documnent it so others don't suffer the same fate.
Click to expand...

Good morning Ian, it runs in access, see that is how numb I am, forgot to mention that, I am going to try it later on the less used laptop, the website seems to infer that the server option is prefferable, I don't even know what the difference is, I am working today, (someone has to keep the ship afloat), but should be able to sneak back later.
 
Personally use the 'normal' version. The server CD has more server packages on the disc at the expense of 'user' stuff. Its all in the software repository anyway so makes no real difference once your up and running as it will always download from the online repos first to make sure its got the latest version.

With regards to your database, as you probably know Access is MS proprietry software which is not just a database. It includes a application front end ( the forms etc ). Depending on the access database you use will depend on if/how easy it is to migrate to linux. In all honesty, if what you have works for you then you should be wary of change for changes' sake. If what you have has flaws that you are finding hard to live with then look at changing.

May I ask who wrote the database app for you? is it an off the shelf package or bespoke for you?
 
entwisi said:
Personally use the 'normal' version. The server CD has more server packages on the disc at the expense of 'user' stuff. Its all in the software repository anyway so makes no real difference once your up and running as it will always download from the online repos first to make sure its got the latest version.

With regards to your database, as you probably know Access is MS proprietry software which is not just a database. It includes a application front end ( the forms etc ). Depending on the access database you use will depend on if/how easy it is to migrate to linux. In all honesty, if what you have works for you then you should be wary of change for changes' sake. If what you have has flaws that you are finding hard to live with then look at changing.

May I ask who wrote the database app for you? is it an off the shelf
package or bespoke for you?
Click to expand...

Don't know that it was written as such, just the ms access blank, with the bits filled in, but there are about 6,500 clients in and multiple entries for each client, some of the history for older clients is 4 pages long, which is another problem, you cannot just print 1 page of a client history.
 
Can I ask what you use it for?

I'm certainly not offering to do owt ( been there, still got the scars) but sounds like its not really the right tool for the job. You need queries that allow you to set date ranges for reports and some tools to archive old data (Access isn't good when it gets over a certain size)

I guess its a bit like me doing my own plumbing, I'd be all hammer and pliers :D
 
entwisi said:
Can I ask what you use it for?

I'm certainly not offering to do owt ( been there, still got the scars) but sounds like its not really the right tool for the job. You need queries that allow you to set date ranges for reports and some tools to archive old data (Access isn't good when it gets over a certain size)

I guess its a bit like me doing my own plumbing, I'd be all hammer and pliers :D
Click to expand...

Yes, It is a database with customer name, address etc, when an installation, service, breakdown call or query is made, each call is then typed up on that clients own profile page (for want of a better description), when a client calls, we can have that clients complete history in front of us both in the office and on the road, so, all past problems, advice given, costs given, installation dates (for guarantees) etc is instantly available, we also log type of appliance and accessories, so if a call is for a breakdown, we don't always need to visit, and can just take the correct part, this saves them money, we also use it to bring up all the clients who are due annual service in a particular month, trouble is, we then have to manually go through them to put them in areas, then type letters for areas with dates allocated, all this as you can imagine is time consuming, and we are so busy now that the system, and the girls have difficulty keeping up, given that we have 3 teams, 6,500 clients, and about 30 phone calls per day at this time of year, it can be quite stressful.
 
NOt being funny but what you need is a proper CRM solution. Access is not the right tool for this for a business the size you describe.


I'll do some digging of what alternatives you have
 
entwisi said:
NOt being funny but what you need is a proper CRM solution. Access is not the right tool for this for a business the size you describe.


I'll do some digging of what alternatives you have
Click to expand...

Good man, thank you, I tried contacting a fellow at work who knows more about it than I do, but he is unnavailable.
 
You must log in or register to reply here.
Back
Top