Hi,
Access 2003. Running over terminal server on a Windows Server 2003 box.
The error occurs on every machine that I've tried copying the file to.
Latest Jet SP & Office SP. Database hasn't been converted. A mixture of
modules, forms, linking tables & temp. tables at the access end.
Exporting to a new database doesn't work (same error). Importing from a
new database doesn't work (same error). Trying to open any form or module in
code view is impossible (same error). Permission are set at
HKLM/Soft.../Micros.../Office/XX [version] for everyone to full control.
Can anyone help? I'm not fussed about the data - but we spent two full
days and nights work on code modules- and made no record of the development
process. I'd love to get that work back if possible.
- Good "de-corruption" tool?
- Any way of getting to the code (splitting the vb parts out of the
mdb?)
We haven't backed up the database recently enough to merely roll
back. Yes - it is our own fault. We'll be backing up daily rather than twice
weekly now.
Thanks,
Nick Stansbury
Analyst, Sage Partners
12  9462 
On Jul 15 2004, 05:57 am, "Nick Stansbury" <nickDOTstansbu ry@sage-
partners.com> wrote in news:cd******** **@phys-news-1.nl.colt.net: - Any way of getting to the code (splitting the vb parts out of the
mdb?)
Did you try SaveAsText? If that fails, which I think is likely, try
pksolutions.com .
--
remove a 9 to reply by email
In message <cd**********@p hys-news-1.nl.colt.net>, Nick Stansbury
<ni************ **@sage-partners.com> writes Hi,
Access 2003. Running over terminal server on a Windows Server 2003 box.
The error occurs on every machine that I've tried copying the file to.
That could be a bogus error message. I remember seeing it when I was
moving A2000 databases around a few years ago. IIRC it meant that one of
the linked tables referenced in a query couldn't be opened because there
was no DSN on the machine the file had been moved to. It was nothing at
all to do with VBA.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money. Did you try SaveAsText? If that fails, which I think is likely, try
pksolutions.com .
SaveAsText? Not being an access guy I'm a bit lost - how can I run any vb
routines without being able to get into the VB editor?
In message <zm************ **@shrdlu.com>, Bernard Peek <ba*@shrdlu.com >
writes In message <cd**********@p hys-news-1.nl.colt.net>, Nick Stansbury
<ni*********** ***@sage-partners.com> writesHi,
Access 2003. Running over terminal server on a Windows Server 2003 box.
The error occurs on every machine that I've tried copying the file to.
That could be a bogus error message. I remember seeing it when I was
moving A2000 databases around a few years ago. IIRC it meant that one
of the linked tables referenced in a query couldn't be opened because
there was no DSN on the machine the file had been moved to. It was
nothing at all to do with VBA.
I'm not working for that company any more so I can't refer to my notes
at the time. but more of the details are coming back to me.
The problem was that there was a form in the database that couldn't open
its data source because the source used a linked database that was not
available.
I would start by creating a clean database and importing or re-creating
the tables and queries in it. Verify that each table can be opened, fix
any that can't. If you can open all of the tables and queries then the
problem is something else.
Once all of the tables are fixed you should be able to import the forms
and open them, unless there's a completely different reason for the
error message.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.
"Nick Stansbury" <ni************ **@sage-partners.com> wrote: - Good "de-corruption" tool?
Decompile is the only thing I know of.
Decompile or how to reduce Microsoft Access MDB/MDE size and decrease start-up times http://www.granite.ab.ca/access/decompile.htm
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
"Nick Stansbury" <ni************ **@sage-partners.com> wrote: Did you try SaveAsText? If that fails, which I think is likely, try
pksolutions.com .
SaveAsText? Not being an access guy I'm a bit lost - how can I run any vb
routines without being able to get into the VB editor?
Good point. Actually excellent point. You can't reference a utilities MDB as
that's buried in the VBA editor.
I was going to post the following but ignore it now.
The undocumented SaveAsText and LoadFromText may help if an object is corrupted or
otherwise behaving weirdly.
At the debug/immediate window type:
Application.Sav eAsText acForm,"MyForm" ,"c:\form.tx t
You can load the file into a new MDB.
Application.Loa dFromText acForm,"MyForm" ,"c:\from.tx t"
Sample code at http://www.datastrat.com/Code/DocDatabase.txt
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
"Nick Stansbury" <ni************ **@sage-partners.com> wrote: Access 2003. Running over terminal server on a Windows Server 2003 box.
The error occurs on every machine that I've tried copying the file to.
Latest Jet SP & Office SP. Database hasn't been converted. A mixture of
modules, forms, linking tables & temp. tables at the access end.
This may sound odd but the same message is displayed if it's an MDE in A2003 format
and you try to run it in A2002. Now I doubt very much it's an MDE and you are trying
to open it in A2002 as your posting sounds reasonably competent.
I'm not quite sure why I'm mentioning this even but oh well.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony Toews <tt****@teluspl anet.net> wrote in
news:81******** *************** *********@4ax.c om: "Nick Stansbury" <ni************ **@sage-partners.com> wrote:
Access 2003. Running over terminal server on a Windows Server
2003 box.
The error occurs on every machine that I've tried copying the file
to. Latest Jet SP & Office SP. Database hasn't been converted. A
mixture of modules, forms, linking tables & temp. tables at the
access end.
This may sound odd but the same message is displayed if it's an
MDE in A2003 format and you try to run it in A2002. Now I doubt
very much it's an MDE and you are trying to open it in A2002 as
your posting sounds reasonably competent.
I'm not quite sure why I'm mentioning this even but oh well.
It's an erroneous error message, and you have just documented for
the Google Groups archive that it is, in fact, an error. Your post
could someday save someone some work.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
On Jul 15 2004, 08:31 am, "Nick Stansbury" <nickDOTstansbu ry@sage-
partners.com> wrote in news:cd******** **@phys-news-1.nl.colt.net: Did you try SaveAsText? If that fails, which I think is likely, try
pksolutions.com .
SaveAsText? Not being an access guy I'm a bit lost - how can I run any vb
routines without being able to get into the VB editor?
Can you get into the Debug window? Try Ctrl+G. If that works, in the Debug
window type
Application.Sav eAsText acForm, "formname", "path_to_fi le"
If that works, repeat for all modules in the database, then load them into
a new database using LoadFromText with similar syntax.
In fact, you may try the Objects as Text add-in from http://www.users.cloud9.net/~dfurman/code.htm, which provides a GUI for the
above.
If you cannot get into the Debug window, then another option would be to
open the database in an instance of Access via automation and use
SaveAsText on that instance, to avoid loading the corrupt project in the
VBE. Post back if you need details on how to do that.
As Tony said, decompile is worth a try too.
--
remove a 9 to reply by email This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: angelag |
last post by:
I am currently taking a college course in Visual Basic.Net and I am a
beginner.
I bought Visual Studio.Net 2003 to do my homework at home. I built my
first project and e-mailed it to myself at school. When I tried to
open it in the lab, I got a message saying I couldn't open it because
it was created with a newer version. Evidently the lab is using Visual
Studio.Net 2002.
My professor doesn't just want the executable file, he wants...
|
by: K. Shier |
last post by:
when attempting to edit code in a class file, i see the bug "Visual Basic
..NET compiler is unable to recover from the following error: System Error
&Hc0000005&(Visual Basic internal compiler error) Save your work and restart
Visual Studio .NET."
has anyone seen this bug and can you confirm one way or the other whether or
not it can corrupt your source files? (by 'corrupt' i mean: do anything to
it that will cause it to fail to load and...
|
by: Jerome |
last post by:
Hi, I'm a bit confused ... when would I rather write an database
application using MS Access and Visual Basic and when (and why) would I
rather write it using Visual Studio .Net?
Is it as easy in Visual Studio to create reports and labels as it's in
Access?`
The advantage of VS.net is that not every user needs Access, right? And
that would eliminate the Access version problem as well I guess.
|
by: Harris |
last post by:
Can anyone please help?
I have read the postings on the error "The Visual Basic for
Applications Project in the database is corrupt" but none report the
particular problem I am experiencing, i.e., this error only occurs
running my program on computers of some of my clients.
To elaborate: I have a program that is being used by around 60 clients
all over the world. My program is an mde file in Access2003. It works
absolutely without hitch...
|
by: m.roello |
last post by:
In the book:
"Working with Microsoft Visual Studio 2005"
Craig Skibo wrote:
"The power of Visual Studio 2005 lies in its ability to empower users to
build, test, and debug powerful applications quickly and easly."
I don't agree on what concernes ASP .NET Web Sites in VS2005.
All what involves Namespaces in Web sites has been disappeared. I know
you can still MANUALLY manage them, but not QUICKLY and EASLY. In a
| | |
by: Steve |
last post by:
I am trying to create a DLL in Visual Studio 2005-Visual Basic that contains
custom functions. I believe I need to use COM interop to allow VBA code in
Excel 2002 to access it. I've studied everything I can find on COM Interop
and .NET. I've also tried many of the 'Walkthroughs' on the MSDN site
relating to COM add-ins, .NET and Office XP but am unable to get even these
working in Excel 2002 or Word 2002.
I've installed the Office XP...
|
by: FlyingBuckner |
last post by:
All right be kind, this is my first question on a forum. I need help on selecting the right software to purchase.
I have a database set up using Access, 6 users. It is split into Tables and Applications, no more then 65MB of data in the tables right now.
I have 2 college courses in Visual Basic 6 and have written VBA code in Access and AutoCad. I work for a steel fabricator and the database is written to track material usage, purchase...
|
by: Chris Asaipillai |
last post by:
Hi there
My compay has a number of Visual Basic 6 applications which are front endeed onto
either SQL Server or Microsoft Access databases.
Now we are in process of planning to re-write these applications into Visual Basic.Net.
My managers main thought is that Visual Basic 6 is (or has!) stopped being supported
by Microsoft.
|
by: Chris Asaipillai |
last post by:
Hi there
I have some questions for those experienced Visual Basic 6 programmers out
there
who have made the transition from VB6 to Vb.net.
How long did it take you to learn at least the basic elements of
VB.net....so that
you were confident to write a application from scratch. This wouldnt
necessarily
|
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: 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: 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
|
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...
| |
