473,324 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Migration from Miscrosoft access 97 to MS Access 2000

2
Hello,
I am new to MS Access data base and have absolutely no knowledge on access.I have worked with sql 2000/2005.
I have been given a task to migrate MS access from access97 to access 2000

Can anyone please tell me if there are any steps I can follow or any link with information on how i do this.
I posted this question in other forums never got a reply.

Also how can I or is it possible to use VB 8 to do this?(was a sugesstion to use VB 8, but have no further info)

Thanks
Jul 15 '08 #1
1 1170
missinglinq
3,532 Expert 2GB
Allen Browne has an excellent article that discusses many of the issues in uograding from Access 97 to later versions:

http://allenbrowne.com/ser-48.html

I feel I have to tell you, however, that Access 2000 is considered by most people to be the buggiest/most unstable version. If possible, moving to version 2003 would be much better.

And, no, the "flavor" of VB that is used with any version of Access is VBA, Visual Basic for Applications, not a "straight" version of Visual Basic such as VB8.

Welcome to Bytes!

Linq ;0)>
Jul 15 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: ss_dash | last post by:
Hi all, I am using the Oracle Workbench for migrating my DB currently on Sql Server 2000 to Oracle 9i. During the migration the following happens SELECT @tBaseTable = tBaseTable,...
1
by: Bungle | last post by:
Hi everyone Does anyone know or has anyone heard of any migration tools which are/might be available for converting SQL Server 2000 databases to SQL Server 2005 Express? I'm guessing it is...
0
by: Gert | last post by:
After migration access 2000 -> xp i cannot merge my data to the word document any longer. i use ActiveDocument.MailMerge.Execute the state of mailmerge is wdNormalDocument and not...
7
by: smd | last post by:
Hello and thanks for taking the time to read this. I've looked all over the web and newsgroups and can't find a solution to my problem. I've posted this question to the Access 2000 group as well -...
1
by: Amol Shambharker | last post by:
Hello Everyone, I have been working on setting up a windows 2003 machine with IIS 6.0.The web server has the web directory on a UNC share on a windows 2003 server.I want to migrate websites from a...
0
by: galico | last post by:
Hi All, One of my clients is having a problem with a webservice that is part of an application. The application is constructed as follows. 1. Windows forms client(.NET 1.1) - on user PCs 2....
5
by: John | last post by:
Recently we migrated to a new hard- and software environment. Also, all data has moved to a new network drive, with a new name. We have one mdb and an associated mdw that now gives us trouble. If...
1
by: Maciej07 | last post by:
Hello, We are using SQL server 2000 on W2k Server and MS Access 2000 ADP (like front-end). Now we try to change operating system for SQL Server 2000 from W2k to W2k3 and we found problem with...
1
by: qwer | last post by:
import data from vb.net to miscrosoft access -------------------------------------------------------------------------------- Hi, im trying to import and store data from visual basic.net to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.