Link to home
Start Free TrialLog in
Avatar of raed_malhy
raed_malhyFlag for Jordan

asked on

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 ??
 
Avatar of pwindell
pwindell
Flag of United States of America image

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.

Avatar of raed_malhy

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of pwindell
pwindell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
i ddnt get full solution but at least i had an advice to change to sql