Connecting Tech Pros Worldwide Forums | Help | Site Map

Transfering a split database

Stan
Guest
 
Posts: n/a
#1: May 6 '07
I am working on a database in ACCESS 2003. This is a simple DB with
only one table. I have successfully split the database into
database.mdb and database_be.mdb. When I copy the two files to a
clients' computer and try to run database.mdb I receive the following
error message "database_be.mdb is not a valid path".

database_be.mdb runs OK. I have tried the utility Tools < Database
Utilities < Linked Table Manager and Compact and repair database with
no luck.

Can anyone help me out on this?

Thank you,

Stan Hanna


tina
Guest
 
Posts: n/a
#2: May 6 '07

re: Transfering a split database


suggest you open the frontend database - to the database window - on the
client's computer. delete the linked table. on the menu bar, click on File |
Get External Data | Link Tables. navigate to the backend database on the
client's computer and select it. in the Link dialog, select the table and
link it. compact the frontend db, and try using it.

hth


"Stan" <stanhanna@hotmail.comwrote in message
news:1178464686.215047.275350@l77g2000hsb.googlegr oups.com...
Quote:
I am working on a database in ACCESS 2003. This is a simple DB with
only one table. I have successfully split the database into
database.mdb and database_be.mdb. When I copy the two files to a
clients' computer and try to run database.mdb I receive the following
error message "database_be.mdb is not a valid path".
>
database_be.mdb runs OK. I have tried the utility Tools < Database
Utilities < Linked Table Manager and Compact and repair database with
no luck.
>
Can anyone help me out on this?
>
Thank you,
>
Stan Hanna
>

Stan
Guest
 
Posts: n/a
#3: May 6 '07

re: Transfering a split database


On May 6, 12:10 pm, "tina" <nos...@address.comwrote:
Quote:
suggest you open the frontend database - to the database window - on the
client's computer. delete the linked table. on the menu bar, click on File |
Get External Data | Link Tables. navigate to the backend database on the
client's computer and select it. in the Link dialog, select the table and
link it. compact the frontend db, and try using it.
>
hth
>
"Stan" <stanha...@hotmail.comwrote in message
>
news:1178464686.215047.275350@l77g2000hsb.googlegr oups.com...
>
Quote:
I am working on a database in ACCESS 2003. This is a simple DB with
only one table. I have successfully split the database into
database.mdb and database_be.mdb. When I copy the two files to a
clients' computer and try to run database.mdb I receive the following
error message "database_be.mdb is not a valid path".
>
Quote:
database_be.mdb runs OK. I have tried the utility Tools < Database
Utilities < Linked Table Manager and Compact and repair database with
no luck.
>
Quote:
Can anyone help me out on this?
>
Quote:
Thank you,
>
Quote:
Stan Hanna
database.mdb is the frontend database. When I File < Open and double
click on the database.mdb is when I get the error message. I have to
OK the error message and can not proceed any further.

Stan Hanna

Scott
Guest
 
Posts: n/a
#4: May 6 '07

re: Transfering a split database


Have you tried opening while holding shift to skip the form opening? You
need to just open the database window
"Stan" <stanhanna@hotmail.comwrote in message
news:1178469393.680163.234840@n59g2000hsh.googlegr oups.com...
Quote:
On May 6, 12:10 pm, "tina" <nos...@address.comwrote:
Quote:
>suggest you open the frontend database - to the database window - on the
>client's computer. delete the linked table. on the menu bar, click on
>File |
>Get External Data | Link Tables. navigate to the backend database on the
>client's computer and select it. in the Link dialog, select the table and
>link it. compact the frontend db, and try using it.
>>
>hth
>>
>"Stan" <stanha...@hotmail.comwrote in message
>>
>news:1178464686.215047.275350@l77g2000hsb.googleg roups.com...
>>
Quote:
I am working on a database in ACCESS 2003. This is a simple DB with
only one table. I have successfully split the database into
database.mdb and database_be.mdb. When I copy the two files to a
clients' computer and try to run database.mdb I receive the following
error message "database_be.mdb is not a valid path".
>>
Quote:
database_be.mdb runs OK. I have tried the utility Tools < Database
Utilities < Linked Table Manager and Compact and repair database with
no luck.
>>
Quote:
Can anyone help me out on this?
>>
Quote:
Thank you,
>>
Quote:
Stan Hanna
>
database.mdb is the frontend database. When I File < Open and double
click on the database.mdb is when I get the error message. I have to
OK the error message and can not proceed any further.
>
Stan Hanna
>

Stan
Guest
 
Posts: n/a
#5: May 6 '07

re: Transfering a split database


On May 6, 12:52 pm, "Scott" <a@awrote:
Quote:
Have you tried opening while holding shift to skip the form opening? You
need to just open the database window"Stan" <stanha...@hotmail.comwrote in message
>
news:1178469393.680163.234840@n59g2000hsh.googlegr oups.com...
>
Quote:
On May 6, 12:10 pm, "tina" <nos...@address.comwrote:
Quote:
suggest you open the frontend database - to the database window - on the
client's computer. delete the linked table. on the menu bar, click on
File |
Get External Data | Link Tables. navigate to the backend database on the
client's computer and select it. in the Link dialog, select the table and
link it. compact the frontend db, and try using it.
>
Quote:
Quote:
hth
>
Quote:
Quote:
"Stan" <stanha...@hotmail.comwrote in message
>
Quote:
Quote:
>news:1178464686.215047.275350@l77g2000hsb.googleg roups.com...
>
Quote:
Quote:
I am working on a database in ACCESS 2003. This is a simple DB with
only one table. I have successfully split the database into
database.mdb and database_be.mdb. When I copy the two files to a
clients' computer and try to run database.mdb I receive the following
error message "database_be.mdb is not a valid path".
>
Quote:
Quote:
database_be.mdb runs OK. I have tried the utility Tools < Database
Utilities < Linked Table Manager and Compact and repair database with
no luck.
>
Quote:
Quote:
Can anyone help me out on this?
>
Quote:
Quote:
Thank you,
>
Quote:
Quote:
Stan Hanna
>
Quote:
database.mdb is the frontend database. When I File < Open and double
click on the database.mdb is when I get the error message. I have to
OK the error message and can not proceed any further.
>
Quote:
Stan Hanna
It worked, then I used the link manager to reestablish the links. All
appears to be working ok now. I can now proceed to keep my client
happy. For your information this is a not for profit client so your
help has been more than appreciated.

You people are amazing both with your knowledge and generosity.

Thanks,

Stan

Closed Thread