Originally Posted by
kepha12
But where would I put the BE once it is converted to make sure when I open the FE, it is calling the BE data that has been converted.
Put the ACCDB BE where ever you want it to reside. Then re-link the FE to the ACCDB BE.
------------------------------------------------------------------
You don't have to use the View Menu option to get into design view. Just right click on the form "frmMenu" and select "Design View" in the dialog box - 2nd one down. I never use the View menu button any more.......
------------------------------------------------------------------
The 2007 and later versions should be in a trusted location. You can set which folders are trusted.
Thanks. I will muddle through this tomorrow.
------------------------------------------------------------------
It prompted you because the FE was not in a trusted location - Access wasn't sure the code was malicious or not. If not in a trusted location and the content was not enabled, no code would execute.
------------------------------------------------------------------
I would have both the FE and the BE in the newer format, but it really doesn't matter in regards to the BE file format. For the FE, your developer should be using at least A2007 if the FE file format is A2007 or later.
------------------------------------------------------------------
Remember, you need to relink to the Access file that has the tables (the BE). The BE can be a MDB format, ACCDB format, SQL Server Express (connecting with ODBC), an Excel workbook, a Text file --- you even used to be able to link to a dBase file.
Good luck with your project.