How do I make a local table in an ADP?  I am using Access 2000 and SQL 7

I need to store local setting, user preferences etc.

Thanks.

Unfortunately you can't. ADP's aren't capable of local storage because the 
Jet engine isn't there anymore. All data has to be fetched from SQL Server 
at run-time. You can link SQL Server tables to an Access .mdb using ODBC, 
but there really isn't much pont, since you don't get the performance gains.


>From: "Michael Mitchell" <michael@m...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] make a local table in an ADP, SQL
>Date: Fri, 31 Jan 2003 21:18:44
>
>How do I make a local table in an ADP?  I am using Access 2000 and SQL 7
>
>I need to store local setting, user preferences etc.
>
>Thanks.


_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail