General :: Files Can't Be Uploaded To External Host Server
Apr 1, 2014
We have an Access frontend with a Sql back end on an external server in the cloud.One of the things I need to do is allow people to attach files/documents to a record. I have set this up okay with the document being copied and saved to a new location and the path string being associated with the record. This will only work for people in my office though. I need to enable people in other cities to be able to upload or view these documents. Each office has their own server.
My IT department said they had created a VPN for this. They gave me a web URL which enables me to log in to QNAP. From there I can click to open the 'file station' and use the 'folder window' that appears within the browser to click through to the relevant folder - and there are buttons for uploading and downloading documents.
I could try writing some code that will automate all these steps - maybe. I'd rather not, but I can't see any alternative. It looks like a real pain to go through the HTML elements (and I think there may be errors coming up about certificates)
The files can't be uploaded to the external host server the back-end is on incase any of the documents are confidential. They don't want it saved anywhere other than on their own servers.
View Replies
ADVERTISEMENT
Sep 28, 2012
Using Dropbox to host a split database. Ulimately I would like to create a run version for users with the back end held in a drop box directory.
As an unsplit database everything is working fine on dropbox records are saved in a timely manner and great.
Once I split to FE /BE only some records are saved on the BE and some are dropped. Was getting conflicted copies of Back end but manged to stop this happening but the records were noit on either copy.
Gave each user their own FE (on a drop box directory) linking to a BE in a sub directory on the same dropbox.
The key issue is that not all users have access and I don't want them to get into code so want to aim towards a run version.
View 14 Replies
View Related
Mar 6, 2015
Is it possible for me to give them access to part or all of the database so that they can run queries to target venue mailshots etc if so how would i do this?Secondly my concern is that the database is valuable and I want to protect myself from potential theft of info, ie what stops them taking the database and using it for there own purposes?
View 2 Replies
View Related
Oct 29, 2006
hey all,
I would very much appreciate any help or ideas on how to do this as I am stumped.
I need to develop an access database to track documents but also link to them.
I’ll explain what it needs to do;
Every day there is a numbered (and titled) Word format document that is sent.
Most, but not all of the time an accompanying excel file is also sent. The excel file is used for updates to the word document of the same name.
Lets say the word document is titled DW101.1.doc and the Excel file is called DE101.1.xls
The first would signify it is a Word document by D (being short for Document) and W for Word.
The 2nd would be D for document and E for Excel, and then a number which is 101.1.
They are saved in a folder on the hard drive.
Each time these documents are recd then the Access Database is opened and info about those documents is entered. The document name, date, subject, number etc.
There will also be 3-4 fields that are also filled out with terms from the content of the document that could be searched by those 3-4 fields.
So as each document is recd, it’s opened and ‘scanned’ for relevant terms and or content.
That content is what will be filled in the search fields and then the subject will be the ‘main’ searchable item.
All this so far I can do with no problem.
It’s this part that’s making me crazy.
What I would really like to do is when the document(s) come in and are saved in the folder, from access you can open a dialog box, browse to that folder, and click in the file to associate it with the entry you are making for it in the database.
That way when a search is done with terms or words or subjects that match that document it will bring up the results of the search as a hyperlink that will open that document.
The people that will be using this are not very computer literate to say the least.
I could create a link to the document but I would have to be in design mode and it won’t show up as a record in a table.
Any ideas would be very much appreciated……………..
reb0101
View 3 Replies
View Related
Jul 7, 2005
Can you import from a .txt file on Notepad into an Access table or will it have to go via an excel spreadsheet to begin with?
View 1 Replies
View Related
Jun 5, 2015
I have Access 2013, Win 7, Outlook 2010 (32-bit).I want to send an email from Access, but not through Outlook. Instead I want to connect to an external SMTP server. I've found a few examples that doesn't work for me. With code including for example
Code:
Set ObjMessage = CreateObject("CDO.Message")
I get an "Error 429: Object can't be created in Active X-component" (My translation from Swedish).With code including this:
Code:
Dim oEMail As New CDONTS.EMail
I get "user defined type has not been defined" (my translation again).I have working code for sending email through Outlook, which works fine. But, Outlook adds a lot of span tags, making it impossible to read for certain screen readers used by visually impaired people, therefore I can't use Outlook.
I've tried to read up on the matter (CDO), and think that maybe the CDO library etc is not included on my computer?can I download it?
View 10 Replies
View Related
Oct 7, 2013
Running Office 365 (Access 2013). Recent problem occurrence. When I do an 'External Data' command, either from another Access database or an Excel file, the import completes, but I don't see the new table immediately in the navigator section. If I import from another Access database, the new imported tables appear as '~TMPCLP....' tables. If it's from an Excel workbook, the new table doesn't appear at all. It's only after I exit the database and reopen it do I see the new tables correctly named.
View 1 Replies
View Related
Aug 1, 2013
[URL]
I have a button on a form, when it is clicked it opens a video file located in a folder on the local computer. Each time the button is clicked a security pop up appears that says "Opening file://C:lahblahyadayadaFile.mp4 Some files can contain viruses or otherwise be harmful to your computer. It is important to be certain that this file is from a trustworthy source. Would you like to open this file?" options are open or cancel. How can these messages be turned off?
I have already played around in the trust center of Access 2010 and changed the "trusted documents", "trusted locations", and "message Bar" tabs with no results. Do I have to play with regedit in windows to get rid of these pop ups? Or can I somehow use VBA code to disable them?They are just a nescience.
View 2 Replies
View Related
Oct 17, 2006
I am fairly new to databases and have goolged for this question. I have a database created that will keep track of drawing files in our archive. What I would like to do is, give the end-users the option to type in the file location and click a button to copy there files from their project folder directly to the archive directory on the server.
Would this be fairly easy to do or would it require the assitance of a access database programmer? Thanks for any help.
View 3 Replies
View Related
Oct 1, 2005
Hi,
I am new to using access, and agreed to work on a site not designed by me.
We want to host this site elsewhere but I am having difficulties backing up the access database; I can't find a way to copy the stored procedures.
Is there a way to export or save the entire database, including the stored procedures? I suspect that this must be a very common task but I could not find any info on how to do this.
Any help would be greatly appreciated.
Kind regards,
Mukti
View 1 Replies
View Related
Apr 8, 2015
I found the way to make my app absolutely (???) secure. But there is one problem I can't find a solution: how to prevent anyone to sneak in my app?Of course it is possible to hide the VBA but I found nothing about the Access objects.
View 13 Replies
View Related
May 29, 2012
Send an email with an attachment.What do I want to attach?A PDF document that I have already uploaded to access and appended to the record I'm currently viewing.I can't find a way to attach a document I have uploaded to access. I'm not even certain sendobject supports that. I can't find any information on that anywhere.
View 1 Replies
View Related
Feb 26, 2013
I've got an Access 2010 application that currently links to a SQL Server 2000 database. I need to change the link to a SQL Server 2008 database on a different server. Where do I go to change the link? When I click on External Data, ODBC Database, I only get an option to import source data. I don't want to import any data. I just want the application to link to a different external database. If I go ahead and click OK, I choose my ODBC connection and log in to the 2008 database. Now I've got a list of "import objects" to choose from. I choose one table (just for testing; I actually want to link with all tables), it says it imported successfully, but when I view the data in that table from Access, it's the same old 2000 database data.
View 5 Replies
View Related
Jan 15, 2014
I'm looking for a form system that will interface with Access.
At present, we collect information from clients and store it in an Access 2003 database. I have designed my form as an Excel spreadsheet. I use Excel as we are missing the reference files that will enable Access to work with Word and some other programs. The Excel form is emailed to the client, who fills it in & emails it back to us.
To restrict entry of certain fields to a list of values, I use lists in the Excel Workbook, which emulate the lookup tables in Access. I am expecting to add more values to the lookup tables, which would mean that I have to constantly update the lists on the Excel spreadsheet, with the lists eventually becoming quite large.
I have written an import program in Access which imports the Excel worksheet/s into the relevant Access tables. This all works, except the entire process is very manual.
What I would like is to use an external form program that would do the following:
1. Allow me to design something that looks nicer than a spreadsheet
2. Can be updated with my lookup tables so I don't have to manually edit the lists (as in Excel)
3. Can be imported into Access (export to an xls or csv file would be ok if not into Access)
4. Is portable, self-contained & can be emailed to the client so doesn't require them to log into any of our systems, including our web site. The user can fill it out with the data being validated at the same time & then return it to us.
View 5 Replies
View Related
Feb 3, 2014
Vbscript/vb macro code for retrieving the last modified date of a file uploaded in a URL.
I am able to get the file but wanted to get the last modified date of it.
View 5 Replies
View Related
May 16, 2013
Here is the import statement I'm using:
DoCmd.TransferText acImportDelim, "IT315 Import Specification_txt", _
"IT315", "D:4533 Hires Rehire Status ChangeIT315.txt"
I can manually transfer the data ie thru File --> Get External Data etc but I can't seem to get the above statement to work --- with the same specification!!
The details are in the attached doc file.
View 6 Replies
View Related
Aug 19, 2013
I'm in the process of importing an excel spread sheet from an external source (SharePoint).
I have the link for the file and have edited it from the Https:// to projectspace. intranet.sharpoint etc etc.
The problem I'm having is before importing the data into a new table in my current db I get an error
"The File "projectspace.intranetetc etc" does not exist.
I am using IE8 and the version of Access is 2007.
View 3 Replies
View Related
Aug 12, 2015
I have a graph chart and my row source type is a Query. So I retrieved data from the Query that I built.
However , I want to get the data from the uploaded excel file.
I have a form that will prompt user in the beginning to upload the excel file and replaced the old table in Access- "CrossSystemData"
Basically , I want to pull data from Excel file , Run the query(Data from excel file) then excute to "display a chart based on my query" ... Is it possible ?
Query SQL: "PolyWrongRegInsCount"
Code:
SELECT GROUPING.INSTITUTION, Count(*) AS NO_OF_GROUP
FROM (SELECT DISTINCT CATEGORY, GROUP_NO, INSTITUTION, IIF(Left(INSTITUTION,1)="P","POLYCLINIC","HOSPITAL") AS INS_TYPE FROM CrossSystemData WHERE INSTITUTION NOT LIKE "*UNKNOWN*") AS GROUPING
WHERE (((GROUPING.CATEGORY)="WRONG REG") AND ((GROUPING.INS_TYPE)="POLYCLINIC"))
GROUP BY GROUPING.INSTITUTION;
My Chart SQL :
Code:
SELECT PolyWrongRegInsCount.[INSTITUTION], PolyWrongRegInsCount.[NO_OF_GROUP]
FROM PolyWrongRegInsCount;
View 3 Replies
View Related
Jan 17, 2015
i want to hide external data and databasetools tabs from my access program.
how i do it ?
View 3 Replies
View Related
Mar 16, 2014
I am trying to create an ODBC link to a copy of the Northwind data base.I am running Win7 on a 64 bit operating system but am keeping office running as 32 bit for Access, Excel , Visio etc due to the fact that I have a lot of old apps tied to them.
When I attempted initially to create a new system DSN ODBC connection it only allowed me to use SQL drivers. (No plurry good) So after some searching I found out that I could use a file in C:WindowsSysWOW64 called "odbcad32.exe" which has allowed me to view /use the total list of drivers to import data.So I can set up a DNS ODBC named Northwind1 and I can access the database without problems using Excel.However if I try to use the same ODBC link in Access to connect to Northwind1 I get the following error message:"You cannot use ODBC to import from export to, or link an external ?Microsoft Access or ISAM database table to your database".
View 2 Replies
View Related
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
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
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
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
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
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 3 Replies
View Related
