Results 1 to 5 of 5

New to this forum and have questions

  1. #1
    Join Date
    Apr 2006
    Posts
    6

    New to this forum and have questions

    Hi everyone. I am new to this site and somewhat to Access. I want to make a database program for my growing company and thought I would try it out first before I pay someone else to do it. I worked with Access2 many moons ago and helped start a database for a company I worked for. But I know many things have changed since the Access2 days and want to ask a few questions first before I get started. Here goes:

    1) My first concern is about security. I noticed that when you open access, the switchboard is still readily available to view and open stuff in design view. This to me seems to leave the software very vulnerable to employee screw-ups or even malicious activity. Can you set up the database so that the operator never sees or has the opportunity to change the program itself? And can the data also be preserved or kept from errant deletions by my staff?



    2) Table scenario: I have a consulting business that works with clients that are in foreclosure. The information that I get is from the public records of the various states I work in. I am currently using Excel to manage my list, but I am seeing that it would be beneficial for me to go to access for many reasons but here is one of them. I use the lists I receive currently for a mail campaign. During the course of the foreclosure process, I send out different mailers with different messages to reflect the stage of the process the prospects are in. When a client calls in, I then complete a questionaire to gather additional information and then to determine a course of action. I want my reps to be able to retrieve the record from the list when the call comes in and then complete the questionaire via a FORM. My question is: should that information completed on the FORM go to the same table that the master list of prospects are or should it be a separately linked table? It seems to me that it should be the separate table but maybe someone can confirm. I should also point out that after a prospect becomes a client, I want to purge that record from the prospect list (SO THAT THEY DO NOT RECEIVE ANY GENERAL MAIL PIECES) and keep them in a new list. So please advise how this is best handled.

    Thanks for the help

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275

    Re: New to this forum and have questions

    Quote Originally Posted by Sinatra Fan
    Can you set up the database so that the operator never sees or has the opportunity to change the program itself?
    I think what you'll want to do is make the front-end an MDE rather than an MDB. In an MDE, the form/report designs and VBA code cannot be changed.

    Quote Originally Posted by Sinatra Fan
    And can the data also be preserved or kept from errant deletions by my staff?
    Depending on what you need to do exactly, there may be some mitigation strategies. The best strategy is probably also the simplest: back up early, back up often.

    Quote Originally Posted by Sinatra Fan
    My question is: should that information completed on the FORM go to the same table that the master list of prospects are or should it be a separately linked table? It seems to me that it should be the separate table but maybe someone can confirm. I should also point out that after a prospect becomes a client, I want to purge that record from the prospect list (SO THAT THEY DO NOT RECEIVE ANY GENERAL MAIL PIECES) and keep them in a new list. So please advise how this is best handled.
    Absolutely, different table(s). Not knowing all of what you plan to do I cannot tell you everything you need to do in the design, but you will definitely want to use additional, related tables.

  3. #3
    Join Date
    Apr 2006
    Posts
    6
    what is MDE vs MDB?

  4. #4
    wasim_sono is offline Advanced Beginner
    Windows XP Access 2013 64bit
    Join Date
    May 2005
    Location
    Pakistan
    Posts
    73
    you may use the security wizard which provide fully security to u. you may create a number of users who use ur application and also assign them the responsibilities whether they only open the form or edit the form or only enter the data or view the data.

    and pattrick has answered in detail. I offer my services voluntry basis to complete ur application if u wish. you may contact me at wasim_sono@hotmail.com.

    Regards.

    Wasim

  5. #5
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Quote Originally Posted by Sinatra Fan
    what is MDE vs MDB?
    MDE is an Access file format in which the forms, reports, and VBA code cannot be edited (nor can the source code be viewed).

Please reply to this thread with any new information or opinions.

Similar Threads

  1. 3 questions about forms
    By surfer_rosa in forum Forms
    Replies: 0
    Last Post: 10-08-2008, 09:59 AM
  2. newbie questions
    By bigmac in forum Access
    Replies: 0
    Last Post: 10-07-2008, 12:53 AM
  3. New to Access and have questions
    By MichelleFinn in forum Access
    Replies: 1
    Last Post: 04-04-2008, 06:30 PM
  4. New to forum...database question
    By denileigh in forum Access
    Replies: 2
    Last Post: 07-03-2006, 02:00 PM
  5. Replies: 2
    Last Post: 06-12-2006, 08:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums