is there anyone on here who specialises in databases? i am looking to have one created for my bussiness.....the guy who was going to do it has run off scared by the size of it and he only does web based DB's. I already have one DB that runs on access and have no probs with it.....but now im looking for another to be created with similar data......can anybody offer any assistance?

cheers

kit:)

Depends on what you're looking for. Do you need design, implementation, support, development, or all of these.

Do you need a networked database or just a local one on a PC? Do you have licences for any RDBMS software or do you plan to use freeware? Do you need user interface(s) developing, or are you competent to do that yourself?

And so on ...

Feel free to pm me if you want advice on any of these.

nick will send you pm later as havent got a clue!!

k:)

Offers there if Nick doesn't want it.

cheesemonkster......its needs to be able to handle a few million records and be able to be used on two seperate machines......we already have one on each machine but need another with a similar set of data......

cheers

k:)

Doesn't sound like a job for Access, really, then.

Really depends on what data will be in it, and what kind of access you want to it.

have one one my laptop that runs on access and has about four million enteries on it and runs very well for past four years......just want something the same for a slightly different type of data but runs with the same fields:)

k:)

Not sure why the guy ran off if he only does web dbs. We have dbs running into the multimillions of records which are "web" access'd.

You could use a hosting company such as webhosting.com.uk running a mysql db with a custom front end, which you can access from anywhere..... mind you it depends how secure the data needs to be. Saying that anything you can put on the web, can be run from a local server.

he said that he was worried about how fast it would run because of the amount of data and the search options needed!.....he said he doesnt work with access at all!

K:)

Given the type of data, it should be possible to index it to give reasonable performance, and since you already have an existing example with very similar data, you should know if that's good enough...

I'm sure with the amount of techies on here we can sort you a solution kit.

cheesemonkster......its needs to be able to handle a few million records and be able to be used on two seperate machines......we already have one on each machine but need another with a similar set of data......

cheers

k:)

Any preference for Operating system, running on existing hardware, support required or is open source with a support contract ok etc etc.

Few million records is fairly easy for a proper RDBMS and two machine accessing it is not a problem.

Drop me a PM with more details if you like and I'll give it a quick nosey over.

As Nick said, not an Access job, which is always nice.

he said that he was worried about how fast it would run because of the amount of data and the search options needed!.....he said he doesnt work with access at all!

K:)

Third normal form, proper table design and a decent database with record level locking and you shouldn't hit any sort of problems.

As for how fast it will run, well if it's only two PC's accessing it, then it isn't going to get particularly stressed compared to some of the systems out there.

I think Access 2000 onwards handles locking - but bin a long time since I rock 'n' rolled.

Yes Access 2k onwards handles locking, but at a very very coarse level.

This means if more than one user is accessing the DB things are going to get very slow very quickly.

This all sorted yet kit? - Sorry for my late reply, only just noticed the thread.

Did the previous guy even bother to do a problem definition?

Well if it's only 2 users! Coarse? I think it caters for record level locking? Anyway the overheads (extra data storage I/O,CPU,Virtual memory) of a fully TNF database would be far more detrimental!

If he's got a large Access database that works fine for him (I wonder if it's a properly designed database or more of a spreadsheet/single table thing?), and he wants the same/similar spec. - I can't see 'scaling up' to 2 users is going to be a significant problem!

robshaw ....cheesemonkster going to have a look at it for me next week:)....just need to sort out a few of his queries then hopefuly should have it sorted.

Thanks ever so much to everybody for their help it was much appreciated:)

good to know that so many briskies are willing to help:)

cheers

kit:)

robshaw ....cheesemonkster going to have a look at it for me next week:)....just need to sort out a few of his queries then hopefuly should have it sorted.

Thanks ever so much to everybody for their help it was much appreciated:)

good to know that so many briskies are willing to help:)

cheers

kit:)

Fair play - Nice to know its sorted.

Rob.