Reply to thread

Message

<blockquote data-quote="bitz" data-source="post: 322815" data-attributes="member: 6208">1) Go to <a href="http://www.adoanywhere.com" target="_blank">http://www.adoanywhere.com</a>2) Click on Download &amp; Buy link at the top.3) Download the trial version.Its a 14-day trial, and if you want to buy it, its a measly 10 bucks.4) Install the sucker.** BACKUP YOUR DATABASE **No really.** DO IT NOW **I promise you will muck something up. I do databases for a living. I KNOW. =)5) Lauch the program. Go to File -&gt; Open -&gt; Open Database File. Navigate to where your database.mdb file is in your Database folder in Etools. and select Open.Voila! You are staring at all the tables in Tree format on the left.** BACK UP YOUR DATA !! **To start editing your data, select the &quot;Table&quot; tab (In between the Sql and File tabs). Under the 'Table Name' field, choose the table you wish to Edit.A grid will appear below with all the data in that table. You can actually INSERT data, here's how: Select the very LAST row of the table and click the + sign (Hover help says Insert Record). You now get an empty row. Start entering your data. When you are done, click the check mark.Now, there ARE caveats.1) This tool was not directly built for this. It works, but it IS kludgy.2) I tested it, and it does create the AutoId type fields where applicable.3) You fudged something, huh? RESTORE YOUR BACKUP! <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f600.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":D" title="Big grin&nbsp; &nbsp; :D"&nbsp; data-smilie="8"data-shortname=":D" /> Hope this helps!</blockquote>

[QUOTE="bitz, post: 322815, member: 6208"] 1) Go to [url]http://www.adoanywhere.com[/url] 2) Click on Download & Buy link at the top. 3) Download the trial version. Its a 14-day trial, and if you want to buy it, its a measly 10 bucks. 4) Install the sucker. ** BACKUP YOUR DATABASE ** No really. ** DO IT NOW ** I promise you will muck something up. I do databases for a living. I KNOW. =) 5) Lauch the program. Go to File -> Open -> Open Database File. Navigate to where your database.mdb file is in your Database folder in Etools. and select Open. Voila! You are staring at all the tables in Tree format on the left. ** BACK UP YOUR DATA !! ** To start editing your data, select the "Table" tab (In between the Sql and File tabs). Under the 'Table Name' field, choose the table you wish to Edit. A grid will appear below with all the data in that table. You can actually INSERT data, here's how: Select the very LAST row of the table and click the + sign (Hover help says Insert Record). You now get an empty row. Start entering your data. When you are done, click the check mark. Now, there ARE caveats. 1) This tool was not directly built for this. It works, but it IS kludgy. 2) I tested it, and it does create the AutoId type fields where applicable. 3) You fudged something, huh? RESTORE YOUR BACKUP! :D Hope this helps! [/QUOTE]

Verification