MDE Files

[Nick Bradbury]

Hi

I want to share a Database on a network [Peer to Peer] running Windows XP,
the DBase is Access 2000. To begin with I just put the .mdb file in a shared
folder, however although the file could be seen on the network I could not
open it, a message saying "File could not be found check spelling / file
path" was returned. As more than one user may need to access the datbase I
decided to split the database and create an MDE file that I put on the Local
Machine, this works no problem, I then copied the same MDE file to a
different machine when I opened the file the Switchboard Form opens but that
is all.

I know I am missing something, probably obvious, can anyone shed any light

Thanks

Nick Bradbury

 

[John Vinson]

Hi

I want to share a Database on a network [Peer to Peer] running Windows XP,
the DBase is Access 2000. To begin with I just put the .mdb file in a shared
folder, however although the file could be seen on the network I could not
open it, a message saying "File could not be found check spelling / file
path" was returned. As more than one user may need to access the datbase I
decided to split the database and create an MDE file that I put on the Local
Machine, this works no problem, I then copied the same MDE file to a
different machine when I opened the file the Switchboard Form opens but that
is all.

I know I am missing something, probably obvious, can anyone shed any light

You probably need to open the .MDB frontend file (from which you
derived the .MDE), and use Tools... Linked Table Manager to link the
frontend properly to the backend. If you navigate to the backend via
Network Neighborhood rather than via My Computer, it will link to an
unamiguous path like

\\Servername\Drive\Path\xyz_BE.mdb

rather than to a mapped drive letter; since different computers might
have different drive mappings, this could prevent part of this
problem.

Another possibility is that the Switchboard Wizard and the Database
Splitter Wizard are partially incompatible: the switchboard requires a
*local*, unsplit, Switchboard table; the database splitter ignores
this and puts the Switchboard table into the backend. You may need to
delete the link, reimport the Switchboard table, delete it from the
backend, and make a new MDE.

John W. Vinson[MVP]

 

[Nick Bradbury]

Thanks John

I'll try it first thing on Monday

Nick

Hi

I want to share a Database on a network [Peer to Peer] running Windows XP,
the DBase is Access 2000. To begin with I just put the .mdb file in a
shared
folder, however although the file could be seen on the network I could not
open it, a message saying "File could not be found check spelling / file
path" was returned. As more than one user may need to access the datbase I
decided to split the database and create an MDE file that I put on the
Local
Machine, this works no problem, I then copied the same MDE file to a
different machine when I opened the file the Switchboard Form opens but
that
is all.

I know I am missing something, probably obvious, can anyone shed any light

You probably need to open the .MDB frontend file (from which you
derived the .MDE), and use Tools... Linked Table Manager to link the
frontend properly to the backend. If you navigate to the backend via
Network Neighborhood rather than via My Computer, it will link to an
unamiguous path like

\\Servername\Drive\Path\xyz_BE.mdb

rather than to a mapped drive letter; since different computers might
have different drive mappings, this could prevent part of this
problem.

Another possibility is that the Switchboard Wizard and the Database
Splitter Wizard are partially incompatible: the switchboard requires a
*local*, unsplit, Switchboard table; the database splitter ignores
this and puts the Switchboard table into the backend. You may need to
delete the link, reimport the Switchboard table, delete it from the
backend, and make a new MDE.

John W. Vinson[MVP]