473,320 Members | 1,951 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

I can not connect my access database to sharepoint site

2 Bit
Hi,

I can not connect my access database to share point site. I am using MS access 2007. Whenever I try to connect my database "Testdata" to share point site an error appears (Testdata could not connect to the site you specified. Verify the address of the site or contact your site administrator). Is there any other settings required in MS access file? Please give me solution.

Thanks in advance.

MoonNbl.
Dec 8 '21 #1
2 20921
NeoPa
32,556 Expert Mod 16PB
Hi Jimmy.

I'm confused. If the OP, as claimed, is unable to connect to their SharePoint site at all, how can they be expected to follow even your first instruction.

I don't want to put you off from offering your help, but possibly just to advise that there is much more importance involved in understanding the question clearly than perhaps you realise yet.

Welcome to Bytes.com.

You're a very new member and I can only applaud your intentions when I see you posting possible solutions. Don't be put off simply because your first attempts didn't necessarily go to plan.

Another thing I notice, that is to your credit, is that you post clearly such that anyone can follow the instructions easily.

I'm sure we'll be seeing more of you :-)

-Ade (Admin).
Jul 15 '22 #2
zmbd
5,501 Expert Mod 4TB
Goodmorning MoonNbl
Sorry I've been out of my normal routine the past few weeks
I have dozens of MSAccess frontends running from SharePoint lists so I'm quite familiar with the situation!

]1) An access database file (dot-ACCDB file) will not connect from within a SharePoint document library directly to the Access program, period, drop-the-mic. This sucks as other files such as Excel, Word, PowerPoint will at least open in the Office365 online environment. There is no analogous MSAccess Online program for the file to open to nor is there direct tunnel. I suspect that this is because MS wants us to move to the "cloud" and "power-platform" using their data-verse (whatever it's called today, it's had several names now :) )

]2) What Jimmywick is suggesting will convert the tables in an Access database to SharePoint lists - YOU WILL LOSE ALL TABLE RELATIONSHIPS and there are other issues that may occur with your tables once converted - especially if you have used those nasty little lookup fields at the table level (avoid these at the table level if you can!!)!

]3) You do NOT normally need VBA to transfer the tables to a SharePoint site:
Ribbon>External Data>Export>[More]>SharePoint
If greyed out then
Ribbon>Database Tools>Move Date>SharePoint
In fact, if neither of these are available, or doesn't work, then neither will any of the VBA code (I've been moving some of my databases into SharePoint and PowerApps/PowerAutomate - bit of a learning curve; however, the company isn't installing Access on our newer PCs - why, I don't know, I'm sure it's a licensing thing)

Please tell us a little more about what it is that you're trying to do so that I can help you get your project off the ground.
Please be patient, I'm still out on "walk-about" dealing with some family stuff so my replies will be a bit delayed...
-Z
Jul 21 '22 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Thomas Tsang | last post by:
I am using ASP + IIS + MS access, when running the following codes: set Conn=Server.CREATEOBJECT("ADODB.CONNECTION") conn.open "DRIVER={Microsoft Access Driver (*.mdb)}; " &...
7
by: vigneshwaran G via DotNetMonster.com | last post by:
Hi , I am trying ot connect a VB application to Access database. iam using the following connection string : con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;data source=c:\...
1
by: rajusonavane | last post by:
hi i m helpless on connect oracle or access database with xml programm plz give me sample code of program how to connect thanking you raju
0
by: sandeepl | last post by:
Hi i am trying to connect a Ms access database from Oracle 8i. but getting following error. Pls help me in the same.. ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle [ODBC...
0
by: rendanime | last post by:
Hi All I have designed an Access database and now i want to connect it with Delphi 5. Can anyone help?????
0
by: asad56 | last post by:
I am workin with a superstore managment project. I connect Access database with main form . Then it work properly. But now I connect same database with another table or field in another form which is...
2
9815402440
by: 9815402440 | last post by:
hi i want to connect access database which is on remote server (web server). can anybody please tell how to do this? thanx in advance. manpreet singh dhillon hoshiarpur
6
9815402440
by: 9815402440 | last post by:
hi i have a ms access database which is on web server (ftp://www.abc.com) . i want to connect this database using ado in vb6. please help regards manpreet singh dhillon hoshiarpur
0
by: JensenKragh | last post by:
Hi, I have a ms access report (and som forms) which display pictures by linking to their folder paths. These pictures are to be moved into a sharepoint site - how can I link or embed these...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.