General :: Small Application Not Working Since It Was Moved From Its Old Location?

Nov 27, 2012

I do IT support for different companies.

I have had a client moving to a new server a couple of months ago.

They have a small access application that reads csv files and exports them into Sage format that can then be imported into their accounts program - it also reports the total invoiced (whatever is inside the data CSV file) and has a printer friendly report with all the invoices inside said data CSV file.

The issue I have is that since the little app was moved to the new server - it stopped working.

I think somewhere in the code / options there is place to state the working path for the app. I think the app is trying to read the input data file from the old shared folder and thus not working anymore.

I can post the code and a sample CSV file. Specially because I did find a place with the old path and changed it to the new file share and it still didn't work.

View Replies


ADVERTISEMENT

General :: Access 2010 Split Database Hyperlinks Not Working / When Copy Of Front End Moved

Jul 14, 2014

I have built an Access 2010 split database on my computer and it functions as built. My next step was to copy it to the server at work and test it. I discovered the tables had to be re-linked and so did that. As I have read in the Access World Forums in order to function as a multi-user database a copy of the front end must be placed on the individual workstation with the back end residing on the server, however the hyperlinks in the back end will not function when the copy on the workstation is run. I simply get an unable to open "filename" error pop-up. I can run the server copy and everything functions as built. I know that the hyperlinks require all the files to be in the same folder (relative vs. absolute), but if the back end contains all the hyperlinks why does the location of the front end seem to affect the operation of the back end?

View 3 Replies View Related

Small Project Not Working

Jul 10, 2005

a link is created between 2 sites
a circuit can travel over any given site
dataflow is from the left going towards the right
if site b fails, so does site c, d, e, f
but A still lives on
so how do I create a relationship between the tables to answer the queries correctly?

a site has many links, and a link has many circuits.
a circuit has many links
its a many-to-many relashonship.

I created a junction table to provide for the link circuit relationship.

I just need to know how to ask if site c is down, give me the link and circuit that is effected.
Or give me all the links and circuits effected.

The other site_1 table is there to eliminate data duplication for start abd end site which is just a site in the sites table. Its a form of normalization.

Any help would be appreciated.

Thanks,

-Jon

View 2 Replies View Related

General :: Drop Down Box - Field Is Too Small To Accept Amount Of Data

Sep 17, 2014

I currently have a drop down box with four options in there and the options are:

Low
Minimum
Medium
High

However when i change the options in the table to:

Low
Moderate
Significant
High

it comes up with the error message: the field is too small the accept the amount of data you attemtpted to add. Try inserting or pasting less data.

I do not understand what is wrong with the second option of words? The maximum for characters is set to 255 so i am not sure why it is coming up with that error message.

View 4 Replies View Related

General :: Access Runtime BE Location

Apr 11, 2013

In Microsoft article 291264, it says "In a run-time application, the front-end and back-end databases must be stored in the same folder."Is that really true or am I misconstruing the article?I want to use runtime clients with a split back end on a share drive.

View 2 Replies View Related

General :: Modifying Record And Saving In New Location?

Dec 4, 2013

I'm working on a database that will be used by two different groups. Group A provides a list of items to be investigated by Group B.

I'm wondering if it is possible to:

i) have Group A create an excel file of items to be investigated (let's call the file tblNEW)

ii) open a record in the file through a form (let's call the form frmINPUT) to allow Group B to input investigation findings

iii) save the modified record into a separate table of all the work that has been done (let's call this table tblWORK)

iv) delete the investigated record in tblNEW once it gets saved into tblWORK

View 1 Replies View Related

General :: Choose Backend Location From A Form

Dec 18, 2014

I'm making updates for the front end then i send it to 10 pc's in the office then i should change the backend location via linked table manager for every pc

So is there any way to let the user choose the backend location when he open the database nad then it will automatically update the tables link

View 4 Replies View Related

General :: Changing Database Location For Sharing

Dec 29, 2014

In the past I have only done data input into Access databases that have already been created. They have been simple text fields only. I was hired on contract to finish data input for a database that serves to catalogue material resources. The database itself was supposed to have been completed by a former contractor but I'm discovering bits and pieces that weren't finished. I don't have any background in IT or coding.

So, this database eventually has to be shared in a "locked" format so that other entities can view our resources (like a catalogue) without changing them. My next step is to add images to each of the items being catalogued (there are about 100 images). The former contractor began a table labeled "Pictures" in which there are 2 columns: PictureID and PicturePath, the latter being a path starting with C:. The issue is, his picture paths include the hard drive name so that it looks like this:C:HardDrivePicturesPictureID.jpg

I need the database and its images to be share-able on other computers. And I need to use relative paths to connect the images to the database so I'm not tremendously increasing the size of the database.does the location/path of the database need to be changed so it can be shared, and if so how do I do that?

