Solved

link table with ms access 2010 over the inernet

Posted on 2011-02-14
5
499 Views
Last Modified: 2012-06-21
i have two ms access 2010 databases , one holding the tables and the other is holding the
 code , forms and reports, i linked them using link table and on startup of the code database,
 i refresh the link and make sure all tables are
available.. all is working great and solution is deployed on a LAN , now i want to install the
code database in another location and still be able
to link the database through the internet, i used a VPN after i mapped a network drive that contain the database with tables,
i could connect, but it is un stable and keep disconnecting.. is there another way ??
 
0
Comment
Question by:raed_malhy
  • 3
  • 2
5 Comments
 
LVL 29

Expert Comment

by:pwindell
ID: 34916463
Access is not designed to work like that.  Being unstable and disconnecting is exactly what I would expect from it in that situation.  I am almost shocked it even works at all.

If you want a network functional database use one of the free "express" versions of SQL Server.  You can probably keep the Access "front end" and use the SQL Server tables as the backend.

0
 

Author Comment

by:raed_malhy
ID: 34916541
thanks for the reply , if i linked the tables from sql express using ODBC , do i get client server performance ? i am using sub forms and need the linked tables in my database.
0
 
LVL 29

Accepted Solution

by:
pwindell earned 500 total points
ID: 34916607
I don't know that you need ODBC,...using DSNs are considered "bad",...those things are throwbacks to the mid 1990's.   You want a "DSN-less" connection.  
Anyway SQL Server is a "server",...it is designed specifically to be used across a network,...unlike Access which is specifically design not to be over a network.

That is probably the most I can tell you. Any other questions need to be targeted at an SQL Server specialist,...not "networking guys".  Look like your question was spread across too many forums on different themes.
0
 

Author Comment

by:raed_malhy
ID: 34916765
i know u r right , but i was trying to get some ideas to solve this issue ... any way i will give u the points cause i will link with sql server tables,  thank u
0
 

Author Closing Comment

by:raed_malhy
ID: 34916780
i ddnt get full solution but at least i had an advice to change to sql
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question