By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,374 Members | 1,768 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,374 IT Pros & Developers. It's quick & easy.

Transfering a split database

P: n/a
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

May 6 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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" <st*******@hotmail.comwrote in message
news:11**********************@l77g2000hsb.googlegr oups.com...
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

May 6 '07 #2

P: n/a
On May 6, 12:10 pm, "tina" <nos...@address.comwrote:
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:11**********************@l77g2000hsb.googlegr oups.com...
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
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

May 6 '07 #3

P: n/a
Have you tried opening while holding shift to skip the form opening? You
need to just open the database window
"Stan" <st*******@hotmail.comwrote in message
news:11**********************@n59g2000hsh.googlegr oups.com...
On May 6, 12:10 pm, "tina" <nos...@address.comwrote:
>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:11**********************@l77g2000hsb.googleg roups.com...
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

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

May 6 '07 #4

P: n/a
On May 6, 12:52 pm, "Scott" <a@awrote:
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:11**********************@n59g2000hsh.googlegr oups.com...
On May 6, 12:10 pm, "tina" <nos...@address.comwrote:
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:11**********************@l77g2000hsb.googleg roups.com...
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
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
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

May 6 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.