Solved

link table with ms access 2010 over the inernet

Posted on 2011-02-14
5
497 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
i ddnt get full solution but at least i had an advice to change to sql
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Configuring network clients can be a chore, especially if there are a large number of them or a lot of itinerant users.  DHCP dynamically manages this process, much to the relief of users and administrators alike!
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
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…

762 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now