A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Linking tables via ADO?



 
 
Thread Tools Display Modes
  #1  
Old August 31st, 2004, 10:41 PM
Özden Irmak
external usenet poster
 
Posts: n/a
Default 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  
Old September 2nd, 2004, 09:36 PM
'69 Camaro
external usenet poster
 
Posts: n/a
Default

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  
Old September 2nd, 2004, 09:56 PM
Özden Irmak
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 02:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.