473,324 Members | 2,511 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Examples Of Larger Systems Built On MDB Backends

I've been asked to build a system that is considerably larger than
anything that I've done before and I'm trying to determine if an mdb
backend is up to it. The system is not mission critical to the point
where the loss of a day's data would be a catastrophe.

It will probably be running on terminal server. If I understand
terminal server correctly this will be slightly more robust than a
frontend/backend setup where each user has the frontend on their
machine. I'm assuming that if the backend and each user's frontend
profile is on the server all the problems that can arise from faulty
network connections etc will be removed.

I'm interested to hear of examples of "large" (a very subjective term)
database systems that have been built by contributors to this forum
that work reliably on an mdb backend.

Any help is appreciated.
Jan 9 '08 #1
5 1143
On Tue, 8 Jan 2008 16:32:24 -0800 (PST), Wayne
<cq*******@volcanomail.comwrote:

Let me turn that around and let you give a synopsis of what your app
would do, and how many forms and reports you expect in the final
product. Also how many CONCURRENT users.

-Tom.
>I've been asked to build a system that is considerably larger than
anything that I've done before and I'm trying to determine if an mdb
backend is up to it. The system is not mission critical to the point
where the loss of a day's data would be a catastrophe.

It will probably be running on terminal server. If I understand
terminal server correctly this will be slightly more robust than a
frontend/backend setup where each user has the frontend on their
machine. I'm assuming that if the backend and each user's frontend
profile is on the server all the problems that can arise from faulty
network connections etc will be removed.

I'm interested to hear of examples of "large" (a very subjective term)
database systems that have been built by contributors to this forum
that work reliably on an mdb backend.

Any help is appreciated.
Jan 9 '08 #2
Per Wayne:
>I've been asked to build a system that is considerably larger than
anything that I've done before
Define "larger".
--
PeteCresswell
Jan 9 '08 #3
Wayne wrote:
Thanks Tom and Pete for your replies.

The database would handle production data from pit to port including
tonnages mined, preparation plant data and shipping data.

In very rough terms the database would have about 20 tables, each
table would have no more than a dozen fields. Data entry would be
about 6 records per day into a few of the tables and less than that
for the rest. It would have a about 30 forms, 30 or 40 queries and
about 25 reports. Concurrent users would be less than 6.
That does not meet any reasonable definition of "larger". You should be fine.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Jan 9 '08 #4

"Wayne" <cq*******@volcanomail.comwrote in message
news:0a**********************************@s19g2000 prg.googlegroups.com...
It will probably be running on terminal server. If I understand
terminal server correctly this will be slightly more robust than a
frontend/backend setup where each user has the frontend on their
machine. I'm assuming that if the backend and each user's frontend
profile is on the server all the problems that can arise from faulty
network connections etc will be removed.
Each user will get a copy of the front-end in a terminal server enviroment.
Also each Access user needs be treated as a power user when sizing the
server.
Jan 9 '08 #5
Per Wayne:
>In very rough terms the database would have about 20 tables, each
table would have no more than a dozen fields. Data entry would be
about 6 records per day into a few of the tables and less than that
for the rest. It would have a about 30 forms, 30 or 40 queries and
about 25 reports. Concurrent users would be less than 6.
I'd expect no problems with less than 6 concurrent users.

As far as number of tables/fields/forms/queries/reports go, I'd
call that a relatively small application.

The only MDB-specific issues that I can see are:
-----------------------------------------------------------------
1) Unexpected LAN problems. Flaky server, bad NIC, whatever....
But I'm guessing you're in a position to quickly move the back
end to another server, so that's not the potential problem it
would be in a large organization where they have everything
totally locked down and you have to go to committees and wait
for months for a move.

2) IT deploying a later version of MS Access. Minor nuisance,
but it can break an application until somebody makes the
needed adjustments. Again, size of organization...
-----------------------------------------------------------------
--
PeteCresswell
Jan 9 '08 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: w | last post by:
Hello all!!! For a year and a half now, we have been developing different Access 2000 applications. Most of them are access frontend and access backends. Some of them have SQL server 2000 as a...
0
by: Matt | last post by:
Hello, I am attempting to get a software prototype UI/demo built in Flash to talk with existing C++ (so I can exchange data and commands between the application-software already developed in the...
1
by: Jenny - | last post by:
when i start the postmaster i have multiple backends running even though i made sure to kill all the backends lingering from the previous run. is there a reason for this? while using gdb does it...
3
by: rdemyan via AccessMonster.com | last post by:
I just got Access 2003 and have been playing around with it. This whole macro security thing can be a bit annoying. Initially, I was able to link to my backends located on a second computer....
2
by: PurpleServerMonkey | last post by:
At the moment I'm writing a network aware application in C# .Net 2.0 and I'd like to ask the group for advice on how I should store the username and password for the connection. The application...
4
by: Michael | last post by:
Hi! (OK, slightly silly subject line :) I'm extremely pleased to say - Kamaelia 0.4.0 has been released! What's New & Changed? =====================
2
by: John | last post by:
Hi I have a single front end to which I would like to select one of two backbends at start-up. How can I accomplish this via code? Also is it possible to leave the "active" backend to last used...
5
by: eholz1 | last post by:
Hello , I have a web page that has a div element, with css applied to that element. Within the div is an ul with li tags, etc. the displayed font size in IE is larger than the the font size in...
3
by: zou | last post by:
there is a file which is very large, we can use stat to get a file size(<2G), struct stat buf; stat("file", &buf); long s=(long)stat.st_size; but stat::st_size is type of off_t(typedef...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.