Splitting Database 2007

[Emma]

Hi I've been trying to split my database onto the server. I copied the files
to the server ran ms access and went to split it. I even tried mapping the
drive but it only splits properly when I put the be on the same computer I'm
working on. I click on the file with the name_be to split it. Any ideas?

 

[Albert D. Kallal]

Hi I've been trying to split my database onto the server. I copied the
files
to the server ran ms access and went to split it. I even tried mapping the
drive but it only splits properly when I put the be on the same computer
I'm
working on. I click on the file with the name_be to split it. Any ideas?

When You split a database into two parts, the front end, and the back end,
you'll find that the front end remains linked to the location of where the
back end **originally** was when you originally split the database.

What this means is that if you move the location of the back end to a
different location, then you'll have to to go into the front end and tell it
where you moved that back end location to. The front end does not have some
special "knowledge" if (or when) the backend is moved to a different
location.

So if you change the location of the back end to a new location, then you
have to the access front end where this back end is now located.

to point the front end to the back and location, you'll use what's called a
linked table manager. in access 2007 the open up the front end and then:

click on the "Database Tools " tab.

Then click on the "linked table" manager. This will allow you to select all
the linked tables, and then BROWSE to the new lcoation to select the back
end and this will then "connect" (well, re-connect) your front end to the
back end...

 

[dhstein]

Hi I've been trying to split my database onto the server. I copied the files
to the server ran ms access and went to split it. I even tried mapping the
drive but it only splits properly when I put the be on the same computer I'm
working on. I click on the file with the name_be to split it. Any ideas?

Just to add to Albert's comments. Don't copy the file to the server.
Instead, keep the file on your workstation and map a drive to the server, for
example "J". Now split the database and when it asks where to put the
backend - enter J:\Optional-Any-folder-name\name-of-program_be.accdb

After the split, you'll have a front end program called
name-of-program-accdb and a backend on the server on drive J in the folder
you specified. You can then copy the front end to any system and it will
look for the backend database in the same location, that is
J:\Optional-Any-folder-name\name-of-program_be.accdb