Hi:
I have migrated MS Access table from .mdb to MSsql server, from my computer and my administrator's pc can run the new Access application without any problem, but another user just can't run this application (before the migration, she runs the .mdb without problem).
error: The Expression After update you entered as the event property setting produced the following error: ODBC-connection to "testSQLDB" failed.
I am worry about my connection string is not right:
The connection string before was: "Provider=Microsoft.Jet.OLEDB.4.0; data source=\\server\shared\Processing\dbase\Processing .mdb"
The connection string after tables moved to sql: "Provider=SQLOLEDB; Data Source=SERVER; Initial Catalog= VisionSQL;Integrated Security=SSPI;"
But if that is wrong, my pc and my administrator's pc can't run also (in fact, I am using the server pc, so I am the owner, administrator he has the role of administrator).
So, it must be a permission issue or missing something, (the previsou .mdb in "Share" location, and everybody can run that .mdb before, the newly installed sql database is in C drive by default).
What will be the most likely problem? Do I need to check if the user's MS Access "Data Source Name" has the database name, or create New Data Source?
Thanks in advance.
Jt
I have migrated MS Access table from .mdb to MSsql server, from my computer and my administrator's pc can run the new Access application without any problem, but another user just can't run this application (before the migration, she runs the .mdb without problem).
error: The Expression After update you entered as the event property setting produced the following error: ODBC-connection to "testSQLDB" failed.
I am worry about my connection string is not right:
The connection string before was: "Provider=Microsoft.Jet.OLEDB.4.0; data source=\\server\shared\Processing\dbase\Processing .mdb"
The connection string after tables moved to sql: "Provider=SQLOLEDB; Data Source=SERVER; Initial Catalog= VisionSQL;Integrated Security=SSPI;"
But if that is wrong, my pc and my administrator's pc can't run also (in fact, I am using the server pc, so I am the owner, administrator he has the role of administrator).
So, it must be a permission issue or missing something, (the previsou .mdb in "Share" location, and everybody can run that .mdb before, the newly installed sql database is in C drive by default).
What will be the most likely problem? Do I need to check if the user's MS Access "Data Source Name" has the database name, or create New Data Source?
Thanks in advance.
Jt