Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 505
  • Last Modified:

link table with ms access 2010 over the inernet

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
raed_malhy
Asked:
raed_malhy
  • 3
  • 2
1 Solution
 
pwindellCommented:
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
 
raed_malhyAuthor Commented:
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
 
pwindellCommented:
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
 
raed_malhyAuthor Commented:
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
 
raed_malhyAuthor Commented:
i ddnt get full solution but at least i had an advice to change to sql
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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