Connect New PC to Access Database

[Paul Purvis]

Setting up a new PC to access database

OK, Its Friday, nearly Xmas and the boss gives me a new little job, connect my laptop to the database, well I Have done it before, no probs, however this laptop has Office XP Pro and it isnt playing ball!

I have a


"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" C:\STEV\STEVP.MDB /x autoexec_local
------------------------------------------------------------------------

and I get runtime error and then

------------------------------------------------------------------------
If DummyLoc <> DbLocation Then

For I = 0 To Db.TableDefs.Count - 1

Set MyTable = Db.TableDefs(I)

errorproc = "reconnect " & MyTable.Name

Debug.Print errorproc

If Left$(MyTable.Name, 3) <> "Msy" Then

Mytablename = MyTable.Name

MyTable.Connect = ";DATABASE=" & DbLocation

MyTable.RefreshLink

End If

Next I

End If



End Sub


Any suggestions? /--- Paul

 

[ghudson]

Is the Access program executable MSACCESS.EXE located at
C:\Program Files\Microsoft Office\Office\

What version of Access do you have installed on your laptop? The taget field of your shortcut is pointing to where the Access.exe is located for Access 97. New versions of Office are installed in version specific directories [I think] like \Office10\

Also, is the STEVP.MDB application located at C:\STEV\ since that is where your shortcut is pointing to?