I just got Access 2003 and have been playing around with it. This whole
macro security thing can be a bit annoying.
Initially, I was able to link to my backends located on a second computer.
Then after I compacted the backends on the other computer and I think I also
tired of the macro security message on Access 2003 and selected to not run
unsafe expressions.
Now I cannot link to the backends on the second computer from the computer
running A2003. I have RWOP queries with all permissions on the backend
tables revoked.
Here's some of the code that I have that does the linking:
'Open the backend db and set the current db
Set wsOPEN = DBEngine.Workspaces(0)
Set dbOPEN = wsOPEN.OpenDatabase(strX)
Set db = CurrentDb()
'Now link the tables
For k = dbOPEN.TableDefs.Count - 1 To 0 Step -1
where strX is the location of the backend file.
At the last line shown, for some reason I'm now seeing
dbOPEN.TableDefs.Count = <Object variable or With block variable not set>
I've never had this problem before using both A2K and A2002. Also, I have
A2K on the second computer where the backends are located. I have no trouble
linking to the backends on that second computer using my application running
in A2K on that second computer.
I have no clue why this is suddenly not working. I guess it must have
something to do with A2003.
Help is greatly appreciated as I am at a loss.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200602/1