No, the only think stored in Access is the link itself. The data is still
stored on SQL Server, so that will be large, but the Access database will
stay small.
Rob
> if i will do the linking of MS Access as frontend and SQL Server as my
> backend, Is my size of my MS Access program be affected considering i have a
> thousand or even a millions of data stored on SQL Server , i am quite
> confused since the two connected to each other. Please help.
mroks - 29 Jan 2008 05:48 GMT
Rob,
Thank you so much
>No, the only think stored in Access is the link itself. The data is still
>stored on SQL Server, so that will be large, but the Access database will
[quoted text clipped - 6 lines]
>> thousand or even a millions of data stored on SQL Server , i am quite
>> confused since the two connected to each other. Please help.