Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Migrating to SQL Server

Status
Not open for further replies.

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
 
It's better to use unbound forms. Then have a submit or save button that will write the record to SQL Server using ADO. If your form is unbound, when you open it, there will be nothing in any of the fields. Jim Lunde
compugeeks@hotmail.com
Custom Application Development
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top