 Access 97 To Access 2003 |
|
|
|
|
  |
 Dec 27 2007, 06:44 AM
Post
#1
|
|
|
Super Member  Group: [HOSTED] Posts: 713 Joined: 8-April 06 From: Lima - Peru Member No.: 12,579  |
I need to convert a database that is in Access 97 to Access 2003 but every time i do it using the Convert tools of Access 2003 i got some errors and can't change or add any of the objects -tables, querys, etc- of the converted database.
All the errors i got are related to the user priviligies and permissions of the database, is there exists a way or procedure that allows me to reset this permissions??? Best regards, |
 |
 
|
|
Dec 27 2007, 08:09 AM
Post
#2
|
|
|
Premium Member Group: [HOSTED] Posts: 441 Joined: 5-November 06 Member No.: 17,016 |
I think it's easier if you export then import the database into a new database. That can also overcome some flaws in the access 97. Another way is to add the old database into ODBC, then use access 2003 to open it, then duplicate/copy the table into the new database. You can then setup the permission manually.
|
|
|
|
|
Dec 28 2007, 02:59 AM
Post
#3
|
|
|
Super Member Group: [HOSTED] Posts: 713 Joined: 8-April 06 From: Lima - Peru Member No.: 12,579 |
Thanks for your help faulty.lee, later i will try both options but i guess that the second one is the best choice, so that's the one that i will try first.
Best regards, |
|
|
|
|
Jan 16 2008, 11:53 PM
Post
#4
|
|
|
Super Member Group: [HOSTED] Posts: 713 Joined: 8-April 06 From: Lima - Peru Member No.: 12,579 |
QUOTE(faulty.lee @ Dec 27 2007, 03:09 AM)  I think it's easier if you export then import the database into a new database. That can also overcome some flaws in the access 97. Another way is to add the old database into ODBC, then use access 2003 to open it, then duplicate/copy the table into the new database. You can then setup the permission manually. Only to say that both options don't work and i'm not be able to work with this database. Best regards, |
|
|
|
|
Jan 17 2008, 10:48 AM
Post
#5
|
|
|
Premium Member Group: [HOSTED] Posts: 441 Joined: 5-November 06 Member No.: 17,016 |
QUOTE(TavoxPeru @ Jan 17 2008, 07:53 AM) Only to say that both options don't work and i'm not be able to work with this database. Best regards, Hmm, where did you get this database in the first place. Can you view the data inside the original database? |
|
|
|
|
Jan 18 2008, 08:02 AM
Post
#6
|
|
|
Super Member Group: [HOSTED] Posts: 713 Joined: 8-April 06 From: Lima - Peru Member No.: 12,579 |
QUOTE(faulty.lee @ Jan 17 2008, 05:48 AM) Hmm, where did you get this database in the first place. Can you view the data inside the original database? I got this database from a client of mine, and i can't view any data inside it, also, i can't export, import, corvert, etc. Yesterday i just install Access 97 and with it i can create any new object like tables, queries, modules, etc. Best regards, |
|
|
|
|
Jan 18 2008, 01:16 PM
Post
#7
|
|
|
Premium Member Group: [HOSTED] Posts: 441 Joined: 5-November 06 Member No.: 17,016 |
QUOTE(TavoxPeru @ Jan 18 2008, 04:02 PM) I got this database from a client of mine, and i can't view any data inside it, also, i can't export, import, corvert, etc. Yesterday i just install Access 97 and with it i can create any new object like tables, queries, modules, etc. Best regards, Ah, ok. If you can't read, then you can never export. I thought your initial problem was you can't change the data and it's structure. Anyway, good to hear that you can work on it now. Try to export it and use a newer version if possible. Access 97 seems to be quite old, and might be problematic or at least having limitation to cop up with the current trend. Unless you're using vb6, I don't see any reason to stick with it. Good Luck |
|
|
|
|
Jan 21 2008, 05:49 AM
Post
#8
|
|
|
Super Member Group: [HOSTED] Posts: 713 Joined: 8-April 06 From: Lima - Peru Member No.: 12,579 |
QUOTE(faulty.lee @ Jan 18 2008, 08:16 AM) Ah, ok. If you can't read, then you can never export. I thought your initial problem was you can't change the data and it's structure. Anyway, good to hear that you can work on it now. Try to export it and use a newer version if possible. Access 97 seems to be quite old, and might be problematic or at least having limitation to cop up with the current trend. Unless you're using vb6, I don't see any reason to stick with it. Good Luck Not only i can't change the data and it's structure, also i can't open any table to view its data or select it with a simple query. Exactly, the only reason why i need this database is because my client needs some new tables and queries to be created -my work- and all the data is based on the tables of this database, nothing more. Well, i don't work with VB6 for a long long time but i guess that it would be a good choice, and i hope that VB6 allows me to work with this database and finally i can perform my work. Thanks again and Best regards, |
|
|
|
|
Jan 22 2008, 05:09 PM
Post
#9
|
|
|
Newbie [ Level 1 ]  Group: Members Posts: 3 Joined: 21-January 08 Member No.: 27,776 |
access generates mysql code?
|
|
|
|
|
Jan 25 2008, 07:09 AM
Post
#10
|
|
|
Super Member Group: [HOSTED] Posts: 713 Joined: 8-April 06 From: Lima - Peru Member No.: 12,579 |
QUOTE(cmsnoob @ Jan 22 2008, 12:09 PM) access generates mysql code? I try to convert it to mysql but i'm not be able to do this because i can't read any table of the database. This problem is gonna make me  Best regards, |
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 5th July 2008 - 04:02 AM |