|
|
|
database configuration |
|---|
| message from cheryl on 13 May 2004 |
I am a newbie with databases. We have built a database
that only has the forms and tables done. What is the next
step. Do we need someone to develop architecture (how
many users, how the information is going to get to the
server?....) before this is rolled out to sites? What
would be the level or title of the professional needed to
do this?
|
| Byron replied to cheryl on 13 May 2004 |
Cheryl,
It sounds as if you have done much of the work. Do you
have all of your forms working so that the general user
will have no problems navigating through the data entry
processes?
I assume from your posting that you are going to be using
this database on a network. If so, there are many things
that would need to be considered. Numbers of users is not
as high a priority as the type of network and where users
are located in relation to each other, ie: lan or wan.
One thing of serious importance is: If you are going to
be in a multi-user environment, then you need to split
the database into a front-end (an mdb file or an mde
file) that will contain all of your forms, queries,
modules and reports and a back-end file (an mdb file)
that contains only the tables you are using for your
application. You did not say which version of Access you
are currently using, but you can use the "Database
Splitter" wizard to accomplish this. This modification
will provide a much more efficient and user friendly
enviroment for your users. I will cause fewer record
locks and other user interface issues.
When the database has been split, you can then put the
back-end file in a folder in a shared network location.
You will then need to change the link path in your front-
end file to link to the tables in the mdb file in the
shared network location.
You would then place a copy of the front-end file on each
users hard drive, create a shortcut for them to use on
their desktop. Each user would then be able to use the
application.
There are always other issues, but this is a start.
If you are looking for a consultant and are interested,
you can contact me directly via e-mail by taking out the
undersocres and everything between them in this email
address : mrbpolk@_TakeThisOutNoSpam_cox-internet.com
HTH
Byron
next
to
|
| Lynn Trapp replied to cheryl on 13 May 2004 |
Cheryl,
The answer to your questions depends entirely on the business requirements
for the database. In fact, there should have been a business requirements
document created before you ever started creating tables or forms. If you
haven't done that, or haven't had one given to you by the people needing the
database, then it's time to go back to square one.
|
| Cheryl replied to Lynn Trapp on 13 May 2004 |
A business requirement doc was not done. Where can I get
a sample?
business requirements
business requirements
or forms. If you
people needing the
next
|
| =?Utf-8?B?U0NITllERVM=?= replied to Cheryl on 13 May 2004 |
Also security is an issue as well, start gathering user names and passwords for each user and run the user level security wizard to start setting up basic permissions. Once you put the database out there, I gurantee there are going to be changes made and additions made, "can we do this, let's do this" etc. Trust me, I was there from the beginning, and am there now nearly 2 years later adding on to access and expanding possiblities in a multi-user, networked environment, with no corporate technology support. Feel free to contact me as well if need be.
|
| Lynn Trapp replied to Cheryl on 14 May 2004 |
Cheryl,
There's no standard way to do a business requirements document. Basically,
it just needs to include what you are trying to do with the database. What
kind of data you need to store. What kind of reports you will need to
generate from that data. To put it simply, a database should exist to solve
some kind of business problem. If you can describe what the problem is that
you are trying to solve, then you will have a good start on a business
requirements document.
|
| Kevin3NF replied to cheryl on 13 May 2004 |
It very much sounds like you need someone to visit with you about your
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"cheryl" <anonymous@discussions.microsoft.com> wrote in message
news:caba01c4390f$483ce6e0$a101280a@phx.gbl...
|
|
