General :: Delete File From FTP Server

Nov 2, 2014

I need deleting a file from a ftp server. I have the code for uploading but I can't seem to figure out how to delete a file. This is the FTP module I'm using

Code:

Public Sub UploadFileToFTPServer()
On Error GoTo ErrHandler
Dim lngRet As Long
Dim abytData() As Long
Dim lngBytesWritten As Long

[Code] ....

And this is the code for uploading i use in the form when i click a button

Code:
Dim objFTP As FTP
Const conTARGET = "ftpserver"
Set objFTP = New FTP
With objFTP

[Code] ....

All that works like a charm.

Code to delete a file from the ftp server, i'm kind of stuck.

View Replies


ADVERTISEMENT

Modules & VBA :: How To Delete File On Http Server

Sep 13, 2013

This is a follow-on to my post here: [URL]....

How can I change the code to delete the file if it exists?

View 1 Replies View Related

General :: Save A File To A Specific Folder On Server

Feb 23, 2013

We have a server that we use to run a Microsoft Access application. This application creates folders, subfolders and files on the server.Users are in 4 different offices. Each office has at least 3 computers. Some users also work from home.

Users creates file through word, or scanning a document or by saving an email on their local pc.My problem is that users need to be able to save a file to a specific folder on server.

View 1 Replies View Related

Does File Server Hosting Back-end Mdb File Need To Have Access

Nov 15, 2013

I'm experimenting with MS Access, and I've successfully split an MDB someone created into two files. I can access the database from 2 computers at once using the front end file connecting to a file server which hosts the _be.mdb file.

Could the _be.mdb file theoretically be on a NAS without any computer attached, or is there some runtime or full version of Access that needs to run on the machine with the back end file?

View 2 Replies View Related

How To Get Full Permission:Add, Delete, Update, Edit In The SQL Server Database

Jul 26, 2007

I wrote the following statements to update a SQL server database:

Dim MyDb As Database
Dim MyRs As Recordset

Set MyDb = DBEngine.Workspaces(0).OpenDatabase("AMD", dbDriverPrompt, False, "ODBC;DATABASE=AMD;DSN=Remote")


Set MyRs = MyDb.OpenRecordset("SELECT AllAttendanceEvents.* FROM AllAttendanceEvents ORDER BY AllAttendanceEvents.EntryTime DESC")

MyRs.MoveFirst

While Not MyRs.EOF
MyVal = MyRs!EntryTime
Debug.Print MyVal
MyRs.Edit
MyRs!Ix = 50099
MyRs.Update
MyRs.MoveNext
Wend

When it execute the red line statement, it generates the error:Cannot update. Database or object is read-only.

This error is generated isnpite that I already checked the boxes: SELECT, INSERT, UPDATE, DELETE in the Permissions page of the tables?

Please advise.

View 3 Replies View Related

Security Leak With Access File On Server

Jun 13, 2005

I have just started working with a team on a database that is available to everyone in this office. We have tried to lock it out and assign permissions by using workgroups, running security wizard, giving users no permissions, and deleting the Admin user, however none of this has sealed the database. The workgroup file is seperate folder on the server and the shortcut we make people use links to that workgroup. However Access is still defaulting to seperate workgroups on users personal computers. Is there anyway we can prevent this? Thanks.

View 14 Replies View Related

Modules & VBA :: Check If File Exist On HTTP Server

Sep 13, 2013

I found and modified this code to allow me to check (fast) if a file exist on a http server or not (without downloading it).

Code:
Public Function CheckNetFile(WebFile As String)
Dim XmlHttpReq As Object
Set XmlHttpReq = CreateObject("Microsoft.XMLHTTP")
XmlHttpReq.Open "HEAD", WebFile, False

[Code] ....

In the above code I managed to declare Webfile as a string so I can call on it later but one thing I still need to tweak is to also get a result out of the test code in a better way than having to publically declare the "CheckNet" variable somewhere else in my app.

First prize would something like this:

If CheckNetFile ("http://www.mysite.co.za/test/test.txt") = 1 then "Yes" else "No"

How do I build the 'booleon check' into the original function?

View 5 Replies View Related

Hosting The Access File On A Server And Having Multiple Remote Users

Jun 4, 2007

