Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Print Table Definition
Message
 
À
27/06/2000 21:32:36
Information générale
Forum:
Microsoft Office
Catégorie:
Access
Divers
Thread ID:
00384522
Message ID:
00385606
Vues:
31
Well,
what I did, I changed the file Properity to "Read-only" to see if I'll get the message you are getting, and yes I did.

to solve it, before opening the file in Access, go and change the file properity and remove the read-only tick, then open it and follow the steps I tols you before.

Good Luck


>I opened it with Access 97. First it prompted me saying:
> The database 'TableInfo' is read-only.
>
>Then I went to the Report tab and select the report "TableInfo" and
>click Preview button. It prompted me error (Set dbs = CurrentDb) as what
>you had mentioned, I have ignore it by closing the windows.
>
>Then I click the Preview button again to run. It prompt me:
> Can't update. Database or object is read-only.
>
>Anything wrong with my way of opening or running? Thanks.
>
>>Hi Alvin,
>>It's working fine, I downloaded the file & open it in Access97.
>>go to "Reports" and run the report u will see "Enter Parameter Value" window
>>just type one of the table names in the same file like "Pets" then click "Ok"
>>a report will be generated displaing the table defenesions and relations.
>>
>>Note: "if you faced this problem...orelse ignore it"
>>-----
>>Fisrt time when you run the file it will give you an error on the Class-Module on line (Set dbs = CurrentDb) just egnore the message close the error window and run it again ... it will work)
>>
>>
>>>>>Anyone knows how to print out the Access 97/2000 Table
>>>>>definitions? There is all the Fields, Type and the Length.
>>>>>Pls advise, thanks.
>>>>
>>>>I have just send a .mdb file (titled "Print Access tables relationship") to the UT file manager to be placed in the VB files section. Check in the next few days and you will see it there for download!
>>>
>>>I have downloaded the mentioned .mdb file. How could I use it? I tried
>>>to open in Access 97 environment, it says "Read Only". I don't know
>>>where should I run this program to print the Table Definition of my
>>>Database Tables. Please advise, thanks.
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform