Sharepoint 2007 Surveys - link to Access 2003?

M

MacNut2004

Hello,

Can survey data either be exported or linked to an Access 2003 Database?

Thank you!
MN
 
A

Alex Dybenko

Hi,
you can certainly link 2003 and 2003 versions, as well as 2007-2007, but not
100% sure about 2003 and 2007. If you have SharePoint 2007 around - you can
try - menu file-get external data-import or link

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
M

MacNut2004

Hi,

Where and how do I attempt to do this? I've never tried linking to
sharepoint before. Do I go in there via Access? If so....how do I point to
my sharepoint survey? (Do i need to do something to that survey in
sharepoint first?)

Thanks!
MN
 
M

MacNut2004

Thanks Alex. I tried doing this and I got the following error message:

"The site you specified does not support importing data to a [name of my
database] database. The site must be running Windows SharePoint Services
from Microsoft."

What does this mean?

Thanks,
MN
 
A

Alex Dybenko

Hi,
then looks like Access 2003 does not read SharePoint 2007. Let me ask other
guys, will come back to you

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

MacNut2004 said:
Thanks Alex. I tried doing this and I got the following error message:

"The site you specified does not support importing data to a [name of my
database] database. The site must be running Windows SharePoint Services
from Microsoft."

What does this mean?

Thanks,
MN

Alex Dybenko said:
menu file-get external data-import or link, select Windows Sharepoint
services, then enter sharepoint server address, and then you will get a
list
of available tables to link, your survey should be there

look also here:
http://office.microsoft.com/en-us/access/HP010192421033.aspx

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
Click to expand...
Click to expand...
 
A

Alex Dybenko

Hi again!
It was confirmed:
I just linked to a SharePoint 2007 list from a new Access 2003 database. I
then created a form and edited one of the records. I can see the changed
value after refreshing the SharePoint page.
Click to expand...

so make sure that you have connection to SharePoint and entered correct
address

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


MacNut2004 said:
Thanks Alex. I tried doing this and I got the following error message:

"The site you specified does not support importing data to a [name of my
database] database. The site must be running Windows SharePoint Services
from Microsoft."

What does this mean?

Thanks,
MN

Alex Dybenko said:
menu file-get external data-import or link, select Windows Sharepoint
services, then enter sharepoint server address, and then you will get a
list
of available tables to link, your survey should be there

look also here:
http://office.microsoft.com/en-us/access/HP010192421033.aspx

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
Click to expand...
Click to expand...
 
M

MacNut2004

Hi!

I tried again, this time from a blank database. Does it matter if the
sharepoint site is "https" and not "http" ? Because it's still giving me
the same error. :(

Thanks

Alex Dybenko said:
Hi again!
It was confirmed:
I just linked to a SharePoint 2007 list from a new Access 2003 database. I
then created a form and edited one of the records. I can see the changed
value after refreshing the SharePoint page.
Click to expand...

so make sure that you have connection to SharePoint and entered correct
address

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


MacNut2004 said:
Thanks Alex. I tried doing this and I got the following error message:

"The site you specified does not support importing data to a [name of my
database] database. The site must be running Windows SharePoint Services
from Microsoft."

What does this mean?

Thanks,
MN

Alex Dybenko said:
menu file-get external data-import or link, select Windows Sharepoint
services, then enter sharepoint server address, and then you will get a
list
of available tables to link, your survey should be there

look also here:
http://office.microsoft.com/en-us/access/HP010192421033.aspx

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com



Hi,

Where and how do I attempt to do this? I've never tried linking to
sharepoint before. Do I go in there via Access? If so....how do I
point
to
my sharepoint survey? (Do i need to do something to that survey in
sharepoint first?)

Thanks!
MN

:

Hi,
you can certainly link 2003 and 2003 versions, as well as 2007-2007,
but
not
100% sure about 2003 and 2007. If you have SharePoint 2007 around -
you
can
try - menu file-get external data-import or link

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

Hello,

Can survey data either be exported or linked to an Access 2003
Database?

Thank you!
MN
Click to expand...
Click to expand...
Click to expand...
 
A

Alex Dybenko

Hi,
can you connect to it via internet browser? address should be the same

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

MacNut2004 said:
Hi!

I tried again, this time from a blank database. Does it matter if the
sharepoint site is "https" and not "http" ? Because it's still giving me
the same error. :(

Thanks

Alex Dybenko said:
Hi again!
It was confirmed:
I just linked to a SharePoint 2007 list from a new Access 2003
database. I
then created a form and edited one of the records. I can see the
changed
value after refreshing the SharePoint page.
Click to expand...

so make sure that you have connection to SharePoint and entered correct
address

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


MacNut2004 said:
Thanks Alex. I tried doing this and I got the following error message:

"The site you specified does not support importing data to a [name of
my
database] database. The site must be running Windows SharePoint
Services
from Microsoft."

What does this mean?

Thanks,
MN

:

menu file-get external data-import or link, select Windows Sharepoint
services, then enter sharepoint server address, and then you will get
a
list
of available tables to link, your survey should be there

look also here:
http://office.microsoft.com/en-us/access/HP010192421033.aspx

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com



Hi,

Where and how do I attempt to do this? I've never tried linking to
sharepoint before. Do I go in there via Access? If so....how do I
point
to
my sharepoint survey? (Do i need to do something to that survey in
sharepoint first?)

Thanks!
MN

:

Hi,
you can certainly link 2003 and 2003 versions, as well as
2007-2007,
but
not
100% sure about 2003 and 2007. If you have SharePoint 2007 around -
you
can
try - menu file-get external data-import or link

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

message
Hello,

Can survey data either be exported or linked to an Access 2003
Database?

Thank you!
MN
Click to expand...
Click to expand...
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

No option to create a list in SharePoint Site 0
Mail merge hyperlink wrong results 0
Overflow Error 6
Access 2007 and Sharepoint Surveys 0
Access Query to import from Sharepoint 0
Access 2007 and Sharepoint 2007 Survey Lists 0
Survey Data 0
Create survey 1

Top