Guest_imported
New member
- Jan 1, 1970
- 0
All,
I am in the process of migrating my database from Access to SQL Server 7.0. I have a form that I use for data entry only. That is, when the user opens the form I don't want it to retrieve data, just be ready for user input. This worked perfectly against Access. Now that I am using a linked ODBC table to SQL Server the form always queries the entire SQL Server table. In the properties of the form I have "Date Entry = YES". How do I stop the form from retrieving the rows from the ODBC table?
Your help is greatly appreciated.
Thanks in advance,
David
I am in the process of migrating my database from Access to SQL Server 7.0. I have a form that I use for data entry only. That is, when the user opens the form I don't want it to retrieve data, just be ready for user input. This worked perfectly against Access. Now that I am using a linked ODBC table to SQL Server the form always queries the entire SQL Server table. In the properties of the form I have "Date Entry = YES". How do I stop the form from retrieving the rows from the ODBC table?
Your help is greatly appreciated.
Thanks in advance,
David