Access 2003 adp file in Access 2007

[SuzanneH]

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

 

[Sylvain Lafontaine]

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.

 

[SuzanneH]

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.

 

[Ted Theo]

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 easierto
just leave everything in theadp. I don't know of any way to link the tables
to SQL without the dbo_ preface.








- 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.