What are Correct Steps to Build a Shared DB?

[jcmv007]

HI,

I want to develop a budget DB which will be used by different store manageres at different locations. They can all have access to company HQ server (one of them) in which I plan to put the DB.

From what I 've read this is a several step proyect for which I have a confusion for the first steps. Would this be the correct order to do it:

1. Create DB in development PC and at the end move to server.
2. Secure DB, create groups and users
3. Desgin tables, forms and reports
4. Test
5. Deploy

I would appreciate any help or pointers to books or threads. Where could I read about how the deployment should be done.

Thanks in advance.

 

[JeremyNYC]

jcmv,

You have a lot of work in front of you. You'll definitely want a book. The one I recommend is the Access [version number] Developer's Handbook. It's big and expensive. And it's a tremendous asset, and worth every penny you pay. It will earn it's cost in the first week you own it.

You'll also want to read about security, depolying databases, and table scheme design. I have articles about all of these on my website, in the Developers' section.

I hope this helps.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Affordable Development, Professionally Done

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[jcmv007]

Jeremy,

Thanks for your response, I did buy the book (a set actually) after you recomended it in a previous post I did.

I have also visited your site so I guess am going to have to delay my project until I finish reading.

Thanks,


James