Linking Access To Internet Without SharePoint?

Aug 7, 2015

I currently utilize my company's LAN structure to run my Access database from. The LAN structure is abhorrently slow. So slow that often the database crashes upon opening or can take many minutes to complete a menial command.

I realize that connecting my database to the internet would be a better solution (as our internet connection seems to work better). This would allow many users to interact with the database more easily as well. I also realize that SharePoint is the standard method of connecting the database either by linking tables or publishing the database itself. However, my company does not have SharePoint and I am tired of battling with them on obtaining it.

Is there another way to connect/link Access tables to the internet without SharePoint? One that is FREE. I know with Access 2003 you could connect Access to an HTML webpage, but I think Microsoft got rid of that functionality with 2010 and beyond to force users into utilizing SharePoint.

View Replies


ADVERTISEMENT

Linking Two Access Databases In Sharepoint

Aug 22, 2012

I currently have two Access Databases (one with the raw 'data' and the other with the queries and reports that turn it into 'information' - the data database links into the other).

For contingency purposes, I now want to move both Databases onto sharepoint in case I have a system failure on my laptop (I don't have a server I can put these on). When I upload these onto Sharepoint the second database still seems to link to the file on my computer..

Is there a way I can get a Database to link into another database that's held on sharepoint?

View 1 Replies View Related

General :: Linking Of Excel Sheets In SharePoint Directly To MS Access

Nov 4, 2013

I have a number of Excel spreadsheets (data sources) hosted on Sharepoint that I need to link to one single Access database.

At first. I cannot link the spreadsheets directly to Access because Access cannot read the spreadsheets on SharePoint to make the links.

Secondly, I can export the spreadsheets from SharePoint to a local folder on my PC and keep them 'refreshed'. The problem with this is that I cannot link Access to the local refreshed spreadsheets because of the (auto) extention .iqy. Access does not know the extention .iqy and hence the two cannot be linked at all.

Thus: How do I link an Excel spreadsheet hosted on SharePoint to MS Access.

View 3 Replies View Related

Access And Sharepoint

Jun 18, 2007

Apologies if this sounds vague , but I have developed a number of reports for an sql database which have selection criteria in certain forms. nothing too sophisticated . The company wants to increase the availability of the reports and the selection forms. Unfortunately Access on everyones PC is not part of the plan.
The concensus in the IT team is that Sharepoint is the route.

Does anyone know what would be required (in the way of programs , expertise etc) to convert or adapt an access database so that the forms and subsequent reports would be available sharepont.

I have had a dig around and I am not sure that our IT boys have got the full picture, I think that Sharepoint is dependent on access but I am not certain.

View 14 Replies View Related

Getting Access On To The Internet??

Mar 14, 2008

I have created an access database for work. Due to the size(70MB) of the database our internal network appears to have difficulty executing any queries or has long delays. I dont think the size is the issue, however I am now looking for ways to place on "internet" page but only want users to run the reports off control buttons /macros of the forms view not see the tables or query design. Any suggestions of best to approach this, Also any input about "project" or "ADP" woud, be very useful, thanks Andy

View 1 Replies View Related

Publish Access To Web Without SharePoint?

Jan 21, 2012

Access to Web. Is it possible to publish access to web without SharePoint?

View 4 Replies View Related

Hosting Access On Sharepoint

Jun 12, 2015

I would like to publish my access file in sharepoint but I know very little about sharepoint and how to attain a free or testing or trial account. Essentially I would like others to access and edit the file on the web simultaneously.

All youtube sites speaks to how to get started using sharepoint but always assuming that you already have access but this is not my case. I need to know how to acquire sharepoint.

On my computer there is a sharepoint application which I installed but it seems to have no purpose.

View 11 Replies View Related

Access Database In The Internet

Mar 21, 2007

Does anybody knows how I can have an access database in the internet?

Please let me know.

View 1 Replies View Related

Can I Publish A Access/SQL Application On SharePoint

Feb 4, 2008

I have a Access - front end / SQL Server - back end application. I use an ODBC connection. I want to publish this on share point. The users have a windows account but they are not on the network. I can not create an ODBC connection for them. There is any way they can use this application?
Can I connect in different way to SQL?

Any help will be appreciaied. Thanks,
Mary

View 1 Replies View Related

Open The Internet Explorer From Access

Mar 22, 2006

I want to open the internet explorer from access

but with url

for example

dim strUrl as string
strUrl = "http://www.google.com"

'here I want to open the explorer with the strUrl

thanks!

View 4 Replies View Related

Can You Pull Data From The Internet Into Access?

Oct 17, 2004

I would like to know if Access can pull data and information from specific websites automatically without me having to enter the data myself each day.

View 6 Replies View Related

Windows Sharepoint Compared To Microsoft Access

May 4, 2007

Does anyone know the main differences of using Windows Sharepoint to share data compared with Access?

View 8 Replies View Related

General :: Reorder Records In A Sharepoint Access Database

Jun 8, 2015

I have an Access Database published as an app in my SharePoint.

When launch the app my records are shown in a form in ascending order. How can I have them displayed in descending order?

View 1 Replies View Related

General :: Disable SharePoint Access Setting Option For Certain User

Oct 3, 2014

I just published an access database to sharepoint. However, after I set some user as contributor, those users can see structure of my database, and export tables to excel directly. Is there anyway that we can remove the access to "Setting"?

View 2 Replies View Related

Queries :: Access Web 2010 - Accessing Sharepoint Author And Modifier?

Mar 1, 2015

We're running an Access 2010 web database.

As expected when we published to Sharepoint additional fields were added to the Access tables [App Created By] and [App Modified by]. We want to use these fields for Audit information however they are always empty. How should they be populated?

View 3 Replies View Related

Publish Access Database With Windows Internet Information Services?

Mar 18, 2015

How to publish an Access db with Windows IIS but without Sharepoint

View 1 Replies View Related

Splitting Access Database - Upload Back End Portion To SharePoint Site

May 12, 2015

I am attempting to split my Access Database and will upload the back-end portion to a SharePoint site. No matter what I do, I continue to get a "Not a valid file name" error.

View 1 Replies View Related

Tables :: Date / Time Field In Access 2010 Modified In Sharepoint List

Dec 2, 2013

I have a table in my Access 2010 Database with few date/time fields. I have set different formats like Short Time, Medium Time etc. But when I link this table to Sharepoint list, all the date/time fields have been modified to their default format (General Date).

Is there a way we can keep the formats as such even after linked to Sharepoint list? If not, is there a workaround?

View 2 Replies View Related

Db On Internet

Jun 7, 2006

I have a database which is being used for maintaining documents status. Its working fine in stand alone PC. I want to share it on internet. But problem is, I can upload the complete file, then download and use. Its not updated.
So is there any way to upload this db onto internet and work there only the way we do in single PC?

View 2 Replies View Related

Microsoft SharePoint

Jan 22, 2007

I am running Windows Server 2003 for my company and require Microsoft SharePoint.

I've had a look on Microsoft.com but it confuses me with all kinds of stuff....

What do i need?

View 2 Replies View Related

Internet Database?

Jan 3, 2006

Hey, I am currently designing a database for my group of friends. Things such as ,Name, Age, Musical Instrument, Band (of which they play in), Favourite Band etc. would be in there indefinately.Its not a complex Db and so I was hoping to put it on my website but dont know how i would do this...I would like it to be on the internet as if you were just looking at it on your own computer and webmaster could edit any fields after it is finished. Is there anyway of doing this? If yes is there any way of doing this without the viewer having to download the Db?

Regards, Tommo

View 10 Replies View Related

Sending A Mdb File Via The Internet

Jul 27, 2005

Does anyone know what's the best way to send a mdb file via the internet. I've tried sending is as an email attachment and putting is on a webserver for downloading. Both wayes only gives errors.

View 1 Replies View Related

Internet Synchronization Error

May 23, 2007

I have an Access 2002 database (about 120mb) which was replicated using Replication Manager (version unknown). It is set up to use Internet Synchronization. We use it on state government LAN and WAN as well as the Internet. It works well in most cases, but on a few computers we get the error "Http address not found" when synchronization is attempted. The address is indeed visible to those computers. We have determined that reloading Windows (XP Pro) will usually solve the problem at least for a while but when GIS mapping software is installed it reappears. More worrisome is that some brand new laptops with factory-installed Windows are showing the same problem, which means it could get worse as we upgrade equipment.

Has anyone else encountered this error?

View 5 Replies View Related

Secure ODBC Over Internet

Apr 11, 2008

Hello All,

I was wondering if it is possible to connect a MS Access front end to a MS SQL server on the internet in a secure way through ODBC or some other means.
Anyone have any ideas?

Thanks.

View 1 Replies View Related

Transfer Data Over The Internet

Mar 28, 2005

Is it possible to transfer data over the internet if the BE is in one country and the FE is in another? If so, could someone explain how I would go about doing this? I'm in the Military and when we deploy it's normally to a far off country.

Thanks,
Scott

View 4 Replies View Related

Queries :: Run File Through Internet

Aug 29, 2013

I am having an access 2007 database, how to run this file through internet as me having website.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved