General Deployment of a .MDB File on a network

[PaulHilgeman]

I have spent hours and hours creating an access file for the managing
of thousands of customers and jobs. I have spent tons of time
migrating about 25000 customers from an older system into this system.

Now I have one very large .mdb file and I want to distribute it to a
group of about 15 users over a network and have them all access and
manipulate the data. There is one main form where the users get access
to the data, plus has several buttons in order to print reports, view
reports based on queries etc. There are several macros that run when a
button is pressed, used to fill in CurentUser() into a TextBox.

So I go into the office (this was all developed on my home PC) and dump
the file on the network and follow a very good guide that I found about
setting up users etc. On the computer that I set it up on, everything
seemed to work OK. Then I opened the .mdb file up from another
computer and got the error that the database could not be accessed
because the computer that I had first opened it on was using it in
"exclusive" mode and that I could not access the database.

However, on both computers (the two that I was testing on) I had set
the option to by default open in shared mode.

The first computer I had logged in on I was logged in as an admin, and
the other computer was a "full data access user".

So, what is the correct way of doing what I want to do?

Thank you!!!!!

-Paul Hilgeman

 

[Albert D.Kallal]

I explain here how to deploy in a multi-user environment. do this:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

And, you might as well read up on some more cautions about your network and
how mdb files can be damaged by your network..

I explain here about the kinds of networks you have to avoided, and why
corruption occurs in mdb files

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

If you read the above two articles..then you will all the knowledge you need
on this subject...

 

[PaulHilgeman]

Great guides. I am suprised that I didnt find them with all of my
google searching.

The only question that remains is how to implement the user level
security with this system.

Do I establish all security on my single database file before spliiting
it? Or should I split first, then run all of the security wizards etc
to set up my users?

Thanks a ton!!!

 

[Albert D.Kallal]

Do I establish all security on my single database file before spliiting

it? Or should I split first, then run all of the security wizards etc
to set up my users?

You can do this either way. Remember, the security wizard does nothing that
you can't do yourself (you can setup security manually if you know how...).

The workgroup file is thus shared with the back end file on the server....

My split article at the end mentions how the shortcut needs to be setup when
using security when you split...

 

[PaulHilgeman]

Outstanding, I totaly missed it when I saw the "home" link I stopped.

-Paul