 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / SQL Server / ADP / January 2008Creating ADE file in 2007
Hi, I'm a bit stuck creating a 2007 ADP file. When I select New -> Filename -> Save as type -> MS office Access project -> Create -> Connect to an existing server/DB, Access 2007 header reports as "Access 2002 - 2003 file format". I have the default file format set to Access 2007. How do I force the application to work with 2007 file format? Also I noticed that the Navigation pane can be hidden but once the ADE file is created, the user can active it being able to modify the tables' contents. How do I block them from doing so? TIA Ana There isn't Access2007 format for ADP/ADE. Access2007 could well be the very last Access version that support ADP/ADE. As for being able to midifying table (or other SQL Server objects, such as View/SP..., for that matter), it has nothing to do with using ADP or ADE. ADP/ADE is SQL Server database' front end application. ADE only hides code in ADP. To control access/permission to SQL Server objects, you do it on the SQL Server (although you could do something on SQL Server database using ADP as SQL Server management tool) end, be it remotely or locally. > Hi, > [quoted text clipped - 14 lines] > > Ana I am afraid that is true, and support for ADP in the runtime is abysmal. I posted about that earlier. On the positive side: the new Interop Toolkit makes it possible to migrate an Access application to .Net one form at a time. -Tom. >There isn't Access2007 format for ADP/ADE. Access2007 could well be the very >last Access version that support ADP/ADE. <clip> > On Thu, 24 Jan 2008 13:13:01 -0700, "Norman Yuan" Can you give me more information about the Interop Toolkit? Sounds like what I need to do some massive migrations. > <FakeN...@FakeEmail.Not> wrote: > [quoted text clipped - 9 lines] > > <clip> Check this out: http://groups.google.com/group/comp.databases.ms-access/browse_thread/thread/78d 8c3a80cca3cc1/c4c77f430c7402db?lnk=st&q=stiphout+interop#c4c77f430c7402db -Tom. >> On Thu, 24 Jan 2008 13:13:01 -0700, "Norman Yuan" >Can you give me more information about the Interop Toolkit? [quoted text clipped - 13 lines] >> >> <clip> |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.