Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Microsoft Access


  • Please log in to reply

#1
SpaceCowboy706

SpaceCowboy706

    Trusted Tech

  • Member
  • PipPipPipPip
  • 1,175 posts
I am trying to figure out how to access a database on a FTP server that requires a username and password while using only microsoft access.

The files that are on the database are in a .mdb file format which is what access uses.

Currently I can connect to the ftp server and view the .mdb files using a cruddy third party vendor software that has no options for reports or sorting (which happens to be why i need to figure out how to connect to the server with Access).

I know all of the information such as the ip address, username, password, port etc.... that is required to connect.... i just dont know "how to connect" using Access. Any help would be appreciated.

PS.
I have been granted access to the ftp server with a admin levell username and password, so this isnt some plea for a hack or something.
  • 0

Advertisements


#2
SpaceCowboy706

SpaceCowboy706

    Trusted Tech

  • Topic Starter
  • Member
  • PipPipPipPip
  • 1,175 posts
Nevermind I figured it out.

If interested here is how:

Open Access
click on file - then open - in the open box under "Look In" click the drop down menu and select "Add/Modify FTP Locations"
In the "Name of FTP Site" field just enter in the IP Address of the server, then fill in the username and password and click OK
Once done double click on the FTP site in the "FTP Sites box and WALLLAH im connected

Sorry to take up space in here
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP