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

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.
IT GuyNetwork EngineerAsked:
Who is Participating?
 
Nick67Connect With a Mentor Commented:
<so that it can be shared and accessed using SQL>

What exactly do you mean?
Is this file split into front-ends and back-ends (data in one file, objects like forms and reports in another)?
Do you mean on SQL Server/ SQL Server Express Edition?
What operational reason do have for wanting to do this?

Will each user be modifying the objects?
Or will each user be entering data?
0
 
radcaesarConnect With a Mentor Commented:
The customers do have access to your intranet (Through VPN or by some others).

If Yes, You can share this just like a folder share in OS (The access file inside a folder).

If No, Its an security issue and Its not recommendable at any cost. I mean, If you are trying to do this as a public share.

Meanwhile, your customers should have office 2003 or higher installed in their machines.
0
 
IT GuyNetwork EngineerAuthor 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.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Nick67Connect With a Mentor Commented:
I  posed many questions to you @knowledgeable
Your question lacks the specifics needed to provide answers.
0
 
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
Import this Access file in SQL Server.
0
 
peter57rConnect With a Mentor Commented:
MS_Access is a multi-user database tool already.

There is no requirement to to put the data into SQL Server to allow multi-user access.  It can be done by splitting the database into front-end and backend and giving each user a copy of the front-end.  The database splittter tool in Access is there to do the split.

If you import the data into sql server tables then the chances of your application continuing to work without some re-design are pretty slim, if it wasn't designed to use SQL server in the first place.


0
 
IT GuyNetwork EngineerAuthor Commented:
PatelAlpesh,

Please give me the exact steps for importing the Access file in SQL server.
0
 
peter57rConnect With a Mentor Commented:
Tools>DatabaseUtilities>UpsizingWizard
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.