A07 Q:

[Amy]

Hi,

I'm trying out A07 and I noticed that in A03 .adp file I use a connexion to
my SQLServer but cannot find this option in A07. The only option I found was
to link the SQL tables to A07 project. This' not what I want exactly. Does
someone know where the connexion the SQL Server option is hiding?

TIA

Amy

 

[Sylvain Lafontaine]

Link SQL table to A07 project? What kind of project under A07 exactly are
you talking?

ACCDB databas files are like MDB database files and don't offer support for
anything but linked tables for interfacing with SQL-Server. If you want to
work with an ADP file then you must use an ADP file; even if you are using
A07 instead of A2003.

 

[Ana]

So, what's an A03 ade file equivalent in A07? In what format should a
project be saved so the average user cannot see the tables and the
programming?
Thanks,
Ana


"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
escribió en el mensaje de noticias

 

[Sylvain Lafontaine]

ADE or ADP? I'm not sure if your question is related to the conversion of
an ADP project to its compiled form ADE or to something else. Your original
post was about ADP and now it's about ADE: is it a typo or something else?

In A2007, ADP work in the same way as with A2003 so you shouldn't have any
problem using ADP under A2007 if you already know how to use them under
A2003. The file extension remains the same (.ADP) so unlike mdb, there is
no new file format for ADP in A07. ADE should also works the say way;
however, as A2007 is a new version, there is always the possibility of
having some new bugs.

 

[Tom van Stiphout]

Office Key (that's the big circular button in upperleft corner) >
Server > Connection

-Tom.

 

[Amy]

Thank you Sylvain,
I do work with ADP files and save them as ADE for the network users. I
noticed that I can link and select tables from the SQL server via ODBC but
cannot connect directly to the server as I'm doing with A03. Perhaps my A07
60 day test version doesn't have the option enabled. However, if I import an
A03 adp project, I do see the server connection under the office button.

Ana.


"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
escribió en el mensaje de noticias

 

[Sylvain Lafontaine]

Oh, I think that your problem is maybe you are creating the wrong type of
file when using A2007. The process of creating a new ADP project has been
changed from A2003 to A2007: when you want to create a new project with
A2007, you must specify the suffix .ADP when you choose to create a new
database file; otherwise an ACCDB database file will be created and these
files are not ADP project but the new version of MDB files and these files
(MDB or ACCDB) offert support only for linked tables; not a sql-server
connection like it is with ADP.

At this moment, I don't have a working copy of A2007 at hand; to I'm telling
this from memory.