Hendra-
If the tables will contain data not shared by users, then they should be local
tables in each user's copy of the "front end" database. You should not share
these on another server.
But to answer your question, yes, you can have some linked tables pointing to
one database (or server) and others pointing to a different database.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Nashua, NH)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
agesthahendra@ymail.com
Sent: Saturday, March 03, 2012 5:36 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Link tables from more than one source
Hi All...
Is it okay if our application have more than one source link tables..?
I have an application and i plan to use link tables from Mysql on the
server...due to several reason, i think it's better to placed several tables
that not really important and can be used personally by the users on their local
computer (let say secondary tables)....
so my plan is make another BE builded with access that contain the secondary
tables and placed it on each users computer, and then link its into my FE
together with link tables from Mysql...but there are no join between tables from
Mysql and tables from Access local BE.
Hope my words don't make you get confused...thank you.
Regards
Hendra
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar