RE: RefreshLink error - 3078
- From: James R. <James_DBA@xxxxxxxxxxxxxxxx>
- Date: Tue, 11 Mar 2008 10:28:03 -0700
Here is the coding that I'm using to call the RefreshLink method.
Declerations were left out; but I know this code works because if I point the
backend of a MDB file I don't get the error....
I only get the error when attempting to connect to an SQL Server DB table!?
Is it possible that the coding needs to be modified somewhat because I'm
trying to connect to SQL?
'********START CODE*********
If MsgBox("Is " & DBPath & " the correct file and location?", vbYesNo,
"Database PATH") = vbYes Then
newPath = ";DATABASE=" & DBPath
Else
GoTo Find_path:
End If
intNumTables = MyDB.TableDefs.Count
varReturn = SysCmd(acSysCmdInitMeter, "Attaching Tables", intNumTables)
For i = 0 To MyDB.TableDefs.Count - 1
Set MyTableDef = MyDB.TableDefs(i)
If MyTableDef.Connect <> "" Then
MyTableDef.Connect = newPath
'!!!This causes error when connect has a value!!!
'Error # 3078 (for Access 2000) # 3011 (for Access 97)
'error states can't find table
MyTableDef.RefreshLink
End If
varReturn = SysCmd(acSysCmdUpdateMeter, i + 1)
Next i
'*******END CODE*******
I appreciate any help you can give me!!
Thanks,
James R.
--
Knowledge is the first step towards success. Little knowledge creates big
ideas.
"James R." wrote:
Hi,.
I'm in the process of converting an Access 97 backend to SQL Server 2005;
I've tried the SSMA for Access with no avail. So, now I've gone through the
painstaking of hand converting the table structure, constraints, keys, etc;
and even got the data over into SQL using a complex SSIS package.
Now, I'm ready to link the backend data. For now, I'm trying the simplest
approach just to get a working copy..so I'll be using a DSN. I've read about
DSN-less and will try it out in future testing sessions.
I've created the DSN and started the linking process and get an error stating:
"Error: 3011 - The Microsoft Jet database engine could not find the
object 'MyTableName'. Make sure the object exists and that you spell its name
and the path name correctly....See Chapter 10 - Troubleshooting, Item 4 for
assistance."
For arguments sake I also upgraded the project to Access 2000 and got
essentially the same error message; just with error # 3078 instead.
I've checked the DSN connection and got successful connection test. I've
double checked the table names in Access file (originally named
dbo_MyTableName...but, I renamed to MyTableName).
I've read countless articles and newsgroups, browsed forums and MS support,
all of which have not once addressed this.
I'm not sure if there is something I am just not seeing or what? I've been
working on this for about a week now (the whole project for about 5 months).
Anyone have any ideas? I'd appreciate any help that you can give me or point
me to! Please help!
Thanks,
James R.
--
Knowledge is the first step towards success. Little knowledge creates big
ideas.
- Follow-Ups:
- RE: RefreshLink error - 3078
- From: "Peter Yang[MSFT]"
- RE: RefreshLink error - 3078
- References:
- RefreshLink error - 3078
- From: James R.
- RefreshLink error - 3078
- Prev by Date: RefreshLink error - 3078
- Next by Date: RE: RefreshLink error - 3078
- Previous by thread: RefreshLink error - 3078
- Next by thread: RE: RefreshLink error - 3078
- Index(es):
Relevant Pages
|
Loading
