Something's going on locally with my Access 2000.
Whenever I import an object from another .MDB, it damages the receiving DB to
the point where I have to rebuild from the last backup. Repair/Compact doesn't
work.
Whole objects disappear, and when a compile is attempted the message "Error
accessing file. Network connection may have been lost." appears.
Anybody been here?
--
PeteCresswell
13  1708 
(Pete Cresswell) wrote: Something's going on locally with my Access 2000.
Whenever I import an object from another .MDB, it damages the receiving DB to
the point where I have to rebuild from the last backup. Repair/Compact doesn't
work.
Whole objects disappear, and when a compile is attempted the message "Error
accessing file. Network connection may have been lost." appears.
Anybody been here?
Service packs? A2K was very buggy.
--
This sig left intentionally blank
"(Pete Cresswell)" <x@y.z> wrote in message
news:el******** *************** *********@4ax.c om... Something's going on locally with my Access 2000.
Whenever I import an object from another .MDB, it damages the receiving DB
to
the point where I have to rebuild from the last backup. Repair/Compact
doesn't
work.
Whole objects disappear, and when a compile is attempted the message
"Error
accessing file. Network connection may have been lost." appears.
Anybody been here?
--
PeteCresswell
Try creating a new blank database and import all objects
from the old one.
You must import Import/Export Specs (if any) together
with the tables.
Compact + Repair & best whishes.
Bruno
I used to have this problem when I was trying to make upgrades on one mdb a
different computer running a different (newer) Access version. I would do
as you did, and import a form that I had created on one mdb, and it would
hose the target mdb. It *did not* seem to matter if I was importing only
forms with compatible code.
My solution was to stop exporting/importing forms, reports, and modules.
Eventually, both computers got the same Access version, and the problem no
longer exists, but I still back up the target mdb before any exports of
objects.
Darryl Kerkeslager
"(Pete Cresswell)" <x@y.z> wrote in message
news:el******** *************** *********@4ax.c om... Something's going on locally with my Access 2000.
Whenever I import an object from another .MDB, it damages the receiving DB
to the point where I have to rebuild from the last backup. Repair/Compact
doesn't work.
Whole objects disappear, and when a compile is attempted the message
"Error accessing file. Network connection may have been lost." appears.
Anybody been here?
--
PeteCresswell
Hi, Pete. Something's going on locally with my Access 2000.
Whenever I import an object from another .MDB, it damages the receiving DB
Do all of these other circumstances apply:
1.) The imported object has a code module (a form, report, or module
object); and
2.) The VBA code was not compiled prior to closing the database
application; and
3.) MS Office 2K SP-3 has not been installed yet on at least one of the
computers that has opened this database application and run the VBA code;
and
4.) That computer also has one of the MS Office XP or MS Office 2003
applications or Visio 2002 installed.
Please see this Knowledge Base article concerning a nasty bug:
http://support.microsoft.com/default.aspx?id=304548
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"(Pete Cresswell)" <x@y.z> wrote in message
news:el******** *************** *********@4ax.c om... Something's going on locally with my Access 2000.
Whenever I import an object from another .MDB, it damages the receiving DB
to the point where I have to rebuild from the last backup. Repair/Compact
doesn't work.
Whole objects disappear, and when a compile is attempted the message
"Error accessing file. Network connection may have been lost." appears.
Anybody been here?
--
PeteCresswell
On Sun, 21 Nov 2004 14:13:07 GMT, "(Pete Cresswell)" <x@y.z> wrote:
Good advice already given. To add to that: in some situations the
undocumented SaveAsText and LoadFromText can be of help.
-Tom. Something's going on locally with my Access 2000.
Whenever I import an object from another .MDB, it damages the receiving DB to
the point where I have to rebuild from the last backup. Repair/Compact doesn't
work.
Whole objects disappear, and when a compile is attempted the message "Error
accessing file. Network connection may have been lost." appears.
Anybody been here?
RE/ 4.) That computer also has one of the MS Office XP or MS Office 2003
applications or Visio 2002 installed.
Bingo!..... Access 2003. (along with Access 2.0 and Access 97...)
--
PeteCresswell
Hi, Pete.
Sorry to hear that. At least you know what the problem is, and you can
prevent it from happening in the future by installing MS Office 2K SP-3.
Your current VBA code is corrupted, though, because VBA 6.2 (from Access
2003) isn't compatible with VBA 6.0 (from Office 2K), but it's already mixed
into your database file. :-(
But you've got backups. Right?
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"(Pete Cresswell)" <x@y.z> wrote in message
news:5e******** *************** *********@4ax.c om... RE/4.) That computer also has one of the MS Office XP or MS Office 2003
applications or Visio 2002 installed.
Bingo!..... Access 2003. (along with Access 2.0 and Access 97...)
--
PeteCresswell
RE/ Your current VBA code is corrupted, though, because VBA 6.2 (from Access
2003) isn't compatible with VBA 6.0 (from Office 2K), but it's already mixed
into your database file. :-(
But you've got backups. Right?
The loss is no biggie - my backup practices verge on the clinically-paranoid.
It was more the inconvenience of not being able to pull chunks of existing apps
into a new app.
SP3 is installing as I write this.
If the problem persists, I'll just uninstall Access 2003.
Thanks for the tip - saved me beaucoups time and trouble.
--
PeteCresswell
RE/ At least you know what the problem is, and you can
prevent it from happening in the future by installing MS Office 2K SP-3.
Not to turn into a tarbaby on you, but while I'm at it.....
Somewhere in a similar timeframe I lost the ability to drag an Access 2000 .MDB
to an icon that starts Access 2000. Doubleclick the .MDB, no problem....but
dropping on an icon does not work.
Same thing seems to hold for other apps.
--
PeteCresswell This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Stian Søiland |
last post by:
all examples performed with:
Python 2.3+ (#2, Aug 10 2003, 11:09:33)
on linux2
(2, 3, 0, 'final', 1)
This is a recursive import:
|
by: Vio |
last post by:
Hi,
I've been trying to embed (statically) wxPy alongside an embedded py
interpreter on a linux/gtk box.
At one point, for some reason misc.o linking reported "multiple
definitions of wxGetFreeMemory()". Since wxGetFreeMemory() seemed
effectively unused in gtk, I just commented it out in misc_wrap.cpp
(didn't want to patch SWIG to regenerate the wrapper code, so hacked the
generated cpp source), and replaced...
|
by: Steve Holden |
last post by:
This is even stranger: it makes it if I import the module a second time:
import dbimp as dbimp
import sys
if __name__ == "__main__":
dbimp.install()
#k = sys.modules.keys()
#k.sort()
#for kk in k:
|
by: Pedro Lucas via .NET 247 |
last post by:
I have a weird .RC corruption problem with MSVC .NET 2003.
I have a .RC file that has been in use for years with .NET inside a project called Netcount. Recently I upgraded to .NET 2003 and migrated the project.
Now, everytime I access the resources to change a dialog or so, then, when I compile, the compiler halts with errors:
Generating Code...
Compiling resources...
..\Netcount.rc(1698) : error RC2135 : file not found: LANGUAGE...
|
by: Jon |
last post by:
It appears that (windows) python searches in the current working
directory before looking in the local site-packages directory, or that
'.' comes first in sys.path? The problem arises when I made the mistake
of running a test program from the same directory where I built and
installed my package. Python uses the package from the current
directory, which misses the pyd files, instead of the site-packages
package which has them installed.
...
| | |
by: Randy |
last post by:
Folks:
We have a web-based app that's _really_ slowing down because multiple
clients are writing their own private data into a single, central
database. I guess the previous programmer did things this way because it
made things easy. Well, I'm the person that has to put up with
the long-term headache.
Anywho, someone at work wants things sped up, so what I'm looking
at doing is this for each client:
|
by: robert |
last post by:
I get python crashes and (in better cases) strange Python exceptions when (in most cases) importing and using cookielib lazy on demand in a thread.
It is mainly with cookielib, but remember the problem also with other imports (e.g. urllib2 etc.).
And again very often in all these cases where I get weired Python exceptions, the problem is around re-functions - usually during re.compile calls during import (see some of the exceptions below). But...
|
by: Deano |
last post by:
Every once in a while I modify one particular form (could be anything from
adding code to tweaking properties as far as I can see) and upon loading I
get;
"You can't assign a value to this object"
The form is now completely blank and I can only see anything if I switch to
design view. I am kaking changes that will break the form admittedly but
those are bugs of course and I expect to be able to fix them.
|
by: rsoh.woodhouse |
last post by:
Hi,
I'm trying to work out some strange (to me) behaviour that I see when
running a python script in two different ways (I've inherited some
code that needs to be maintained and integrated with another lump of
code). The sample script is:
# Sample script, simply create a new thread and run a
# regular expression match in it.
import re
|
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: 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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
