Creating ADE file in 2007

[Ana]

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

 

[Norman Yuan]

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.

 

[Tom van Stiphout]

On Thu, 24 Jan 2008 13:13:01 -0700, "Norman Yuan"

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>

 

[raibeart]

Can you give me more information about the Interop Toolkit?
Sounds like what I need to do some massive migrations.

 

[Tom van Stiphout]

On Fri, 25 Jan 2008 05:52:15 -0800 (PST), raibeart

Check this out:
http://groups.google.com/group/comp...db?lnk=st&q=stiphout+interop#c4c77f430c7402db

-Tom.