That posting stated that there was no way around this 'behavior' (Personally I'll call that an oversight/bug). Select Link to the data source by creating a linked table. To reset the password for the connection string, pass null to the Item property. If Password has not been set and you retrieve the value, the return value is Empty. Note: These steps may vary slightly depending on which version of Microsoft Access you are using. This property corresponds to the 'Password' and 'pwd' keys within the connection string. ![]() ![]() So shortly after posting this question I found another forum where someone had a detailed post stating that essentially once you establish on ODBC connection this way, Access will as I understand Cache that connection and only uses it, basically ignoring any new connection strings until Access is completely closed and restarted. Connecting Microsoft Access to Oracle Databases. ![]() Hi everyone, I'm trying to create ODBC connections to tables in a Pervasive SQL database on our server and for some reason even though I specify the Database in the connection string, Access is using a different database.įor example if I try to create a connection to a table called: INVENTORY which is only located in dbONE it fails, but if I try a different table (say CUSTOMERS) that's only in dbTWO it works, even though my connection string specifies dbONEĪnd once the table is connected it shows it's connected to dbTWO
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |