Pls Need Urgent HELP : Finished Work!

[Nizar]

Hello everyone,

I've competed my Access Application...Finally! I spent 3 months developing it!
Now I've finished it! I want to put it in work.
I need someone to guide me step by step (Sorry I'm really get tired from searching ) how can I do to make my application working in a small network (5 computers) ???
I want that only 1 user (master) get the entire data; for exemple all the Orders placed from other users...
I searched for Split but I did't figure out how to create backend frontend?? and how to make difference between Front End Master and BackEnd?

Please Any guideness will be Highly appreciated!!

Best Regards,

 

[statsman]

You will have to use Access security.

DO NOT VENTURE INTO THE TWILIGHT ZONE THAT IS ACCESS SECURITY WITHOUT A GUIDE.

I would recommend:

http://www.geocities.com/jacksonmacd
download the first file – Security Paper by Jack Macdonald. It’s a little long but it tells you everything you need to know.

 

[jrmask]

basically splitting is just placing all tables in a "backend" database and linking them to the "frontend" database. There is a wizard to split the database for you. You should always make a copy of your database and work with the copy to split the database. That way if anything does go wrong you still have you database in tacted. The tables/backend will need to reside on a shared drive or network so that each distributed frontend can connect and share the data. I would Google your other question though becuase there are several ways to have master-user frontends. I usually create two different frontends with the user database a clone of the master however with access to certain things deleted. The other way is to use the login name and limit by the user type as to what is presented to that user.

 

[Mike375]

As the others have said, make a copy of you data base. Actually. if your data base is complex you should make several copies and try and have copies at a couple of physical locations.

To network them put a copy of yor data base on one of the other computers. Then delete the tables. Do to Get External Data and select Link. Now find the "home data base" on the other computer. Then go ahead and tables will fly across like rockets. That is because you are not actually importing the tables, just forming a link.

You will see a little right pointing arrow next to each linked table.

Edited to include: One you have linked the data base you only need to copy the linked data base to the other computers

Depending on your tables and your wants/need you might decide to link only some tables. Tables that you might not link could be large tables with what amounts to static data. For example I have several tables that have insurance premium rates etc. The less linking the less loss of speed. This can be an issue, if like me. you computers are networked with wireless.

With security, you might find that you can achieve all you want by how queries and froms are made in the satellite data bases.

You might find that you are better to have different forms on some of the computers. For example, part of my business is a telemarketing and surveys. I get the best results by having a form that best suits the user of the computer.

 

[boblarson]

Check out this for some good info on creating and using a split database:

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

 

[Nizar]

Good day statsman, jrmask, Mike375, boblarson,

Thank you very much for your precious help. Its my first Access application and I learned so much! I found the support and help from this Forum, so from my heart, I thank everyone how answers my questions.
Now Im focusing on learning the security measures for an access project, and learning more about designing and developping database applications using other tools (sql, oracle, ...).

I wanna post my application here but it sizes 2,4 Mb so I'm trying to put it somewhere on net where it can be available for everyone who wants to download it. I will put the link on a post later.

Best regards,
Nizar