Linking to tables in a secured database from an unsecured database

G

Guest

I'm trying to refresh the links to a secured database from an unsecured
database - the connect seems ok but the refreshlinks fails with a '3219
Invalid operation' message. The code to refresh is:
tdf.Connect = ";DATABASE=" & StrPath & ";UID=eTimeIndo;PWD=XcnsDio79p"
tdf.SourceTableName = StrTable
On Error Resume Next
DoCmd.DeleteObject acTable, StrTable
db.TableDefs.Append tdf
On Error GoTo LinkErr
tdf.RefreshLink

What am I doing wrong?
 
P

Paul Overway

First, you need to create a new Workspace object that uses the proper
workgroup file. You also need to read up on the Connect property for
tabledefs, because what you're using isn't a proper value...it should just
be ";DATABASE=" & strPath. After you've logged in to a secure Workspace,
then you should be able to set the Connect property and RefreshLink....the
other stuff you're doing is pointless.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top