Hi everyone,
Firstly, Could you suggest me some ideas whether it is possible to use Data Control navigation bar or some sort of Search through so that I can edit an SQL database. I know it is possible to use Data Control to navigate through an Access database but not sure how to make it work using SQL server data. I know how to make string connection something like the following:
Connection String: conn.Open "Provider=sqloledb; Network Library=DBMSSOCN; Data Source= IP address; Initial Catalog= try ; User ID= 1dbo; Password=admin"
Secondly, Also is there a better way to navigate quickly (some sort of Search?) to a particular record for you to edit,instead of using Data control as it take forever to navigate through a database with 1000 of records.
Thank you for your help in advance!
Miketm
Firstly, Could you suggest me some ideas whether it is possible to use Data Control navigation bar or some sort of Search through so that I can edit an SQL database. I know it is possible to use Data Control to navigate through an Access database but not sure how to make it work using SQL server data. I know how to make string connection something like the following:
Connection String: conn.Open "Provider=sqloledb; Network Library=DBMSSOCN; Data Source= IP address; Initial Catalog= try ; User ID= 1dbo; Password=admin"
Secondly, Also is there a better way to navigate quickly (some sort of Search?) to a particular record for you to edit,instead of using Data control as it take forever to navigate through a database with 1000 of records.
Thank you for your help in advance!
Miketm
