Access2007 in Sharepoint

[casper]

If i put an access2007 mdb on sharepoint, does everyone has to have the same
version of access to use the mdb?

 

[Ron2006]

If i put an access2007 mdb on sharepoint, does everyone has to have the same
version of access to use the mdb?

My impression is not really. or at least not if you don't want a
frequently corruped database.

Access can look at and access and link to sharepoint tables/views
HOWEVER I have found it to be horribly slow. I have written a couple
of apps that pulled info from sharepoint and the best way was to
simply append the sharepoint view into a local/linked table and use
the copy for what I needed it for. It was too slow if I tried to do
what I needed with the actual sharepoint view.

Ron

 

[Ron2006]

My impression is not really. or at least not if you don't want a
frequently corruped database.

Access can look at and access and link to sharepoint tables/views
HOWEVER I have found it to be horribly slow. I have written a couple
of apps that pulled info from sharepoint and the best way was to
simply append the sharepoint view into a local/linked table and use
the copy for what I needed it for. It was too slow if I tried to do
what I needed with the actual sharepoint view.

Ron

addendum. The above is using Access 2003. I do not have 2007 and have
seen nothing relative to that topic.

 

[casper]

Ron,
I totally agree and assume that it will totally slow down the performance if
I perform any linking into sharepoint data, but what if i upload the entire
mdb file up onto sharepoint would it matter which version of access the user
has on their local machine to access the db? How does it exactly work? Would
forms be viewed as web pages or the client will be temporarily be given a
copy per say onto their local hard drive and when ready to save it uploads
the data back into sharepoint.. you know somewhat like a regular word
document saved? i don't know maybe if you can recommend some documentation
out there that will help me integrate Access2007 into sharepoint, etc. would
be good start.

Thank you in advance..

 

[David W. Fenton]

what if i upload the entire
mdb file up onto sharepoint would it matter which version of
access the user has on their local machine to access the db?

I don't know that Sharepoint offers any methods for accessing an MDB
stored on it, regardless of the version of Access.

 

[Ron2006]

I don't know that Sharepoint offers any methods for accessing an MDB
stored on it, regardless of the version of Access.

I believe that David is correct.

Regardless of that, Access is Access. Nothing is going to magically
convert the forms to web pages.- at least not in current versions of
either. And it would matter what versions if it could access the mdb.
Files are not changed because they are on a sharepoint "Drive". An
Access 97 mdb is still be an access 97 mdb just like a word doc would
still be whatever version created it until it was opened and modified
by a later version and at that point earlier versions of word would
probably have a tough time with it.

Ron