473,598 Members | 2,916 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Splitter Manager Killing ME


I worked two months developing a program to work with county office.
Has about 5000 records in it. I was able to load the Access file on CD
and carry it to office, show on maching as it developed. Got to smart
for my breeches and used the Splitter Mgr to divide the database. It
created two tables, Just it is supposed to do, one Myappl.mdb and one
Myappl _be.mdb This is fine on my machine, but now when I carry to
office I can't get it to run, can't read Macros etc. I re-linked with
Mgr. but it wants to carry the path from my computer with it. that
path is not in Office machine to be used. SO I wanted to revert to old
(1) part database as originally made and cannot unlink the files. Am I
stuck with this database split? Hope there is some way to cancell the
Splitter from my database and also clear tables marked with arrow
files. I am using Access 2000
--
LuckyLou
Posted via http://dbforums.com
Nov 12 '05 #1
5 1722
> I worked two months developing a program to work with county office.
Has about 5000 records in it. I was able to load the Access file on CD
and carry it to office, show on maching as it developed. Got to smart
for my breeches and used the Splitter Mgr to divide the database. It
created two tables, Just it is supposed to do, one Myappl.mdb and one
Myappl _be.mdb This is fine on my machine, but now when I carry to
office I can't get it to run, can't read Macros etc. I re-linked with
Mgr. but it wants to carry the path from my computer with it. that
path is not in Office machine to be used. SO I wanted to revert to old
(1) part database as originally made and cannot unlink the files. Am I
stuck with this database split? Hope there is some way to cancell the
Splitter from my database and also clear tables marked with arrow
files. I am using Access 2000


Under the "File" menu, select "Get External Data, Link Tables" to open the
"Linked Table Manager" which will allow you to specify the "new" location for
the back end tables.
Nov 12 '05 #2
> Under the "File" menu, select "Get External Data, Link Tables" to open the
"Linked Table Manager" which will allow you to specify the "new" location for
the back end tables.


Oops! forgot my sig.

:-)
--
Bruce M. Thompson
bt******@mvps.o rg (See the Access FAQ at http://www.mvps.org/access)
NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<
Nov 12 '05 #3
No you can restore it to a single file configuration simply by
manually deleteing the linked tables and importing the tables from the
back end - File/Get External Data/Import.
Patrick
On Wed, 15 Oct 2003 13:27:20 -0400, Jack R. Jones
<me*********@db forums.com> wrote:

I worked two months developing a program to work with county office.
Has about 5000 records in it. I was able to load the Access file on CD
and carry it to office, show on maching as it developed. Got to smart
for my breeches and used the Splitter Mgr to divide the database. It
created two tables, Just it is supposed to do, one Myappl.mdb and one
Myappl _be.mdb This is fine on my machine, but now when I carry to
office I can't get it to run, can't read Macros etc. I re-linked with
Mgr. but it wants to carry the path from my computer with it. that
path is not in Office machine to be used. SO I wanted to revert to old
(1) part database as originally made and cannot unlink the files. Am I
stuck with this database split? Hope there is some way to cancell the
Splitter from my database and also clear tables marked with arrow
files. I am using Access 2000


Nov 12 '05 #4
Delete all the linked tables (they have arrows to the left of them)
and go to the file menu, choose import, MS Access, find your back end
db, then import all the tables.
Nov 12 '05 #5

Thank you for replying. I am so thick. I worked my gizzard off
yesterday, over six hours. Went back to my backups (old) pasted, the
new forms, reports, macros in. Made an append query to update my
table. Finaly got it, but if I had just known. Now I do. Thanks
again. At 77 I don't grab on as quick as I used to.
--
LuckyLou
Posted via http://dbforums.com
Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3252
by: John E. Hadstate | last post by:
Please forgive the heavy cross-posting and feel free to delete inappropriate groups when you reply. I am really at a loss and hope someone has an answer for my problems. Environment: Redhat Enterprise 3, Gnome or KDE, Generic PC, 1.5 GHz P-III CPU, 256 MB RAM, Sun JRE 1.5.0_2. (These problems present on multiple hardware configurations.
7
3298
by: John | last post by:
Hi, I have a group of controls in a panel on the right-hand side of a splitter and a treeview on the left-hand side. The only configuration that I can find to make the right-hand side resize correctly is: lhsTreeview - Dock = Fill, Anchor = Top,Left splitter - Dock = Right rhsPanel - Dock = Right, Anchor = Top,Left
3
2857
by: Andre Loker | last post by:
Hi! For my current application I'm looking for a four-way-(cross) splitter control (as often seen in 3D-editors). The .NET Splitter-class is (IIRC) only a two-way splitter. Does anyone know such a four-way-splitter control? Regards, Andre Loker
4
8090
by: BBM | last post by:
I'm trying to set up a form with two panels divided by a Splitter control. I can make the Splitter work in the situations described in the documentation (Listbox or TreeView on left w/Dock set to Left, Panel on right of form w/ Dock set to Fill, Splitter between them set w/ Dock set to Left. Works as advertised. But... if I change to have two panels on the form one on the left with Dock set to Left, a panel on the right with Dock set to...
5
2318
by: Sam | last post by:
Hi, I have a panel docked to the bottom of my form. This panel can be expanded vertically by clicking on a button. When the user click on the button again, the panel is then collapsed. The panel has a horizontal splitter, which the user can use to resize the panel when it is expanded. I would like to save the height of the panel when the user uses the splitter, so that when the panel is expanded via the button, it size will be...
10
8475
by: shiry | last post by:
Hi, I need to do some important cleanup before my console application exists. I used the console ctrl event. This is working well and it fires for all cases, including the CTRL_CLOSE_EVENT (if I close the application from the X botton). But on the contrary to what the MSDN indicates (ms-help://MS.VSCC.2003/MS.MSDNQTR.2003OCT.1033/dllproc/base/handlerroutine.htm), ending my process from the task manager did not fire the CTRL_CLOSE_EVENT....
2
6223
by: tony.newsgrps | last post by:
Hi there, I'm trying to understand the impact of killing a process that owns a system mutex (used to ensure there is only 1 instance of my program running) Here is my code pretty much: try { mutex=new System.Threading.Mutex( true, mutexName, out createdNew)
2
3122
by: Istvan | last post by:
Hello ....Window.Forms.... Can somebody help me with Panels and Splitters ? I want to add three Panels to one Usercontrol , between them with two movable Splitter. First Row: 2 Columns ( 2 panels, with 1 splitter between them)
1
6055
by: JDeats | last post by:
I have a simple WinForm with a WinForms splitter down the middle. I would like to make it so when the user clicks on a button inside the left portion of the screen (the panel to the splitters left) that portion of the form is reduced in size by about 90% (I want to shrink this area of the of the form). The splitter doesn't appear to have any methods for programmatic resizing, I tried changing it's width settings and the splitter moved...
0
7894
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8284
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8392
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8262
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6711
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5437
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3938
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1500
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1245
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.