Linking Data in MS-Access

Forums › IT Pro and developers › Linking Data in MS-Access

ashokjain

4 posts

Wannabe Geek

Topic # 17339 22-Nov-2007 01:59

This is Ashok jain currently working on small Ms-Access project and i am a learner

i got used to splitting the database and using the front end and backend (Datas) in seperate locations in the same desktop system

now i am trying to link the data from my FTP location from my desktop system which has the forms which acts as the front end.
i have uploaded the splitted database on my ftp server too and when i try to link my forms to the data on the ftp location it says "Invalid File Name" and i was not able to link the data to my desktop system.
for your kind information.. i ahven't changed the name of the database which is present on my local system and also uploaded datas on my FTP location

can anyone help me how to link the data on my ftp server from the Access forms which are on my local system and how can i eradicate this error

await to hear back from the GURUS of Ms-Access to help this rookiee

from:Jain

freitasm

BDFL - Memuneh
63017 posts

Uber Geek
+1 received by user: 13593

Administrator

Trusted

Geekzone

Lifetime subscriber

Reply # 96323 22-Nov-2007 07:30

FTP is not a file system - it's used to transfer files from one location to another so you can't use it for accessing a MS Access database.

Your only choice is using a File Share on this server.

Backblaze cloud backup (personal and business) | Geekzone broadband switch | Amazon (Geekzone aff) | MightyApe (Geekzone aff) |

My technology disclosure | Business Transformation | Enterprise Content Management | Customer Relationship Management | Sharesies investment fund

stevonz

397 posts

Ultimate Geek

Trusted

Reply # 96327 22-Nov-2007 08:11

The Scripts.com is a good source of MS Access info, trust me I used it plenty this year!

Good luck

Cheers, Stevo

ashokjain

4 posts

Wannabe Geek

Reply # 96429 22-Nov-2007 17:45

Thanks for the information and the time taken to write to help a rookie

ashokjain

4 posts

Wannabe Geek

Reply # 96430 22-Nov-2007 17:45

Thanks for the information and the time taken to write to help a rookie

ashokjain

4 posts

Wannabe Geek

Reply # 96432 22-Nov-2007 17:48

Thanks for you ... is their any way of linking the database which resides on the internet say i have my site which has the database and i want it to connect to it from my access database to ge the sources of data from that databse on the net..

is thair any way how can i fetch the datas from the databse from my site

would liek to get your tips on the same...

from:Jain