Network Databases

[Phonik]

Just trying to get some more replies...

This post is really aimed at someone that has experience of network databases and the problems they can pose but if you can help at all that would be great!

I work for an insurance company and we have created a database for registering complaints on. The one we currently use is a single .mdb file which can be shared by up to 60 people at any one time. This is creating a lot of problems when the queries and some VBA code are run. I therefore made a server file which is just an mdb file with data tables in and NO forms or queries. This file is stored on a shared drive on the network server. We then created a client file which contains all of the forms and queries and code. This file contains linked tables to the server so when data is entered into the form, it "Sends" it to the server mdb file. The client is installed on each of the local machines c:. The problem with this was that if we made a change to the database, we would need to reinstall the client on every single user pc. This would of took ages. I therefore made an auto-update function that checked the version number on the server and if the server number was greater than the client number, a simple .bat fiile was run which copied the updated client file from the network to the relevant users local disk.
The problem we have now is that our IT department are concered that if we make a change to the client and all the staff log in at 9am for example, it will start doing multiple copying of a file around 8mb in size to around 60 machines. They are only running on a 2meg pipe so this could cause some problems. We are not looking to change the client & server idea but does anyone know if this will have a big impact and infact if the updates for 60 machine is the equivalent or lesser of 60 people sharing the single file i mentioned earlier. If the IT dept are happy with 60 users accessing the same file at the same time, which they currently are, why are they unhappy with it updating these machine using the new method.

Would really apopreciate any thoughts anyone has..

Thanks a lot.

 

[Pauldohert]

Just trying to get some more replies...

This aint the way to do it.

If you must bump the previuos thread - since its at the top of the list before you started this one there is no need.

You have asked for a more opinions in a differnat post within 30 minutes of posting the original question and without thanking the replies to your original!

My advice to anyone thinking of replying is to reply to someone with more manners than yourself.

 

[Phonik]

Ok.. well I see that you clearly did not notice my pre-emptive thank you in anticipation of responses.

The reason I put another thread is that I thought when people see a thread has been replied to they will not bother to post a reply assuming it has been answered. I am sorry that I have not conformed to your manner requirements on this occassion but I have a very serious problem here that I need some advice on. I was told that this was the place but clearly it is full of the same amount of snotty people as all the other sites.

Thanks for your response.

 

[Phonik]

And by snotty people I am referring to those that actually spend time complaining about the context of peoples posts and not those fantastically helpful people that posted very useful and helpful messages...thank you to those people.

 

[ByteMyzer]

Ok.. well I see that you clearly did not notice my pre-emptive thank you in anticipation of responses.

It is a common misconception that a pre-emptive thank you is a substitute for a genuine expression of appreciation after the fact. I'm sure you can understand Pauldohert's objection.

You have asked for a more opinions in a differnat post within 30 minutes of posting the original question and without thanking the replies to your original!

Here I agree with Pauldohert. Please try to see it from the Customer Service perspective. If a client calls to check on the status of an order once, it is simply a case concerned customer who reasonably deserves the answer that the order will be shipped next week. If a client then calls to check on the status of an order two or three times in one day, it becomes irritating due to the unreasonable expectation that anything about the status of the order is likely to have changed, particularly if it is beyond the power of the Customer Service Rep to effect a change.

The reason I put another thread is that I thought when people see a thread has been replied to they will not bother to post a reply assuming it has been answered.

At times, this can and has been the case, but not always. It is not fair to assume the worst without sufficient basis.

I am sorry that I have not conformed to your manner requirements on this occassion but I have a very serious problem here that I need some advice on. I was told that this was the place but clearly it is full of the same amount of snotty people as all the other sites.

Not a fair nor appropriate judgement from someone who has displayed such rude behavior, however unintentionally. There has been a history in these forums of users creating multiple threads, all for the same request, and the most that this accomplishes is to make it more difficult to track or to properly respond to these threads with a productive solution. As such, I can't really fault Pauldohert for his "snotty" response, as you call it.

We're here to help; really we are. If you would have us give you a chance, it is not unreasonable to expect you to give us the chance.

 

[Phonik]

It would appear that I have misunderstood the way in which these forums work. I did not know there was a collective group of you that sat and read these all day..for that I apologise. I am new to posting but not programming and I clearly have not learned the correct etiquette when using this service.
I will thank all that reply to my posts as I am not an ungrateful person in the slightest and resent being told so. If you are supposed to be giving chances as you mention in your previous post, surely Pauldohert should of simply left it at telling me to say thank you instead of continuing to tell people not to reply as I am rude..that rubbed me up the wrong way and I hope you can understand this. I will post only once per subject and leave it at that!
Thanks for actually taking the time to iron this out that...good man
PaulDohert: I consider this a learn and look forward to conversing again.

Regards,

Gareth

 

[Phonik]

Great start! The site went a bit weird and it didnt look like my message posted when it actually did it three times.
Sorry

 

[boblarson]

Just as an FYI, you can go back and delete multiple posts. Just click the edit button on the one you want to delete and then select delete from the options at the bottom of the editing window.

 

[Phonik]

Brilliant! Thanks for your help!

 

[The_Doc_Man]

Phonik, since you got a little rough around the edges, you should learn something about this site and perhaps put yourself in our situation.

We are ALL volunteers here, many of us having learned at the School of Hard Knocks. We share our knowledge freely and willingly. But when someone posts the same topic several times in the same forum within minutes to hours, it is EXACTLY the e-mail equivalent of span or the web equivalent of a pop-up ad that won't die. It's just that this is neither a forum NOR an ordinary web site. How annoyed are YOU when a pop-up or spam keeps coming back to haunt you.

Another thing to remember is that you literally have a WORLD of help here - but not everyone is an expert in everything. If it takes 10 minutes - or 10 hours - for someone to log in who knows about your problem, so be it. Or "that's the way the cookie crumbles." I guess I'm saying "patience" is the key to using this site well.

Finally, your wording makes it seem like you have an urgent problem. Don't take this wrongly, but the higher the urgency, the less you should rely on this site for anything. As I said, we have a WORLD of programmers here - probably at least 12-15 time zones - and not all of us are awake at the same time. Further, it is the nature of this beast that we can only give relatively short answers. If your problem is REALLY urgent, it is time to hire a consultant - not because such a person knows more than we do. But such a person can better respond to your urgency.

I've tried to keep my answers non-hostile because we WELCOME the chance to help people. CERTAINLY including you. But if you try to use us in a way unsuited to our medium of communication, you will sometimes get hostile responses from those folks who have no patience with impatience. (Try not to think about that one too hard.... - it'll make your head hurt.)

 

[Pauldohert]

Phonik , alls good - I hope you got your original question answered.