DSN-Less Connection Not Allowing New Records
DSN-Less Connection Not Allowing New Records
(OP)
I'm attempting to link an Access 2002 database to an MSSQL server and need to do so without setting up ODBC connections on all user's computers.
I used the code specified in the Microsoft Article (http://support.microsoft.com/kb/892490). It pulls in the tables just fine, but I cannot add a new record.
To do so, I have to refresh the links, with an ODBC connection, and specify a Unique Field for the tables. Is there a way to specify this in the code that connects the tables?
Thank you and any help is appreciated.
I used the code specified in the Microsoft Article (http://support.microsoft.com/kb/892490). It pulls in the tables just fine, but I cannot add a new record.
To do so, I have to refresh the links, with an ODBC connection, and specify a Unique Field for the tables. Is there a way to specify this in the code that connects the tables?
Thank you and any help is appreciated.
RE: DSN-Less Connection Not Allowing New Records
Duane
Hook'D on Access
MS Access MVP
RE: DSN-Less Connection Not Allowing New Records
If I may ask another question, would you remove the linked tables from the database when the user exits the database? If so, do you know what code would be used to do so?
RE: DSN-Less Connection Not Allowing New Records
Duane
Hook'D on Access
MS Access MVP
RE: DSN-Less Connection Not Allowing New Records
Thanks,
RE: DSN-Less Connection Not Allowing New Records
Duane
Hook'D on Access
MS Access MVP
RE: DSN-Less Connection Not Allowing New Records
If it was checked, then I uncheck the box (via the Citrix connection) it hangs and finally returns an ODBC call failed error. When I close the database it states that it can't save due to being locked.
Might there be data type issues (the MSSQL type is a bit) causing some conflict when changing from -1 (yes) to 0 (no)?
RE: DSN-Less Connection Not Allowing New Records
RE: DSN-Less Connection Not Allowing New Records
I try to avoid using Y/N fields in any of my applications. I typically use INT and set the default to either -1 or 0. When I query the field, I always use "= 0" for false or "<> 0" for true.
Duane
Hook'D on Access
MS Access MVP
RE: DSN-Less Connection Not Allowing New Records
RE: DSN-Less Connection Not Allowing New Records
CODE
Duane
Hook'D on Access
MS Access MVP