"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
103 E. 6th St., Suite 101
P.O. Box 726
Ames, Iowa 50010
Tel: (515) 239-9900
Fax: (515) 239-9800

Driving Directions to the Ames Iowa Headquarters
Florida Headquarters
4200 Evans Ave., Suite 10
Fort Myers, Florida 33901
Tel: (239) 267-2749
Fax: (239) 267-9936
Minnesota Headquarters
(Upper Midwest)
119 Washington Avenue N, 2nd Floor
Minneapolis, MN 55401
Tel: (612) 286-0675
Los Angeles, California
Tel: (310) 295-9562
Springfield, Missouri
Tel: (573) 213-2173
Caribbean & Latin America
(Puerto Rico)
Tel: (787) 708-6025
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!!
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?


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?


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?


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.)

Question: How to Sync Microsoft Access Disconnected Users Periodically with an Organization’s SQL Azure and MS-SQL Databases.

Is it possible for my users to work disconnected and sync there data at a later time?


If your sales persons, technicians or other personnel working in areas where they have no network or Internet connection but still need to interact with your organization’s Microsoft database we can make that work.

Access can be very powerful in this situation. Many web applications are unusable when there is no network or Internet connection. Access databases can keep right on working using the latest data from the last time the user’s mobile Windows device was synchronized with an Azure SQL database. Then when that user gets back into an area where they have cellular data or network connectivity the information they updated in the copy of your organization’s database running on their mobile Windows device is synchronized with the organization’s database.

For users in the organization’s office they may get better performance interacting with an on-premise Microsoft SQL Server database versus the cloud hosted SQL Azure. In this event we can sync the data between the SQL Azure database and the on-premise database giving maximum mobility and great in office performance going from screen to screen, running reports etc.

To get help implementing this solution in your organization today, click on the Contact Us button at the top of this web page to reach out to us.