A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Converting 97 database to 2003 database and implications



 
 
Thread Tools Display Modes
  #1  
Old November 22nd, 2004, 12:29 AM
John
external usenet poster
 
Posts: n/a
Default Converting 97 database to 2003 database and implications

I have an Access database that was created with 1997 version. I want to edit
that database using 2003 version. If I do what the message says below, will
it affect access to the database that is on the server now? This particular
database is called 'Users', consists of 5 columns and 5 rows where I store
userid, username, password, and there are two more columns, one called
'bissuperadmin' and the other 'txuid'. In other words, in upgrading the
database, will that prevent someone from being able to log in? Access 1997
message: You can’t make changes to the database objects in the database
‘filesystem’. The database was created in an earlier version of Microsoft
Access. To convert this database to the current version of Microsoft Access,
close the database, poin to Database Utilities on the Tools menu, and then
click ‘Convert Databse’.
--
John T. Sullivan
  #2  
Old November 22nd, 2004, 06:23 AM
John Vinson
external usenet poster
 
Posts: n/a
Default

On Sun, 21 Nov 2004 15:29:01 -0800, "John"
wrote:

I have an Access database that was created with 1997 version. I want to edit
that database using 2003 version. If I do what the message says below, will
it affect access to the database that is on the server now?


Yes. It will require that anyone using it have at least Access2000.
Access97 cannot open or use a database in Access2000 format, the
default format for Access2000, XP and 2003.

However, you can convert the database to 2000 format; edit it using
Access2003; and use File... Convert... Save as Previous Version to
generate an Access97 format database. Just don't use any features not
supported in 97, and *KEEP A BACKUP*.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.