B
Becks
Hi Guys,
I'm having problems seeing changes I've made to the database.
For example:
Column added to table through the ADP.
Run view which uses * to show all columns.
View does not show new Column.
Now the other developers who are working on another database on the Server
are not having this problem.
I am wondering that since I'm setting up the connection each time after a
login form that the connection string I am using is causing this problem :
This is :
Application.CurrentProject.OpenConnection _
"Provider=SQLOLEDB.1;" _
+ "Persist Security Info=false;" _
+ "Initial Catalog=" & strDatabase & ";" _
+ "Data Source=" & strServer & ";" _
+ "UID=" & strUser & ";" _
+ "PWD=" & strPassword & ";"
(Thanks to Alexey for helping me with this)
Has anyone had this problem before or any answers?
Thanks in advance,
Becks
I'm having problems seeing changes I've made to the database.
For example:
Column added to table through the ADP.
Run view which uses * to show all columns.
View does not show new Column.
Now the other developers who are working on another database on the Server
are not having this problem.
I am wondering that since I'm setting up the connection each time after a
login form that the connection string I am using is causing this problem :
This is :
Application.CurrentProject.OpenConnection _
"Provider=SQLOLEDB.1;" _
+ "Persist Security Info=false;" _
+ "Initial Catalog=" & strDatabase & ";" _
+ "Data Source=" & strServer & ";" _
+ "UID=" & strUser & ";" _
+ "PWD=" & strPassword & ";"
(Thanks to Alexey for helping me with this)
Has anyone had this problem before or any answers?
Thanks in advance,
Becks