Splitting Database (MVP Help)

R

rayrock

I have built a warehouse database and I have several PC's on our network
running Windows XP Professional however not all have the Access progam (Do
They Need)?

I have split the database and all I get is a backend? How for Example would
I set up the part for the other users that I dont want to have access to the
main part of data such as tables? All I want is for them to have access to
the forms & reports and be able run the queries. I have read some discussion
group questions concerning this topic (yes I did read before asking for help)
But I can not find a clear cut approach.

For Instance Where Would I put Back End on my machine?\
Is there files to be included with the users FrontEnd (especially for those
with out access)
Is There Resources for this type of access activity?

Thanks in advance

Ray

For
 
A

Albert D.Kallal

however not all have the Access progam (Do
They Need)?
Click to expand...

If your users are going to run a ms-access application, then they need
ms-access on their pc. You can purchase a developers edition of ms-access,
and that allows you to "deploy" a ms-access "royalty free" version along
WITH your application. (it is takes some experience to use this tool). So,
at the end of the day, if you want to use pdf files on your computer, then
you install pdf software. If you want to use word, then you need to install
word on each pc. The same goes for ms-access (however, what is different is
that you can purchase and deploy a developer edition of ms-access - so, this
install is still a LARGE ms-access install, but the end users don't have to
know this, or pay for the copy of this "runtime only" ms-access version).
I have split the database and all I get is a backend? How for Example
would
I set up the part for the other users that I dont want to have access to
the
main part of data such as tables? All I want is for them to have access
to
the forms & reports and be able run the queries.
Click to expand...

The general approach to hiding all of the ms-access stuff is to use the
tools->startup options. You also should deploy a "mde" to the users, as then
they will not be able to modify the forms, reports, or even look at code.

If you want to see a sample application that has everything hidden, then
take a quick look at the 3rd program in the following link:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm
(grad the 3d one "access interface hidden").

Try running the above sample, and note how you don't see any of ms-access.
You can take a look at the tools->startup settings used to keep users "out"
of the ms-access stuff, and not see the tables etc.
For Instance Where Would I put Back End on my machine?\
Click to expand...

You put this on your "server" machine. Or, at least the most stable, and
reliable machine in your office, and then share that directory to all users.
I mean, you don't want to put the files on a machine that will freeze up, or
needs to be re-booted, as then ALL USERS in the file can experience data
loss. So, you don't necessary need a "server", but you sure don't want the
machine stopping during the day!

Is there files to be included with the users FrontEnd (especially for
those
with out access)
Click to expand...

They need a version of ms-access on their computer.

As mentioned, if they are going to run ms-access, then they need ms-access
installed (full retail version, or a runtime version - both are about the
same size and complexity for installing).

Is There Resources for this type of access activity?
Click to expand...

Hum, not a lot needs to be learned, but you do have to start "thinking"
about how all the other applications are installed, and used on your
computer. So, really, you need good knowledge of how to develop software,
and how to deploy it, but that applies to all software, and not just
ms-access. If you spent any time developing with ms-access, then you will
QUICKLY learn that splitting the database is necessarily for developers
survival!

You can read about splitting here, and more importantly WHY you split. (if
you don't split, then you get NO reliability).
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
 
R

rayrock

Thank you for the help. I will rate this article well.

I just thought since you can download viewers for word and powerpoint and
excell that the same would work for Access. I have a disk from a competitor
that is written entirly in access. Its pretty nice and installs access
runtime files can I use those?

I never seen the developers edition of access or have any Idea how much it
costs?

I create apps in visual basic so the need was really never there.

Eventually I would want my database to be view on the web and accessed using
passwords? What would I need for web intergration?

Thanks

Rayrock
 
Top