"We have been very pleased with the competent, prompt and courteous service they have provided to us."

Stu Perlman
Monarch/USESI (New Jersey)

Microsoft Access Questions

Access Database Questions

Iowa Headquarters
(MIDWEST)
103 E. 6th St., Suite 101
P.O. Box 726
Ames, Iowa 50010
Tel: (515) 239-9900
Fax: (515) 239-9800
Skype™

Driving Directions to the Ames Iowa Headquarters
Florida Headquarters
(Southeast)
4200 Evans Ave., Suite 10
Fort Myers, Florida 33901
Tel: (239) 267-2749
Fax: (239) 267-9936
Caribbean & Latin America
(Puerto Rico)
Tel: (787) 303-0042
South Dakota - Sioux Falls
Tel: (605) 496-9580
Texas - Austin
Tel: (512) 593-1056
New Mexico - Albuquerque
Tel: (505) 289-1364
Iowa/Illinois - Quad Cities/Muscatine
Tel: (563) 316-2378
North Carolina - Asheville
Tel: (828) 278-2323
Want quick Answers?
During normal business hours you can reach us via our live chat program.  Try it, it's really cool!!
 
Click Here To Chat With Us Now Live!!
Disclaimer
Winning Solutions Inc. is an independent service provider for THIRD PARTY PRODUCTS where WSI provides support on remote, chat and over the phone basis for issues related to computer software. All other trademarks, registered trademarks, company names, product names and brand names for the third party trademarks are the property of their respective owners, and WSI disclaims any ownership , right , affiliation or endorsement of or by any such third party. The use of any third party trademarks, logos or brand names is for informational purposes only.

Microsoft Access

Questions and Answers

Here at Winning Solutions, Inc. we answer many questions each day for our clients about how to make Microsoft Access work for them. On this page, we are providing a free resource consisting of answers to some common questions people ask us about Microsoft Access. If you have a question that needs to be answered and if you do not see the answer listed here, you may contact us. WSI does charge a fee to answer some questions. If you do not have time to implement the answer we provide, WSI will gladly implement it for you, but we also charge for this service.

Question: Linking Parent record to Child Record

Can I create a Microsoft Access Database that contains information about a person or an item that is linked to another record, such as a record containing information about the person's child or a related item?

Answer:

Yes, you can create a Microsoft Access database record for a person or item with a related person, such as a child or a related item's record, linked to a parent's record using Microsoft Access.

Question: Information privacy in Microsoft Access

How do you keep information private in Microsoft Access?

Answer:

Maintaining the privacy of information stored in a Microsoft Access database is a challenge. One technique you may employ would be encryption of the data along with a user permissions system that would only decrypt records for authorized users. When handling confidential data in Microsoft Access, it is best to deploy a run-time version of the database to users. Since Microsoft Access itself is a powerful data management and reporting environment, a sophisticated Access user may be able to circumvent data security procedures when working with the data using the full version of Microsoft Access. (Note: WSI provides Microsoft Access support services for a fee that will set this up for you, if you do not have time to do it yourself.)

Question: Facilitating multiple users of a Microsoft Access Database.

I would like to have multiple users on different computers work with the same Microsoft Access database at the same time; do they have to be on the same computer network?

Answer:

Yes, the users will need to be on the same computer network. If the users are not on the same computer network, they can use software such as Microsoft Remote Desktop Protocol, which requires Pro versions of Windows XP or higher, to log into an in-network computer from a non-network computer via the Internet. Another option is to use remote access software such as VNC, GoToMyPC, Team Viewer, or LogMeIn to get connected to an in-network computer with the Access Database from a non-network computer, via the Internet. A more advanced option is to split your Access Database into a separate front end (forms, queries, reports) and a back end (tables that store data). Next, the Access back end needs to be converted to Microsoft SQL server. You may already have a license for Microsoft SQL server, but if you do not, Microsoft offers a free edition of Microsoft SQL server called Microsoft SQL Server Express, which can be used commercially. This version does have some limitations, but it is far more powerful than the Microsoft Access back end, so people moving from Access to a Microsoft SQL Express back end typically never notice the limitations. Then, place the back end on a server that is accessible from the Internet. Next, you will need to configure the front end of your database to connect via the Internet with back end hosted on the Internet accessible server. (Note: WSI provides server hosting and Microsoft Access support services for a fee that will set this up if you do not have time to do it yourself.)