If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking tables via ADO?
Hi,
I'm linking tables from other access databases to my master access database in run-time via ADO code. I can do it for databases which has no password or workgroup file attached for them like this : MyTable.Properties("Jet OLEDB:Link Datasource") = MySourcePath MyTable.Properties("Jet OLEDB:Remote Table Name") = TableName MyTable.Properties("Jet OLEDB:Create Link") = True Does anybody has the proper code samples to link tables from databases which has password or has a workgroup file attached to it? Thanks in advance... Özden |
#2
|
|||
|
|||
Hi, Özden.
You don't mention the object type for your "MyTable" variable, but I suspect that it's an ADOX Table object. I've never tried using the Jet OLEDB Properties for user-level security on an ADOX Table object, so I'm not sure that they are even valid Properties for this object. However, for the syntax that works just fine for an ADO Connection object, see the tip "How to connect to an Access database with ADO after it has been secured with user-level security" on this Web page: http://www.Access.QBuilt.com/html/vb...lSecureADOCnxn If the syntax doesn't work for your ADOX Table object, then you may want to use the DAO library for a TableDef object, instead of the ADOX library. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips. (Any human can read my reply E-mail address and should alter it so that a message will be forwarded to me. Spammers are free to use my UNALTERED reply E-mail address. I will *never* get those messages!) "Özden Irmak" ozdenirmakatisnetdotnetdottr wrote in message ... Hi, I'm linking tables from other access databases to my master access database in run-time via ADO code. I can do it for databases which has no password or workgroup file attached for them like this : MyTable.Properties("Jet OLEDB:Link Datasource") = MySourcePath MyTable.Properties("Jet OLEDB:Remote Table Name") = TableName MyTable.Properties("Jet OLEDB:Create Link") = True Does anybody has the proper code samples to link tables from databases which has password or has a workgroup file attached to it? Thanks in advance... Özden |
#3
|
|||
|
|||
Hi Gunny,
I can open the secured database via a normal connection but linked tables do not work. I tried also linking from inside Access bu it didn't work unless I join to the same workgroup, then it worked... As I have to do it via code have 2 questions now : 1) How can I create a database via ADOX which has a workgroup file attached? 2) Do you have DAO sample code for tabledef object with linking to secured databases? Thanks in advance... Özden "'69 Camaro" AM wrote in message ... Hi, Özden. You don't mention the object type for your "MyTable" variable, but I suspect that it's an ADOX Table object. I've never tried using the Jet OLEDB Properties for user-level security on an ADOX Table object, so I'm not sure that they are even valid Properties for this object. However, for the syntax that works just fine for an ADO Connection object, see the tip "How to connect to an Access database with ADO after it has been secured with user-level security" on this Web page: http://www.Access.QBuilt.com/html/vb...lSecureADOCnxn If the syntax doesn't work for your ADOX Table object, then you may want to use the DAO library for a TableDef object, instead of the ADOX library. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips. (Any human can read my reply E-mail address and should alter it so that a message will be forwarded to me. Spammers are free to use my UNALTERED reply E-mail address. I will *never* get those messages!) "Özden Irmak" ozdenirmakatisnetdotnetdottr wrote in message ... Hi, I'm linking tables from other access databases to my master access database in run-time via ADO code. I can do it for databases which has no password or workgroup file attached for them like this : MyTable.Properties("Jet OLEDB:Link Datasource") = MySourcePath MyTable.Properties("Jet OLEDB:Remote Table Name") = TableName MyTable.Properties("Jet OLEDB:Create Link") = True Does anybody has the proper code samples to link tables from databases which has password or has a workgroup file attached to it? Thanks in advance... Özden |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking multiple tables together | Karl Albrecht | Database Design | 1 | September 1st, 2004 12:00 PM |
Linking to tables, Can't see all tables for selection | K Connor | General Discussions | 0 | August 31st, 2004 06:57 PM |
Linking Access 97 tables to Access 2002 tables | michaelwoodard | Database Design | 2 | August 13th, 2004 02:43 AM |
Linking Tables | Dar | General Discussion | 2 | June 7th, 2004 02:11 PM |