We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

How can I transfer an Access 2003 database file so that it can be shared and accessed using SQL?

Medium Priority
348 Views
Last Modified: 2012-05-11
How can I transfer an Access 2003 database file so that it can be shared and accessed using SQL?

The server that has this file on its file share is Windows Server 2003 for Small Business Server.
The client computers that will be accessing this file are mostly Windows XP as well as two Windows 7 64 bit OS computers.

I am very interested in hosting this file using SQL so that several users will still be able to access and modify it using Microsoft Access 2003 (Office 2003).

What steps do I need to take to do this?

PLEASE NOTE: This question is NOT a duplicate of the previous two questions I have just asked. The other two questions deal with two other customer sites, and this particular question has to do with a completely different (third) customer site. I need all three of these questions to be answered since I need to provide resolutions to the issues that all three of these different customers are having.
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2014
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
IT GuyNetwork Engineer

Author

Commented:
Sorry, all that I met by "a remote network share" was that this file is being shared on a network server, not directly from a client computer.

There is no VPN or other remote access connection involved here.
CERTIFIED EXPERT
Most Valuable Expert 2014
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
IT GuyNetwork Engineer

Author

Commented:
PatelAlpesh,

Please give me the exact steps for importing the Access file in SQL server.
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.