Re: QUESTION???

Rob,


Thank you so much



Robert Morley wrote:
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.

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: tool to re-reference forms after usizing?
    ... Speed Ferret (which I hate to admit that I've never been able to get to ... tblCustomerAddress, remember that changing tblCustomer to something else ... >>> I am in the process of upsizing an access database to sql server. ...
    (microsoft.public.access.conversion)
  • Re: ODBC parameters and system resources
    ... Install MSDE or use an existing SQL Server. ... I connect to an Access database of about 500MB in size. ... there is the "Not enough space on temporary disk". ... What can a "System resource" be apart from disk space and RAM? ...
    (comp.databases.ms-access)
  • Re: Migrating away from MS-Access
    ... Ive just stepped into a role to migrate an access database to VB.Net. ... At some stage we have to migrate the access backend to SQL Server. ... A dot-net front end with an MDB file back end is the worst of all worlds. ...
    (comp.databases.ms-access)
  • RE: ODBCDirect Workspace
    ... successfully ported my tables to SQL Server and have created an Access ... Are you using one Access database to work inside of another Access database? ... Dim strSql As String ... However if you are going to be using this query again to populate the combo ...
    (microsoft.public.access.modulesdaovba)
  • Re: How to retrieve ms access database full information version
    ... I want to retrieve the full version information from a access database ... ie, while SQL Server IS the database, MSAccess is a Office product. ... There is another more direct way using the Object Model, ... the MS Access OLE Automation Guide handy. ...
    (microsoft.public.vb.com)
Quantcast