How to create MDE if Access2000 uses linkedtable form SQL 7.0

[Guest_imported]

I have a databse wichi has all main tables in the SQL 7.0 with the password requred to view them.&nbsp;&nbsp;I have created forms and some temprery Access tables to make the application usable.&nbsp;&nbsp;However, I am not aboe to create and MDE databse.&nbsp;&nbsp;When I click it I receive the informative message that Access was not able to create MDE file.&nbsp;&nbsp;I would appretiate if you are be able to help me.<br><br>REgards

 

[DougP]

2 reasons why you cannot create a .MDE<br>1. VBA code is corrupt or has a syntax error.<br>2. Other corruption.<br><br>Do you have VBA code in your .mdb<br>If so open it up to view the code and Click the &quot;Debug&quot; menu then &quot;Compile all Modules&quot;<br>Fix any errors or Rem them out using a single quote &gt; ' <br><br>Also check my FAQ' on creating .MDE they may help.<br><br><A HREF="

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=4687634&CFToken=60394424#90"

TARGET="_new">

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=4687634&CFToken=60394424#90</A><br><br><A

HREF="

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=4687634&CFToken=60394424#91"

TARGET="_new">

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=4687634&CFToken=60394424#91</A><br><br><br>If

all else fails you will have to make a new .MDB and import everything that will come over. What does not come over is corrupt and will have to be recreated.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.