Solved

link table with ms access 2010 over the inernet

Posted on 2011-02-14
5
501 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Suggested Courses

630 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