473,574 Members | 2,310 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

I can not connect my access database to sharepoint site

2 New Member
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 20959
NeoPa
32,564 Recognized Expert Moderator MVP
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 Recognized Expert Moderator Expert
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
3556
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)}; " & Server.MapPath("db.mdb") The following erorr is show: General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x508
7
18946
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:\ windows\desktop\ex1.mdb;Persist Security Info=False" it worked where the access file is in the local system but i want to access the datbase from anotehr...
1
5415
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
2005
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 name not found and no default driver specified (SQ ORA-02063: preceding 2 lines from ACCESS1.WORLD
0
1412
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
1961
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 child of main form not working. Main form stil working but when try to open child a message show as Please select a valid...
2
1855
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
5025
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
1178
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 pictures stored in the sharepoint site on my reports? BR Thomas
0
7747
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8093
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8262
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7843
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6498
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5643
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5331
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
1364
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1094
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.