I am making a database to coordinate the activities of my band (how rock and roll!)...

Is there a way I can somehow host the file remotely, and have users (4 total) access that file through their own computer using access, so they can write, edit, delete records?

We have a db at my work that we use like this, accessing from multiple computers, though this is on a network drive.

View 2 Replies View Related

Modules & VBA :: Copy Excel File Or A Table In Access To Specific Location On FTP Server

Jul 11, 2013

I need some simple code that will copy an Excel file or a table in Access to a specific location on an FTP server. I would think this would be a very simple task, but I have yet to find any sample code that is *simple*. I have seen lots of code that requires downloading this dll or that mda, but the examples don't work. There must be something built into MS Access 2010 that will allow a file to be uploaded to an FTP site.

All the variables are known:

The FTP location (it never changes)
The FTP Username and Password (they never change)
The destination folder on the FTP site (it never changes)
The File type (it never changes)
The File name (available from the form in Access from which this will be executed)

I can either produce an output file, then copy it to the FTP site, or I can export the table directly to the FTP site with the file name for that day.

This seems to be a very simple task with no simple solution. Currently I am using an FTP app to get the file to the FTP site, but I would like to automate this. The process that creates the output file is already automated, so I would just like to add this to the existing code as its own module.

I'm looking for a simple command on the idea of:

DoCmd.FTPFile, acExel, TableName, FTPFilePath, FTPFileName, Username, Password, acUpload

just made all that above up and none of it is a real function/command in VBA, but is just the kind of thing I'm looking for.

I would think that since I can download and XML file from an FTP site that it should be child's play to upload a simple file to an FTP site, but I can't figure it out.

View 8 Replies View Related

Delete File Based On Query.

May 2, 2005

Ok, I have kind of a confusing thing.

Every employee has an ID, and a start date.

Some employees have pictures (stored in a folder).

When someone is terminated, the picture does not get erased (as it shoud).

So, I need to run a query that deletes any pictures older than the start date of the employee.

Any help on this? Not sure where to begin. I suppose I should create a query with employees who have pictures. But how do I compare a files date to an entry in a table?



Example table:


ID Emp Start File
101 John Smith 5/1/2005 \file_serveremppic101.jpg

View 5 Replies View Related

Delete User Information In System.mdw File?

Jun 15, 2006

Is it possible to delete user information in workgroup information (System.mdw) file from command line or programmatically?

Thanks

View 1 Replies View Related

General :: Duplicate Back End On Different Server

Feb 22, 2013

We have offices in other states that need to be able to open our data base. Due to the line speed it is extremely slow linking to our backend. Is it possible to have duplicate backends that can be merged, lets say over night or at the push of a button.

View 5 Replies View Related

General :: Database Size On Server

Oct 22, 2013

I have a database (Access 2003 and I am using it with Access 2007 with user level security) on shared folder on internal Dell server and I have created a shortcut to each user's machine to access it. This days I am facing a problem of db size as every 10 days it's increasing upto 2gb but the strange thing is when I am doing cut / pasting same database to my desktop from the server shared folder it will become 80 mb only and I am again placing that db (80mb db) into the server and it will work. What is a reason behind it? why my 80mb db is showing 2gb db on server?

View 1 Replies View Related

General :: Linking SQL Server Tables

Aug 28, 2012

I want to work on SQL Server tables located at my work place at home using Access. My question is; is it possible to link SQL Server tables on a server to my lap top computer using "Remote Desktop" or will I need to install Access onto the server and if tables can be linked using Remote Desktop how do I link them? I am using Access 2010 and have Windows 7 professional installed on my lap top.

View 3 Replies View Related

General :: Find If A Network Server Is On

Jun 20, 2012

My DB is split into BE and FE into about 5 Laptops. The DB is for entering personal information of pensioners.

sometimes it becomes necessary to take a computer away from the office to capture data of sick and aged pensioners. Now if you take the server (BE) out all the other clients (FE) will not work, and if you take a client out it wont work.

To solve the issue I decided to install a standalone version of the db in all the clients. If out of the network, the standalone DB is used and later captured data to betransfered to the server.

My question: Is there a code that I can use to check if my server is available to start the FE or if unavailable to start the standalone?

View 8 Replies View Related

General :: SQL Server Not In Dropdown When Linking

