Solved

Connecting / Linking to a database on the web

Posted on 2006-06-26
8
240 Views
Last Modified: 2008-02-01
I want to import or link to tables on a MS Access database on a web server.

I have ftp access to that server.

I choose File, Get External Data, Link Tables. I have previously established the ftp location in the folder "ftp locations. I go there & navigate to the Access database on the web server.

When I click link, it says "Not a valid file name". The file name is Calendar.mdb and IS a valid MS Access database.

What am I doing wrong?

Thanks,

rkorts
0
Comment
Question by:Richard Korts
  • 4
  • 3
8 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 500 total points
Comment Utility
I didnt think u could do that
I thought it had to be a valid path, either local or network

0
 

Author Comment

by:Richard Korts
Comment Utility
To rockiroads:

Then why does Access give you the ability to establish an ftp connection (the connection DOES work) and the ability to browse the folder structure on the web server just as if it were on the local machine?

rkorts
0
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
like I said, "I didnt think u could do that"
Ive not heard of anyone trying this hence my statement

I assume its "Windows Sharepoint Server"

0
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
ok, reading this
http://office.microsoft.com/en-us/assistance/HA010714971033.aspx

it says

Importing, exporting, and linking to a Microsoft Windows SharePoint™ Services list from Access   Export the contents of a table or a query to a Windows SharePoint Services list, import the contents of a Windows SharePoint Services list into a table, and link a table to a Windows SharePoint Services list.


Exporting and linking to Access data from Windows SharePoint Services   Export a list in its Datasheet view from Windows SharePoint Services to a static table or to a linked table in Access. When you export to a static table, you create a table in Access. You can then view and make changes to the table independent of the original list in Windows SharePoint Services. Similarly, you can change the list in Windows SharePoint Services, and that will not affect the table in Access. When you export to a linked table, you create a table in Access and establish a dynamic link between the table and the list such that changes to the table are reflected in the list, and changes to the list are reflected in the table as well


So I guess its the 2nd part
Have u tried connecting as http://
This is just as a test, not a workaround
Its to prove whether it works as http or not

0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

Author Comment

by:Richard Korts
Comment Utility
To rockiroads

Are you saying that it only works if the web server is a
"Windows Sharepoint Server"?

In that case, I'm out of luck. It's a linux machine.
0
 
LVL 65

Expert Comment

by:rockiroads
Comment Utility
I dont know. I am only going by the options I saw. I mean there could be another way, I dont know of any. Sorry


0
 

Author Comment

by:Richard Korts
Comment Utility
To rockiroads,

I will leave the question open for a while to see if anyone else answers.

0
 
LVL 44

Expert Comment

by:Leigh Purvis
Comment Utility
I also don't think you can do this.
I wouldn't expect a link over an FTP connection to work at all.

If (somehow :-S) you were able to set up a VPN then it might be possible.
But I know of databases that have used an ADSL connection over a WAN and the performance has been shocking!

I don't think you'd get anything useable.

The obvious (and very normal) suggestions are to use ASP pages to view/update the data - or use Terminal Services.
However if this is an ISP web server - they'll not have TS or even Access set up for you.

Web pages are your best bet I'd say.
As even if you managed to get a connection which Access was happy about (being able to browse is very different to a workable link) I'd imagine performance would be terrible.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now