XPertti
asked on
Problems whit MSysObjects Table
Hi,
i am trying to edit MsSysObjects table in order to allow autolinking of table from SQL-Server, how ever
i get following error message in a satusbar: "Control can't be edited it's bound to replication system
Column 'Connect'".
I have tried to set all the security premissions (tools/security) but that hasen't been any help
any ideas how to fix this?
XPertti
i am trying to edit MsSysObjects table in order to allow autolinking of table from SQL-Server, how ever
i get following error message in a satusbar: "Control can't be edited it's bound to replication system
Column 'Connect'".
I have tried to set all the security premissions (tools/security) but that hasen't been any help
any ideas how to fix this?
XPertti
Not only can't you, but even if you could, you really don't want to. Editing MSysObjects can mess up a database in a big way.
As njelger said, I'm sure there is another way to do what you want.
Jim.
As njelger said, I'm sure there is another way to do what you want.
Jim.
ASKER
Well hmm i have failed to create ODBC source which would allow automatic link to SQL server. It allways asks for username and password. Any solution for this would be much apperciated. SQL-Server uses mixed mode authentication.
XPertti
XPertti
show me what you have done.
ASKER
This is the .dsn file that is created and used to link i tried to add PWD line whit text editor, but when Access is restarted it fails to link to the sql server again.
[ODBC]
DRIVER=SQL Server
UID=login
PWD=password
Network=DBMSSOCN
WSID=server
APP=Microsoft Open Database Connectivity
SERVER=server
Description=Test1
[ODBC]
DRIVER=SQL Server
UID=login
PWD=password
Network=DBMSSOCN
WSID=server
APP=Microsoft Open Database Connectivity
SERVER=server
Description=Test1
<<It allways asks for username and password. Any solution for this would be much apperciated. SQL-Server uses mixed mode authentication.>>
To avoid the username/password prompt, you must specify it in the connection string of the tabledef. This article:
HOWTO: Use CDao for Connections to a Secure Attached Table
http://support.microsoft.com/default.aspx?scid=kb;en-us;186383
Give and example and outlines the steps for setting up the ODBC connection. It was written for C++, but it still applies.
Jim.
To avoid the username/password prompt, you must specify it in the connection string of the tabledef. This article:
HOWTO: Use CDao for Connections to a Secure Attached Table
http://support.microsoft.com/default.aspx?scid=kb;en-us;186383
Give and example and outlines the steps for setting up the ODBC connection. It was written for C++, but it still applies.
Jim.
ASKER
This is the .dsn file that is created and used to link i tried to add PWD line whit text editor, but when Access is restarted it fails to link to the sql server again.
[ODBC]
DRIVER=SQL Server
UID=login
PWD=password
Network=DBMSSOCN
WSID=server
APP=Microsoft Open Database Connectivity
SERVER=server
Description=Test1
[ODBC]
DRIVER=SQL Server
UID=login
PWD=password
Network=DBMSSOCN
WSID=server
APP=Microsoft Open Database Connectivity
SERVER=server
Description=Test1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Where is the source? :)
Source of what?
Jim.
Jim.
/ j