473,699 Members | 2,174 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Import Corrupts DB?

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
Nov 13 '05 #1
13 1698
(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
Nov 13 '05 #2
"(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
Nov 13 '05 #3
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

Nov 13 '05 #4
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

Nov 13 '05 #5
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?


Nov 13 '05 #6
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
Nov 13 '05 #7
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

Nov 13 '05 #8
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
Nov 13 '05 #9
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
Nov 13 '05 #10

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

Similar topics

0
6907
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:
0
2577
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...
5
2472
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:
0
1383
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...
2
2568
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. ...
7
4193
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:
6
2359
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...
6
1472
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.
9
2114
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
0
8691
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9180
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...
1
8920
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,...
0
8887
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
7755
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...
1
6536
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 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...
0
4378
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...
1
3060
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
3
2012
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.