Re: Linking tables via ADO?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.orgZERO_SPAM)
Date: 09/02/04 

Date: Thu, 2 Sep 2004 13:36:31 -0700

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/vba.html#UserLvlSecureADOCnxn

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
news:uXtLPN6jEHA.3884@TK2MSFTNGP10.phx.gbl...
> 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
>
>

Relevant Pages

  • Re: Problem with ADO in VB6
    ... If it's not making the database file correctly, ... ADOX, the ADO extension library, was added to ADO as an ... answer MS quickly clobbered together the ADOX library. ... from both libraries at the same time. ...
    (comp.lang.basic.visual.misc)
  • Re: ADOX - Import type library into Delphi 2007
    ... I want to modify an Access database at runtime and this takes ADOX (not only ADO but also ADOX so you can f.ex. ... I might add that I have been given the suggestion to rename the MDB file, create a new table, create a new table and them migrate the data from the old file to the new. ...
    (borland.public.delphi.database.ado)
  • Re: Linking tables via ADO?
    ... Properties for user-level security on an ADOX Table object, ... syntax that works just fine for an ADO Connection object, ... to connect to an Access database with ADO after it has been secured with ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: ADOX - Access table creation with nullable columns in C#
    ... ADO Description: Multiple-step OLE DB operation generated errors. ... ADO Source: Microsoft JET Database Engine ... The ADOX "Attributes Property" is a combination of ColumnAttributeEnum ...
    (microsoft.public.data.ado)
  • Re: Anybody from Access development team or from MS can help me?
    ... Here is a direct quote from Section 45 of the Security FAQ: ... Although ADOX is supposed ... This slapped onto my face> when I found there is no option to specify username and system database ...
    (microsoft.public.access.security)