Can't connect to database across network

  • Thread starter Thread starter Scientific
  • Start date Start date
S

Scientific

Hello again,

I can't connect to a database from local computer to host across the network
using a shortcut. Access say's it can't find the BackEnd file even though
it's sitting there in C:\Recipe. When Access loads I get this error message:

Run time error '3034'
Could not find file 'C:\Recipe\Recipe BE.mdb'

The local computer has 2 files on it:
Recipe Shortcut = shortcut to database on \\MYSERVER
Recipe FE.mdb = Front End to Recipe database

The host computer (MYSERVER) has 3 files on it:
Recipe BE.mdb = Back End to Recipe database
RecipeGroup.mdw = Workgroup file

The shortcut file has these properties:
Target:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"\\MYSERVER\RecipeDB\Recipe FE" /wrkgrp "\\MYSERVER\RecipeDB\RecipeGroup.mdw"

Start in:
\\MYSERVER\RecipeDB
 
Hello again,

I found a problem with my shortcut and linked tables. First, my BackEnd
tables had to be linked using my server name, volume name and directory path.
Second, my shortcut also had to be updated to reflect the same path as the
linked tables.

What I ended up doing is outlined below:

Changed Linked Tables path to:
\\MYSERVER\Disk 1\Recipe\Recipe BE.mdb

Original shortcut workgroup target was:
\\MYSERVER\RecipeDB\RecipeGroup.mdw

Changed shortcut workgroup target to:
\\MYSERVER\Disk 1\RecipeDB\RecipeGroup.mdw


Changed Start in from:
\\MYSERVER\RecipeDB

Changed Start in to:
\\MYSERVER\Disk 1\RecipeDB

Finally, I copied the FE from the HOST to the LOCAL computer and everything
works now. Hope this helps others.

-S
 
Back
Top