Sharepoint Linked Table - Access 2003 to 2007 conversion

M

ma143hal

Hi!
I just inherited an Access 2003 database which has a linked table to
Sharepoint (dbo_...) without any problem. When you view the actual table
from Sharepoint it only has 5 fields, but in Access 2003 have 12 fields. It
gets updated without any issue.

We are in the process of converting to Access 2007 and the linked table is
different from Access 2003. Most of the columns are dropped. Would anyone
know how I can keep the same exact column layout (# of columns) as in 2003?
This is necessary, because in the code, the linked table updates the local
table. Also, we must leave as is, because some users will still be using
Access 2003 version.

Thanks in advance for your help.

Have a wonderful day!
 
O

o;;

ma143hal said:
Hi!
I just inherited an Access 2003 database which has a linked table to
Sharepoint (dbo_...) without any problem. When you view the actual table
from Sharepoint it only has 5 fields, but in Access 2003 have 12 fields.
It
gets updated without any issue.

We are in the process of converting to Access 2007 and the linked table is
different from Access 2003. Most of the columns are dropped. Would
anyone
know how I can keep the same exact column layout (# of columns) as in
2003?
This is necessary, because in the code, the linked table updates the local
table. Also, we must leave as is, because some users will still be using
Access 2003 version.

Thanks in advance for your help.

Have a wonderful day!
Click to expand...
 
O

o;;

ma143hal said:
Hi!
I just inherited an Access 2003 database which has a linked table to
Sharepoint (dbo_...) without any problem. When you view the actual table
from Sharepoint it only has 5 fields, but in Access 2003 have 12 fields.
It
gets updated without any issue.

We are in the process of converting to Access 2007 and the linked table is
different from Access 2003. Most of the columns are dropped. Would
anyone
know how I can keep the same exact column layout (# of columns) as in
2003?
This is necessary, because in the code, the linked table updates the local
table. Also, we must leave as is, because some users will still be using
Access 2003 version.

Thanks in advance for your help.

Have a wonderful day!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Access 2003 on client to see Sharepoint 2007 3
Linked Sharepoint Table 2
Conversion Access 2000 to 2007 11
Migrating from 2010 to 2013 - having issues: Exporting to xml 0
Append query for MS Access 2003 table linked to a Sharepoint listwith lookup fields 0
MS Access 2007 & SharePoint Performance 3
Sharepoint 2007 lookup field showing up as memo in Access 2003 4
Error 3001 in Access 2007 adding Attachment to linked Sharepoint t 0

Top