473,414 Members | 1,888 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,414 software developers and data experts.

Transfering a split database

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
4 1841
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Erich | last post by:
I have two SQL servers I am dealing with. I have some tables in one database on one SQL server that I want to transfer into a database on the other SQL server. I want to xerox copy the tables...
1
by: Tim Pascoe | last post by:
I've been trying to get the scripts posted earlier to the group by Clay Beatty to work properly. Using the three components he posted, I have managed to get a new SP generated. However, when I...
2
by: Niyazi | last post by:
Hi, I have BIG question and I gues it is the BEST question. I have a problem that I am guessing the best solution is to create some sort ..NET Services. This Service(s) must check every...
0
by: newbie via AccessMonster.com | last post by:
I am creating a database that allows a person to customize a new database according to how they want it. So the database I create should be able to allow someone to click on a "new" button which...
10
by: Walshi | last post by:
Hi all, I'm a relative newby to access and VBA etc. My forms and tables etc are working great and saving lots of time...However... I have two databases with the exact same table format. I want...
3
by: artillero | last post by:
Im transfering my database to another host and it's pretty large 100mb, can someone please tell me how I can tranfer my large database to phpmyadmin. Thank you
6
by: Stan | last post by:
I am working on a database in ACCESS 2003. This is a simple DB with only one table. I have split the DB so I can upgrade and debug the front end before installing on my clients' computer. I used...
4
by: GaryDean | last post by:
I have a 2.0 Website application in the dev environment that uses a SQL Server 2005 DB and also uses the authentication controls and classes that automatically use SQLServer Express. It all works...
5
by: sreenu123 | last post by:
Hi, I want to read from values from database and add to listbox then transfering items from one listbox to another listbox using C#.NET. Can any one give source code. Thanks in advance sree
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.