Second question: I have all the images I will be using in a folder on my desktop; how do I save them in a "fixed subdirectory" of the database so that they get moved with it whenever it is sent out to another user?

If I change the database name as I'm working on it (I've been saving a new database each day, so that if I screw up something I can go back to the most recent working one) will that mess up my picture paths?

View 5 Replies View Related

General :: Attachment Field - Specify Location To Search

Jan 14, 2013

Using an attachment field - can we specify the location to search?

We have an Access 2007 DB and need to attach files from only 1 location - we hope to attach a copy of these files into the database efficiently.

I have a few sample DB's that use VB but I am hoping there is a quick and easy solution for this.

View 2 Replies View Related

General :: Copy Network Folder To Another Location And Rename It

Jul 17, 2013

I'm looking for copy folder functionality and I can't find anything.

In access 2007 when I push a button on a form, I want to copy a network folder to another location and rename it.

View 1 Replies View Related

General :: Update Front End With New Back End File Location

Dec 12, 2013

Access 2010

Objective?: I'm attempting to change the file location of the back end portion of my split database.

What I've done so far: I've used the linked table manager to update the back end location of all tables in the front end portion of the database.

Symptoms: When making a change to the OLD back end: If I change the name or move the old back end and then try to re-open the front end, Access opens as if I'm opening the application itself without any database associated with it until I restore the OLD back end to its appropriate state.

When making a change to the NEW back end: If I change the name or move the new Back end and then try to re-open the front end, I get a: "Could not find file" error message until I restore the new back end to it's appropriate state.

I've just discovered a query that I think put me one step closer to resolving this issue. [URL] .....

When I run this query:

Code:
SELECT MSysObjects.Database
FROM MSysObjects
GROUP BY MSysObjects.Database, MSysObjects.Type
HAVING (((MSysObjects.Type) In (4,6)));

It returns 2 results:
1. The path of my old back end
2. The path of my new back end.

Unfortunately I'm not able to update the values from the Datasheet, but this does confirm to me that the old back end is still some how being used by the front end even after my tables have all been updated.

View 5 Replies View Related

General :: Table Structure For Multi Location Warehouse

Apr 30, 2015

I am working with Access 2007. I have a pretty good working knowledge of access. Here is my problem. I have a warehouse which supports four departments. The warehouse floor area is segragated into four areas. Area 1 department 1, area 2 department 2, and so on. Each department uses the same commodity, so I will have four of each item, belonging to each department. The storage locations will be unique and not repeated anywhere in any department. I receive and issue items for all departments.

The problem is how do I structure the tables and queries to receive an item for department 1 adding it to department 1 only and not have the item added to another department with the same item. Also to issue the item from a department 1 without effecting the on hand balance of any other department. I am too the point of creating 4 separate databases one for each department.

View 8 Replies View Related

General :: Control System To Put Stock That Come Into Specific Location

Jun 18, 2015

I have created a stock control system where i put stock that come in into a specific location i can put the same item over several locations depending of the size of the location or i can can put more than one product in a location .

The problem im having is when i do a order that say remove half of all the stock in it is split over more than one location i cant seem to get it to remove the stock from the location to show space available.

View 5 Replies View Related

General :: Copy A Folder To Location Selected By The User?

Sep 4, 2012

I have a folder with Access files, subfolders, and some .vbs files in it. It requires one person to navigate through a setup process. Once the setup is completed, they need to copy the folder and its contents to a location on a shared drive, which is unknown to me and will be chosen by the user at the site. There could be many sites.

It basically works like this:

Files are downloaded to C:Program Files.

A vbscript is run and extracts a folder directly to the C:Drive and opens it. I'll call it C:Test.

The user manually moves the BE file to a shared drive.

The user opens the FE file and is walked through using the Linked Table Manager.

The user then follows a series of forms to input data.

After this, the FE closes and another DB opens.

The second DB walks them through the Linked Table Manager and closes.

Option #1 At this point I would like to have a script and have it copy that folder, C:Test, and its contents, and have a dialog box open telling the user to paste it in a location where all users have access to.

Option #2 A script that will backup the folder and all its contents to a shared location selected by the user.

Either option will l allow others to navigate to that location, copy the folder, and paste the folder to their C: Drive.

View 2 Replies View Related

General :: Wrapping Up Application

Nov 14, 2013

I want to wrap up an Access 2013 desktop app so that the user only sees the splash screen. I can get rid of the Navigation pane, but not the Ribbon or the Quick Access toolbar. At this stage I do not want to split the db or prepare it for distribution. I don't really want to generate a custom ribbon, as I shall need the standard one for development.I'm sure this used to be easy back when I last used Access (97), but cannot believe that I cannot find it anywhere in 2013.

View 4 Replies View Related

General :: Split Database - Unable To Find Table Location

Mar 24, 2014

