Access 2003 adp file in Access 2007

I have an access 2003 adp which works fine in Access 2007. Do I need to
convert it to Access 2007. When I create a blank adp file in Access 2007 it
appears to be created in Access 2002-2003. Is this because adp files are not
supported in Access 2007?

If I create an accdb file and link to the SQL server tables I need the table
names are all prefaced with dbo. which means I have to change all my VBA code
to get my application to work. I'm concerned if I rename all of the linked
tables I may run into problems down the road

ADPs are supported under Access 2007 but only with the older format
2002-2003; hence your result.

If you are new to SQL-Server, using an ACCDB file (or the older MDB format
if you want a wider compatilibity) with ODBC linked tables to SQL-Server is
probably a much safer/easier bet to go.

I'm not to sure about your description of the problem with dbo. because I
don't know where you seeing them: on the SQL-Server or locally on the ACCDB
file, after the linked process? Don't be too concerned with renaming the
tables issue, it's only the schema (or the owner if you are under SQL-2000
instead of 2005/8) of the tables.

Finally, if you want to work against SQL-Server, you should get a good book
and learn more about it.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"SuzanneH" wrote in message
...
I have an access 2003 adp which works fine in Access 2007. Do I need to
convert it to Access 2007. When I create a blank adp file in Access 2007
it
appears to be created in Access 2002-2003. Is this because adp files are
not
supported in Access 2007?

If I create an accdb file and link to the SQL server tables I need the
table
names are all prefaced with dbo. which means I have to change all my VBA
code
to get my application to work. I'm concerned if I rename all of the linked
tables I may run into problems down the road

I am not new to SQL server or Access, just Access 2007. When I try to access
the SQL tables when linking it shows each table name to be prefaced with
'dbo_ ' in the access view. When creating an adp file it strips that off in
the access view. All of the code/queries I have written in the adp version do
not have the dbo_ preface so either I would have to rewrite all of my code or
rename the links to the SQL tables. It seems as though it would be easier to
just leave everything in the adp. I don't know of any way to link the tables
to SQL without the dbo_ preface.

"Sylvain Lafontaine" wrote:

ADPs are supported under Access 2007 but only with the older format
2002-2003; hence your result.

If you are new to SQL-Server, using an ACCDB file (or the older MDB format
if you want a wider compatilibity) with ODBC linked tables to SQL-Server is
probably a much safer/easier bet to go.

I'm not to sure about your description of the problem with dbo. because I
don't know where you seeing them: on the SQL-Server or locally on the ACCDB
file, after the linked process? Don't be too concerned with renaming the
tables issue, it's only the schema (or the owner if you are under SQL-2000
instead of 2005/8) of the tables.

Finally, if you want to work against SQL-Server, you should get a good book
and learn more about it.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"SuzanneH" wrote in message
...
I have an access 2003 adp which works fine in Access 2007. Do I need to
convert it to Access 2007. When I create a blank adp file in Access 2007
it
appears to be created in Access 2002-2003. Is this because adp files are
not
supported in Access 2007?

If I create an accdb file and link to the SQL server tables I need the
table
names are all prefaced with dbo. which means I have to change all my VBA
code
to get my application to work. I'm concerned if I rename all of the linked
tables I may run into problems down the road

On Aug 22, 11:46*am, SuzanneH
wrote:
I am not new to SQL server orAccess, justAccess2007. When I try toaccess
the SQL tables when linking it shows each table name to be prefaced with
'dbo_ ' in theaccessview. When creating anadpfileit strips that off in
theaccessview. All of the code/queries I have written in theadpversion do
not have the dbo_ preface so either I would have to rewrite all of my code or
rename the links to the SQL tables. It seems as though it would be easier to
just leave everything in theadp. I don't know of any way to link the tables
to SQL without the dbo_ preface.



"Sylvain Lafontaine" wrote:
ADPs are supported underAccess2007but only with the older format
2002-2003; hence your result.

If you are new to SQL-Server, using an ACCDBfile(or the older MDB format
if you want a wider compatilibity) with ODBC linked tables to SQL-Server is
probably a much safer/easier bet to go.

I'm not to sure about your description of the problem with dbo. because I
don't know where you seeing them: on the SQL-Server or locally on the ACCDB
file, after the linked process? *Don't be too concerned with renaming the
tables issue, it's only the schema (or the owner if you are under SQL-2000
instead of 2005/8) of the tables.

Finally, if you want to work against SQL-Server, you should get a good book
and learn more about it.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

"SuzanneH" wrote in message
...
I have anaccess2003adpwhich works fine inAccess2007. Do I need to
convert it toAccess2007. When I create a blankadpfileinAccess2007
it
appears to be created inAccess2002-2003. Is this becauseadpfiles are
not
supported inAccess2007?

If I create an accdbfileand link to the SQL server tables I need the
table
names are all prefaced with dbo. which means I have to change all my VBA
code
to get my application to work. I'm concerned if I rename all of the linked
tables I may run into problems down the road- Hide quoted text -

- Show quoted text -

the dbo prefix is the owner of the tables on SQL server and Access
adds them to help make sure that the table names are unique when
linking tables from a particular server. just rename the tables and
remove the dbo_ from the name. you code should run fine.