473,698 Members | 2,337 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

VB Using A2000 MDB

I have a user who has what I assume is a VB application: it's opened
with an exe file, there are numerous dll files in the directory in which
the executeable resides, along with an mdb file that I could not open in
A97, but can open in A2003.

Assuming I'm probably correct that this is a VB application, what part
of A2000 (the vintage of the application is such that it was installed
before A2002) is actually installed, or does it need to be installed at
all with the VB program?

Several years ago, after this program was installed, his A97 references
started to go wonky, similar to behaviour I saw in installations with
A97 and inmproperly installed A2K.

Thanks in advance for any comments.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #1
3 1419
Tim Marshall wrote:
I have a user who has what I assume is a VB application: it's opened
with an exe file, there are numerous dll files in the directory in which
the executeable resides, along with an mdb file that I could not open in
A97, but can open in A2003.

Assuming I'm probably correct that this is a VB application, what part
of A2000 (the vintage of the application is such that it was installed
before A2002) is actually installed, or does it need to be installed at
all with the VB program?

Several years ago, after this program was installed, his A97 references
started to go wonky, similar to behaviour I saw in installations with
A97 and inmproperly installed A2K.


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Probably, just the JET DLL was installed to control the .mdb file.

You're probably correct about the improper installation of A2K. I
believe the fix was to uninstall A2K, change a font file name (which
name escapes me), and reinstall A2K. Don't know how you'd do it for
just a JET DLL.

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQi32sIechKq OuFEgEQLyIQCg90 Ug8O5v8sDPiTarn 4vMEaeErrIAn2Qy
I3gDJvkfHKnqxtX upwoDq3/g
=COry
-----END PGP SIGNATURE-----
Nov 13 '05 #2
"MGFoster" wrote
You're probably correct about the
improper installation of A2K. I
believe the fix was to uninstall A2K,
change a font file name (which
name escapes me), and reinstall A2K.
Don't know how you'd do it for
just a JET DLL.


Mike, the fix you describe is for avoiding the "No License" message when you
try to install Access 97 -- the font is HATTEN.TTF, but it won't help in
this case, AFAIK.

Classic VB (through VB6) would have installed Jet. Jet 4.0 (the one used
with Access 2000 and later) has had several (8, I think) Service Packs,
which should be applied.

A possibly pertinent Knowledge Base article is 238401. Visit
http://support.microsoft.com and take a look at it. VB6 originally came with
Jet 3.5x (the one used with Access 97) and this deals with using VB6 with
the more-recent Jet 4.0.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #3
Larry Linson wrote:
A possibly pertinent Knowledge Base article is 238401. Visit
http://support.microsoft.com and take a look at it. VB6 originally came with
Jet 3.5x (the one used with Access 97) and this deals with using VB6 with
the more-recent Jet 4.0.


Thanks Larry, I'll check this one out.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #4

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

Similar topics

16
2205
by: Wayne Aprato | last post by:
I have several Access 97 databases which are split into front end and back end running off a server. The front end mde is shared by 2 or 3 - absolute maximum of 6 concurrent users. This scenario has been working flawlessly for about 2 years. I am now at a point where these databases need to be converted to Access 2003. I think I read somewhere on this forum that the newer versions of Access are not as tolerant to multiple users...
22
2341
by: Bradley | last post by:
Has anyone else noticed this problem? I converted the back-end to A2000 and the performance problem was fixed. We supply a 97 and 2000 version of our software so we kept the backend in A97 to make upgrading simple for users. We've done it like that for years but a new client has been having severe performance issues... solved by converting the backend to 2000. -- regards, Bradley
1
1580
by: \(Bradley | last post by:
In an A2000 ADP I cannot edit data in an MS-SQL2000 view that has a simple JOIN in it. However I can edit the data in the same view if I open it in A2003 or SQL Query Analyser/etc. I understand A2000 was developed for SQL7? Is there any way to get around this behaviour? -- regards, Bradley
6
6312
by: tdmailbox | last post by:
I developed an access database in access 2003(keeping my database in the access 2000 format). It has been fully tested to be access 2000 compatible and works great. I am trying to package the final version however and when I tell it to create a shortcut it includeds the path to access 2003 in the shortcut C:\Program Files\Microsoft Office\OFFICE11\ my client is running access 2000. I could not figure any way to change the access...
1
1529
by: Paul Brady | last post by:
I have A97 and A2K on my computer at home, on which I do volunteer work for several databases on our county park system. One of the clients uses A97, and the rest, A2K. The A97 user is considering upgrading their Microsoft Office. If they upgrade to Office 2000, I have no problems; I'll convert their A97 database and we'll be in business. But what if they upgrade to Office 2003 (I think there is such a thing) and install A2003. Will I...
2
1321
by: spiq25 | last post by:
.mdb file on A2000 has been working for months, after upgrading from WinME to WinXP SP2a we find out some problems: 1. date() function is used for setting up default value, but it couldn't be find anymore 2. in a combo-box when user filling in data the choice list should narrowed. It doesn't wirk anymore. Intead user must fill in the whole text or to browse the whole list of choices Is it possible to repair A2000 after installing WinXP...
6
2227
by: tombsy | last post by:
Hello Group. I work for a company who is about to embark on a long awaited Office upgrade from Office 97 to Office XP. Office XP comes with Access 2002. I am an accomplished Access developer so I have read up on the complexities of upgrade in the corporate environment. Also the need to carry out a full MDB audit to get rid of the redundancy etc etc
0
1328
by: Tom | last post by:
All: I posted on this yesterday, but for whatever reason, Google isn't dealing nicely with it... Anyway, I need to install A2000 on a computer that already has A2002 so I can create A2000 mde files. I have the A2000 install disk. Our IT department controls the installation of A2002. After installing A2000 (into a different directory than A2002)
1
1524
by: Fred Zuckerman | last post by:
I have a database on a shared drive. It has user level security (ie: mdw file). It was created in A2000 and works fine when opened on workstations with A2000 installed. Some workstations have A2003 installed. On those workstations there is an unbound form that continually gives the un-useful message: "Microsoft Access Has Encountered A Problem And Must Shutdown, We're Sorry For The Inconvenience"
0
8676
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
8608
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
9161
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
7732
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
5860
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
4619
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3050
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
2
2332
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2006
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.