I'm having a problem with a database that i had split. While creating teh database, i had it stored on my personal drive at work, but wanted to move it to the shared drive so the data could be stored there. this is to deal with cross site network connectivity issues that we encountered with another database here at work.

When splitting the database, i split it on my personal drive and then dragged the back end to the common drive. I realized my error, but when attempting to correct it, i somehow have two of the same file, and no back end?

I receive the error on the attached document when attempting to access any of the tables or information in either of the files, the "back end" that i placed on teh drive, and the "front end" that i have on my personal drive.

I also tried to relink the tables through the linked table manager, but receive the same error when attempting that.

Is there a way to recover from this? I had backed up my file by making a copy prior to splitting, but somewhere in this process, this became linked to these and is having the same issue. Is there a way to recover the old "unsplit" version? I cannot copy over all of teh tables, etc. because i get the same error as earlier.

I can attach a copy of my database for reference...

View 5 Replies View Related

General :: Database Opens As Read Only When Opened From Shared Location

Jul 15, 2012

We have a database on a PC located on our network. The database is located in this computer's shared folder. Another database grabs data from this database occasionally. We're running into a problem where we cannot open the DB located in the shared folder (permissions granted) without it being a read only instance even with no users accessing the DB.

View 6 Replies View Related

General :: Database Design - Stock Tracking / Set Up Table For Each Location

Sep 10, 2012

I am planning my new DB and am contemplating the best design. It will be used for warehouse stock rotation and control of pallets. I want to track each pallet (product/time in/time out etc) to each pallet space within the warehouse. There are a total of 400 pallet spaces or 'locations' as i will refer to them as.

Now, would it be possible for me to have a table set up for each location? Will access object to having 400 tables in my data base?? Is there a limit?

View 1 Replies View Related

General :: Deploying Access Application

Jul 22, 2012

i have an access application with a navigation form to browse through different forms & reports.i want to know how can i use it over my lan network as an intranet website ?can i convert it simply to html interface or what ? i know about access runtime but if i want to deploy it into intranet ( i.e. browsing through web browser ) what r the different methods?

View 3 Replies View Related

General :: External Access To Application

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

General :: Hyperlink Location - Hide Entire Path In Backend And Show Only Name Of File

Sep 26, 2013

I have a field named Location of type Hyperlink. I have copied the respective filepaths in those location column.The location filed looks like

M:New1234.pdf
M:New1111.pdf
M:New2222pdf
M:New4444pdf

If the user clicks on this link then the respective file should be open..I don't want the front end users to see the entire path. So, I would like to have the names as 1234.pdf in the location column instead of M:New1234.pdf. Is it possible to hide the entire path in the backend and show only the name of the file. so that if users click on 1234.pdf then the file needs to open.

View 3 Replies View Related

General :: Parameter Box Pops Up On Application Quit

Jul 17, 2013

When my database application is closed a parameter box pops up asking for parameter from text16 but only if the Navigation Pane is hidden.

Some information:

The application starts with a login screen that has a hidden text box (text16) that allows me to limit what users can access throughout the database by setting it as the query criteria.

If a form is open that is gathering its data from one of these querys and you try to close the application the parameter box opens which is simply annoying for my users who do not know about access.

The interesting thing about this is that if I unhide the Navigation Pane and close the application with one of these forms open it closes fine with no parameter box pop up.

The goal is to have the Navigation Pane hidden and the parameter box not pop up.

Added information if the navigation pane is hidden I can use a command button with a macro that closes all open forms then quits application and this does not cause the parameter box to pop up.

So another fix for my problem would be to disable the "X" close button at the top right of the application.

View 7 Replies View Related

General :: Access Database To Application (EXE File) To CD?

Nov 24, 2012

Okay so I created a database inventory. I know I can turn it into a "application" making it a EXE file. I was wondering after that being done could I burn that into a CD? So it would boot from the CD. Pretty make it work like a program application as in word, excel, etc..

View 1 Replies View Related

General :: Application Was Unable To Start Correctly

Oct 31, 2013

The application was unable to start correctly (0x00007b)not sure it's an Access issue exclusively. What fix to apply (is it a Registry entry that's corrupted perhaps?).

View 5 Replies View Related

General :: How To Create Web Application Using Access 2003

May 16, 2013

how to create web application using ms access. my requirement is i have an inhouse developed retail invoice application ( ms access 2003) which i need to move to web based.

View 2 Replies View Related

General :: Lock Down Application By Saving As ACCDE File

Sep 29, 2012

Trying to lock down an application by saving as ACCDE file. Saves OK but when you load application none of the controls work. I.e. button clicks do not launch "Open Form" or " Print Report" commands.But in ACCDB format application works flawlessly.

When I tried on a different machine I get an error message that says too many Table IDs. Odd since I only have 3 forms, 3 tables and 3 reports. Lots of DoCmd's and switching between the 3 forms but not sure why this would create "too many Table IDs"?

View 2 Replies View Related







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