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