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 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.
> 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.<<
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
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.
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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.
|
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
|
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
|
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...
|
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...
| |
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....
|
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)
|
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)
|
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...
|
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,...
|
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...
| |
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...
|
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...
|
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...
|
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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |