|
|
QUOTE(Darasen @ Apr 14 2008, 09:14 AM) My apologies for the delayed response. The Compact and Repair utility is under tools the the Access menu. Access keeps sevral system tables in each DB that are hidden by default. One of these tables stores object level permissions. Thre system tables can get a bit wonky sometimes and need repaired. I am operating under the assumption that the DB is l... read more.
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.
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, 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, 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? 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, 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 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,
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, Latest EntriesQUOTE(Darasen @ Apr 14 2008, 09:14 AM) My apologies for the delayed response. The Compact and Repair utility is under tools the the Access menu. Access keeps sevral system tables in each DB that are hidden by default. One of these tables stores object level permissions. Thre system tables can get a bit wonky sometimes and need repaired. I am operating under the assumption that the DB is likely to have a mdw file as well given that it dies seem to have security enabled. The default location for this file is the same directory as the mdb file. Lastly you can certainly use VB to access an Access DB. You will, however, still need to have the database's username and password. Thanks for your time and don't worry for your delayed response, as you can notice i just see your response because last month i had a lot of problems with my connection that fortunately i resolve a few days ago. I think that the better solution to this issue is by using VB to access this database. Best regards,
My apologies for the delayed response.
The Compact and Repair utility is under tools the the Access menu. Access keeps sevral system tables in each DB that are hidden by default. One of these tables stores object level permissions. Thre system tables can get a bit wonky sometimes and need repaired. I am operating under the assumption that the DB is likely to have a mdw file as well given that it dies seem to have security enabled. The default location for this file is the same directory as the mdb file. Lastly you can certainly use VB to access an Access DB. You will, however, still need to have the database's username and password.
Tell me, the Access repair tool is the one located under the Database Utilities submenu under the Tools menu or it is a stand alone application??? if it is the second option from where i can download it because i just search it without success.
When i first copy this database i dont copy the MDW file that you say, so, if i get this file from my client every thing will work??? Also, i notice that this file can be located in a folder that i choose but, where is the default location for it?? BTW, Can i use Visual Basic to access this database??? and thanks for the access security link i'm start reading it, very useful. Best regards, QUOTE(TavoxPeru @ Apr 8 2008, 07:02 AM) Ok, here are my answers:
Best regards, From the information I have there are a couple of possibilities. Since the description sounds as if you are able to actually open the database in Access and see the objects but not view the objectys you may well have a corrupt DB. The Access repair tool may well resolve your issue. Or In Access you can set permissions for the database allowing various user levels with various levels of access to add or manipulate the data or design. When this is done a separate file with an MDW extension is created. This file is the Workgroup file. It seems that you have the MDB file available to you but not the MDW file. What you will need is either to get hte MDW file and a Username and Password for it. You can read all about Access security from Microsoft. QUOTE(Darasen @ Apr 7 2008, 10:17 AM) Hello, to assist in resolving this issue I have a few questions that need to be answered. The database in question: Are you working with it directly? Is the .mdb file on your local machine? Is the database set up as a single user application or as a client/server app? If the Database has a front end are you able to create or edit data through it? Did your client provide you with a user name and password to work on the database? Have you attempted to open the database file exclusively? Does the client have a backup of the workgroup file? Have you tried to delete and replace it? Lastly, for now, what is your exact error message? Answering these questions may well lead you to a resolution if not post the answers. Ok, here are my answers:
Best regards,
Recent Queries:-
Keywords : access 97 access 2003
I was looking to make a site where people need to create an account, and log in to view the main Hey guys, im new here and am looking for answers /tongue.gif" style="vertical-align:middle" I have a problem. Is any program wchich converts database Access to Mysql ??... This may be the stupidest question ever, I don't know, but frankly if this exists it would help Alright, I'm currently creating an interface program for a MS Access database. I've only I have to create a whole project using Microfost Access. I have a field which will eventaually ok .. i have this little problem i am going through ... Leme explain this project of mine first . I I'm coming up with an error that I can't figure out in my registration page. Below I've Hi anyone can help me with making a form. These are the case; I am using Ms. Access XP, and a On my previous web host, I surpassed my MySQL quota limit. At least, that's what they told me. I have 3 differen tables in this database that are basically repeating the same data. How can I The HP Learning center offers very good free lessons on creating databases with step by step i am using a software to access to mysql remotely but it display error!(Access denied for I want to know that is php supports MS Access databases. And could anyone told me the complete php Is there any way to convert a mySQL dump (.sql file) to an access file? Problem is, I downloaded and i want to transition the records in SQL7 to ACCESS in the condition of VF 6.0 how i can?... I try to access to a remote mysql owned by my friend , I have the IP and username and password. but Looking for access, 97, access, 2003
|
|
 Access 97 To Access 2003 |
| ADD REPLY / Got an Opinion! | a humble request :-) | RAPID SEARCH! | Free Hosting | [X] |
|
Express your Opinions, Thoughts or Contribute more info. to help others. Ask your Doubts & Queries to get answers, So that "Together We can help others!" |
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP. | 500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE |
|