• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

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.
0
Knowledgeable
Asked:
Knowledgeable
  • 2
  • 2
  • 2
  • +2
6 Solutions
 
Nick67Commented:
<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
 
radcaesarCommented:
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
 
KnowledgeableAuthor 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Nick67Commented:
I  posed many questions to you @knowledgeable
Your question lacks the specifics needed to provide answers.
0
 
Alpesh PatelAssistant ConsultantCommented:
Import this Access file in SQL Server.
0
 
peter57rCommented:
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
 
KnowledgeableAuthor Commented:
PatelAlpesh,

Please give me the exact steps for importing the Access file in SQL server.
0
 
peter57rCommented:
Tools>DatabaseUtilities>UpsizingWizard
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now