You will no longer receive e-mail notifications from this forum.
Log-In to post
Do you have a quick support question and short of time? Contact us Via Twitter @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest
I have a task regarding access database. I and my organization is using access database to maintain my access files in well mannered way. But due to varied reasons access file showing error message
Error 3112: Your access database got corrupted will not be able to show the database.
Due to this error message I will not be able to access my access database. I don't have any idea how to recover access database or how to fix access database errors without affecting my original database????? Is there any relevant solution to repair access database?????
I thought of sharing my experience using the sql Generation Dialog.
- It doesn't have a Close button at the bottom. Minor, but a bit annoying when I come to this dialog very often.
- re: Actions: I am not to sure how Actions are supposed to work. Every time I change a setting in that dialog I am scared that I am going to loose that setting so I end up saving the action - The problem is that it creates a new action every time even when I use the same name instead of overwriting the one with the same name and I end-up having to items with the same name in the Load Action drop-down.
How about renaming Action to Generation Settings and changing the behaviour to overwrite the settings with the same name. Otherwise I have to use numbers, Action01, Action02 ... to know which one is the last one which becomes annoying when you make changes and re-generate the script often.
-Not all the foreign keys of the tables I selected are included. In the Referential Integrity tab I checked Always, so I thought all the foreign keys are selected from the tables I selected for generation but that's not true. I had to go Select List -> Relationships and check them there.
That's it for now with this dialog.
Overall, my experience with the tool has been so and so. This morning when I came, some changes I made yesterday were gone. I left the program running. Not sure what happened. Maybe there is no point in mentioning it, but what the heck. Now I got into a paranoid mode and I click Apply every time I have a chance and save very often.
I have been using Toad Data modeler freeware 32bit since Dec 2016. The 120 days limit is approaching and I'm trying to re-download as the site said -simply download. But am having difficulty, even though I have created an account with address, email, phone etc., updated my profile. When I complete the form to initiate the download, the submit button does not seem to work. It's possible it is rejecting my PostalCode, but it was accepted on the account creation. I see various references to Toad, Quest and Dell and am confused as to what or how these fit together.
I am on a few data base forums and participate with design and draft models. The freeware edition of TDM is very adequate for my use, and I would like to re download the latest version before my current freeware expires. I am a retired data management person.
Any info to clarify the terminology, and especially for how to get this freeware download sorted would be most welcome.
Is there a way to specify distinct captions for the two ends of a relationship between two tables in a physical model?
As an example, from the video rental model, a Customer borrows movies, I wanted to add one caption on the Customer side, Borrows, and on the other side, Borrowed by.
I used before ER/Studio from Embarcadero and you could add descriptions on both ends of a relationship. I was curious if you can do something similar in TDM. I find that sometimes having captions on both sides of a relationship can enhance the readability of the model.
Update: I started to use Rectangle Labels. Is there another way?
I am new to the Toad Data Modeler. I have created a couple for ERDs through this tool. I would say this is a wonderful tool. But after creating the ERDs, there are a couple of changes in the database. I have designed the model in a printable format with great difficulty (as I am not a good designer). But once the change is made, I am not able to revise my ERD. I have tried it through Update Model from Database (I got this idea from a different thread)
Unfortunately, that is not working for me. When I am trying with this. It is asking me to select the tables again from the scratch. Please let me know whether I am doing anything wrong or this is the way the tool behaves. Is there a better way to do that. If I am not clear, please go through the above link. I have the same question that he had.
I have a client who insists on using some reserved words in their database that I'm rebuilding.
Instead of having the argument about best practice and losing their confidence I'd like to be able to add square brackets automatically around ALL entities/attributes when generating the SQL / ADO.
Is this possible?
(I note Toad will delimit entities/attribute values that have spaces so I assume it's possible somehow).
I use the comments and descriptions options in my model to document my database. In SQL Server this information is subsequently added to custom properties in the database which I then extract into administrator reports.
Typos in those comments and descriptions are very bad so I am wondering if anyone has any suggestion for how to spell check these properties without having to cut-n-paste the text into another window.
I prefer to keep all components of a program together.
Unfortunately Toad Data Modeler creates a settings folder
C:\Users\<username>\AppData\Roaming\Dell\Toad Data Modeler\
while the main installation folder is in
How can I move the settings folder to another directory?I prefer a subdirectory like
Therefore Toad Data Modeler should automatically look at first in this customized location before the software looks atC:\Users\<username>\AppData\Roaming\Dell\Toad Data Modeler\
Another solution could be to pass a parameter at the commandline similar to
Is this somehow possible?
... this might be because of the performance.
Loading the landing page of the forum takes ages for me and usually doesn't finish unless I try multiple times. Sometimes it works if I login before visiting the forum.
When tracing the network calls using wget I see this:
--2017-05-03 08:25:07-- www.toadworld.com/.../default.aspxResolving www.toadworld.com (www.toadworld.com)... 184.108.40.206Connecting to www.toadworld.com (www.toadworld.com)|220.127.116.11|:80... connected.HTTP request sent, awaiting response... 301 Moved PermanentlyLocation: www.toadworld.com/.../f [following]--2017-05-03 08:25:08-- www.toadworld.com/.../fReusing existing connection to www.toadworld.com:80.HTTP request sent, awaiting response... 200 OKLength: 69159 (68K) [text/html]Saving to: 'www.toadworld.com/products/toad-data-modeler/f/default.aspx'www.toadworld.com/products/toad-data-modeler/f/de 100%[===============================================================================================================>] 67.54K 105KB/s in 0.6sLast-modified header missing -- time-stamps turned off.2017-05-03 08:25:09 (105 KB/s) - 'www.toadworld.com/products/toad-data-modeler/f/default.aspx' saved [69159/69159]Loading robots.txt; please ignore errors.--2017-05-03 08:25:09-- www.toadworld.com/robots.txtReusing existing connection to www.toadworld.com:80.HTTP request sent, awaiting response... 200 OKLength: 69 [text/plain]Saving to: 'www.toadworld.com/robots.txt'www.toadworld.com/robots.txt 100%[===============================================================================================================>] 69 --.-KB/s in 0s2017-05-03 08:25:09 (869 KB/s) - 'www.toadworld.com/robots.txt' saved [69/69]--2017-05-03 08:25:09-- www.toadworld.com/.../layout.cssReusing existing connection to www.toadworld.com:80.HTTP request sent, awaiting response... Read error (Unknown error) in headers.Retrying.--2017-05-03 08:25:29-- (try: 2) www.toadworld.com/.../layout.cssConnecting to www.toadworld.com (www.toadworld.com)|18.104.22.168|:80... connected.HTTP request sent, awaiting response... Read error (Unknown error) in headers.Retrying.--2017-05-03 08:25:59-- (try: 3) www.toadworld.com/.../layout.cssConnecting to www.toadworld.com (www.toadworld.com)|22.214.171.124|:80... connected.HTTP request sent, awaiting response... Read error (Unknown error) in headers.Retrying.--2017-05-03 08:26:37-- (try: 4) www.toadworld.com/.../layout.cssConnecting to www.toadworld.com (www.toadworld.com)|126.96.36.199|:80... connected.HTTP request sent, awaiting response...
--2017-05-03 08:27:08-- (try: 5) www.toadworld.com/.../layout.cssConnecting to www.toadworld.com (www.toadworld.com)|188.8.131.52|:80... connected.HTTP request sent, awaiting response... Read error (Unknown error) in headers.Retrying.--2017-05-03 08:27:40-- (try: 6) www.toadworld.com/.../layout.cssConnecting to www.toadworld.com (www.toadworld.com)|184.108.40.206|:80... connected.HTTP request sent, awaiting response...
So there seems to be something wrong when loading the CSS file for the site.
New to Toad Data Modeler. Are there any user guides and tutorials I can download for 6.1.
After I enter Model action, and I click Entities and check to generate Comments...and I close it....program doesn't keep this setting.
Generating script from model action doesn't generate entity and attribute comments at all.
Tested on x86 version.
Any suggestions how to solve this?
I just install toad data modeler freeware version today.
When it first run program, I get "Invalid or expired freeware license".
Can anyone help me,please.
I'm trying to remove a relation from my ERD, but I want to leave its carried fields in the child table.
In particular, I want to remove the relationship M20_PCL_F01 between parent M20_PCL_IDX and child M20_PCL, but maintaining the field PCL_ID in the child (highlighted in the image).
Whenever I remove the relation, Toad automatically removes the field too.
Is there any solution? (besides re-adding the field manually... it is inherited by a number of descendant tables)
When using arrays in Postgres, the default HTML report does not show this. E.g. a column defined as text (Type: Text, Is Array Type: true) is only shown as "Text" in the ER diagram and also as "Text" in the Entities list. There is no indication at all that the column is an array.
It would also be nice if that was shown in the WorkSpace as well, e.g. as Text instead of just Text
Please help me troubleshoot this exception.I am trying to convert Logical data model to physical data model. I have a few many to many relationships in the LER model.I will be unable to paste the log from the company TOAD data modeler software installation .
Getting Access violation at address 018796F3 in module TDM.exe. Read of address 00000000
Address : 018796F3
ID : 7215
Module Version : 220.127.116.11
Module Name: TMD.exe
I've just moved to SQL 2016 and done a simple data model which i then used to generate a script to build the database tables (using TDM 18.104.22.168).
However, without making any changes to either model or db, when I do a compare I get a large number of differences which can basically be summarised as the same set of 5 or 6 fields per table:-
- Attribute collation - this is not set in the model, but the compare has detected the collation applied and flagged it as a difference
- Entity index properties (5 spatial properties set in model, but not in db and type of index set as relational in db but not in model)
I know I can remove these fields in the advanced settings, but there seems to be no way for this settings change to be remembered for the next time and it is quite laborious to have to keep unchecking all these item boxes (not to mention the large possibility of making a mistake!).
So is there any way to have the compare tool remember these settings changes for future compares?
Alternatively, is there any way to set up defaults when creating model items so that at least the model side doesn't add anything in that doesn't seem to be used by SQL 2016 (spatial fields, collation)? If so, can this be applied retrospectively to an existing model or will it only work for new models and items?
I know inside the model menu (model items submenu) we can bring up lists up entities, relationships, etc. But is there a way of getting lists of lower level objects like indexes, fields/attributes and keys?