Sep 18, 2013

I have a windows 7 machine with Access 2000 installed. I need to link to some tables on an SQL server and "SQL Server" does not appear in the dropdown of available link types. I think a driver is missing. I did a clean install of Office 2000 and only selected MS Access. Maybe that prevented everything needed from being installed. I would like to add just the missing driver if possible.

View 1 Replies View Related

Modules & VBA :: Deleting Record And Then Delete Listed File?

Jan 7, 2015

What is the correct syntax that would delete a file when the record is deleted. The file's path is listed in a record field, MailLocation. Every time I try this code, I receive an error!

I've tried the below, and number of iterations, including calling the killfile differently (me![MailLocation], me.MailLocation).

Code:
Private Sub Form_AfterDelConfirm(Status As Integer)
Dim KillFile As String
KillFile = me!MailLocation
Kill KillFile
End Sub

View 6 Replies View Related

General :: Mail Merge Word File (using Data From Access File)

Mar 11, 2014

I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.

Please download the attached file !

If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.

Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.

Secondly, I click 'Insert Word Field' -> select 'Next Record'.

In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.

View 3 Replies View Related

General :: Forms And Queries In One ACCDB File - Path Setting To Linked Table File

Oct 5, 2014

I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:acc_tables and thats where i browsed to (obviously) when i set up the linkage.

One of the users does not wish (for whatever goddamn reason) to create a C:acc_tables file to stick the tables file in , and wants the tables file in some other folder.. Unfortunately this user does not have the skills to delete the existing links and re-link to the tables file after putting it in the folder he wants.

Where in the file that holds the forms and and queries do i find the path setting to the tables linked file? Can it be changed without deleting links and then re-linking?

View 4 Replies View Related

General :: How To Split Database And Upload To Server

Dec 11, 2012

I am new in database design . I did a database by access 2010 which contain form and tables and i want to split it to backend and frontend and then make then in website

I need step in detalis to do that

How to split

How to put the backend on my site

How to make frontend in site

View 1 Replies View Related

General :: Transmit / Receive XML From Access To Server

Jun 2, 2015

Any good program which will act as a B2B type gateway for MS access.

We currently have an access database which collects data and photographs of audits. This database is currently local and sends/receives data only whilst in the office. Ideally we'd like to do this over the internet by sending/receiving XML messages and somehow also photographs.

View 4 Replies View Related

General :: Backend Server Name Path Length

Jul 16, 2014

I've always practiced to keep my backend table names to no more than 8 characters because of speed issues. Can this also goes for the server name? My current location looks like this now orld71-testing-aFinance..I am wondering if changing the server name with speed or is that only for folder names.

View 5 Replies View Related

General :: Unable To Transfer To Online Server

Apr 19, 2014

I have a MDB file that I am unable to transfer to my online server (I get a 'critical transfer error' message. I am, however, able to upload other MS Access databases to the same server using the same FTP software.This points to a problem either with this particular database itself or my ASP code.

I have six fields, all text fields, with simple named columns (such as username, password, etc). In Design View.

View 4 Replies View Related

General :: Split Database Access FE And SQL Server BE

Mar 4, 2014

I am currently working on an application where I am using MS access as my FE and working with linked tables to SQL server BE. I also have a few temp tables within Access that are not linked but needed.

1. What are my steps into making this into a SPLIT DB? I am assume the BE will have my linked tables from SQL and the FE will have my temp tables and forms. Is this correct?
2. Once I split it, then I can make an .ACCDE file for a Mulit User environment, is this correct?

What other steps should I be made aware of?

View 8 Replies View Related

General :: Make Accdr File Out Of Accde File?

Sep 10, 2012

How do I make an accdr file out of an accde file?

View 9 Replies View Related

General :: Follow Hyperlink To A File Without Using File Extension?

Sep 6, 2012

Is it possible to follow a hyperlink to a file without using a file extension?

I have links being created based on the name of a file, but because I haven't used a file extension it crashes.

I know I can give the user a choice of what the file extension is and add it to the hyperlink, but it's an extra step, and another place for someone to make a mistake.

I'm potentially using 3 different file types, Word, Excel and PDF's.

The hyperlink works if I just reference a drive/folder, or if I add the file extension.

View 3 Replies View Related







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