hi access gurus
would appreciate if u can give me pointers regarding conversion of ms
access 97 application to ms access 2000, like what are the problems to
be expected and how to handle it.
also would appreciate if anyone can give pointers on using VSS with ms
access 2000, how to handle multiuser issues when it comes to insert,
update and delete.
thanx in advance,
regards
bala 2 1660 ba*******@yahoo .com (bala) wrote in message news:<b6******* *************** ****@posting.go ogle.com>... hi access gurus
would appreciate if u can give me pointers regarding conversion of ms access 97 application to ms access 2000, like what are the problems to be expected and how to handle it.
also would appreciate if anyone can give pointers on using VSS with ms access 2000, how to handle multiuser issues when it comes to insert, update and delete.
thanx in advance,
regards bala
About the only thing that's seriously different when you upgrade from
97 to 2000 is that if you have any code behind your forms, 97 uses DAO
and 2000 uses ADO, so the ADO library is registered by default in
2000. You'll just have to unregister it and register DAo 3.6 instead.
Access should do the conversion for you...
hi Pieter
thanx for the information, well have used ADO in ms access 97 so i
think the conversion shouldn't be a problem.
take care and best of luck
regards
bala This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: David |
last post by:
Hi,
I want to work with Access 2002.
I will need to be able to distribute my application to users that may
still have access 2000 on their computers. I know access 2002 has a
function that enables you to convert a database to a format of an
earlier version of Access. I wanted to check for any unforeseen
problems so here is what I did:
I used Access 2002 to convert my Access 2000 application to the 2002
|
by: David W. Fenton |
last post by:
A client is panicking about their large Access application, which
has been running smoothly with 100s of thousands of records for
quite some time. They have a big project in the next year that will
lead to a lot of use of the database and the adding of quite a lot
of new data (though I can't conceive of them adding more than than
10s of thousands of records, which won't change the current
performance profile at all).
If there is a SQL...
|
by: Peter Mather |
last post by:
Hi,
I have struck problems when trying to convert an Access97 database to
Access 2000.
I get a compile Error when I start the database in Access 2000.. The
message is Can't find project or library. In the procedures it
highlights the Error$ statement and in functions it highlights Left$ and
Mid$
|
by: John Furphy |
last post by:
Please excuse my ignorance in this area, being an amateur Access user.
I have an Access 2000 application which runs fine, however when I
convert it to Access 2002 and run it, it comes up with repeated error
messages, as for example in the code below when it reaches the line
rst.Edit
The message is:
|
by: Greg Strong |
last post by:
Hello All,
Hello All,
What are the ToDo's / Gotchas to convert an MDB Access 2K2 database to
an Access Project (i.e. ADP) file for the front end using Microsoft
SQL Server 2000 Desktop Engine (MSDE 2000) for the back end?
Now for the background. I have a prototype MDB file that was built in
Access 2K2, and compiled in Access 2K to provide backward
| |
by: Deb |
last post by:
All 12 of my department's machines are being converted next week from
Windows 2000/Office 2000 to Windows XP/Office 2003. I have downloaded
the Migration document from Microsoft for distribution but would like
your input regarding Access as many of our group use it.
I am concerned especially about linking to other Access databases. And
about connecting to Dbo data. We also regularly connect to and from
Excel files.
All of our...
|
by: musosdev |
last post by:
Hi
I've got a project I've just run through the conversion wizard, and it's
giving me a few headaches.
I've got a user control which has controls referrenced from its calling page
(usercontrol1.textbox1.text etc).
All worked fine in V2003, but 2005 is giving me a "usercontro1.textbox1 is
inaccessible due to it's protection level" error. Obviously, with it now
|
by: Oldie |
last post by:
I have built an MS Access Application under MS Office XP (but I also
own MS Office 2000). I have split the application in the pure database
tables and all the queries, forms, reports and macro's.
Now i want to use this application for different foundations in the
Netherlands but I want to secure my application so no one can change
it, copy it or steal it from me. I always thought there was a kind of
conversion tool that would translate...
|
by: nmanolea |
last post by:
Hi from Greece,
I use access 97 in my daily work and I want to convert the databases I use from access 97 to access 2000. The conversion was OK unless a few conversion errors with minor significance.
The main issue is that in my new access 2000 databases, the greek letters, words etc are not recognised and instead some strange symbols appear.
So, I would like to ask what may be the problem and possible solutions to this.
Thanks in...
|
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...
|
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: 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: 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: 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: 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...
| |