Attempted to link to a table on an SQL Server, which included customer records & various contact dates, after the importing the records became corrupted in that they repeated the initial date over & over e.g.
Customer Date
AB1111 16.11.04
AB1111 16.11.04
AB1111 16.11.04
AB1111 16.11.04
...as opposed to listing same account number but with 4 different contact dates...also when the Access database was opened on a different PC (also Office 2K) the table was displayed correctly?
Has anyone else come accross the same issue, any advice/guidance much appreciated. :rolleyes:
I have a table (tbl Team Info) which contains names and codes for teams within my business (>400 records) and another table (tbl Process) which contains a list of high level tasks (30 records).
I need to create something where for each team name 9in tbl Team Info) I can map them to the tasks that they undertake (in tbl Process) and assign a percentage of time then spend on each task. Each team could map to several different tasks.
Hi. Have a multiuser front and back end database. Apparently 2 records (without memo fields) got corrupted. I could not delete the records so I tried compact and reair without being able to do either. I tried JetComp but it said it could not fix it. I cannot even delete the offending table.
recovering data from a corrupted database. I have a huge table with almost 600K rows and 140 columns. I went to Database Tools, Visual Basic, Tools, References. There was a broken utility file. I removed it by unchecking the box and closed and returned to my db. I did make table query from the corrupted table and then imported it into a fresh db.... but still I cannot run an append or update query successfully.
Hi, I have been thinking of allowing our users to be able to link records together within our database. We have a CRM system that lists customers and their details of mortgages and other insurance related products which they have. Some entries maybe linked in some way, possibly other family members etc.
My question is, is it possible to perform this kind of action? So they can then see relationships between either related records (ID ref etc).
I'm sure I've seen this in SQL based applications, but haven't come across it within Access.
I'm building an access2000 database for the development department for a nonprofit. The database houses a contact list which is populated by the names, addresses etc. of all the people that have donated money. The organization will often receive a gift from the husband OR the wife - so we want to have 'gift histories' which isolate a unique record (the individual - in this case we don't want to send a thankyou letter to John AND Mary Smith for a gift that came in from ONLY John Smith). However, when the organization has a fundraising event, or wants to identify how much a specific household has donated then we want to run mail merges and reports that pull information from both the husband AND the wife's records.
Currently the only to do these things is a manuel process. We have records for: John Smith (husband) Marry Smith (Wife) THEN WE ALSO HAVE John and Mary Smith
Therefore, whenever we want to send out a mailing or generate a report we have to delete duplicate addresses from the mail query report, making sure we use the appropriate record for the mailing.
Thus, my question is this:
Is there a way to associate two records from within the same table? That way I could:
run a report for just 'John Smith' OR John Smith PLUS affiliate record.
Send a mailing to 'John Smith' OR send a single mailing to John smith AND affiliate.
This very simple task is actually quite difficult because access doesn't want me to link two records from within the same table. Any suggestions?
I have been looking around for a while now to learn how to show in a subform similar records from the same table, and a way to link them together.
I work for a mental health organization and we have a call log database that we create a new record every time a person calls us - this allows us to track the outcome of these calls. Over the last 3 years we have about 10% repeat callers. I am trying to find a way, when creating a new entry, to see if this person has called before, and if they have, link their past contact (record) to the new contact (new record).
For example.
Caller: John Smith (555) 555-5555 (this is the new record)
in the subform, a list would populate all the 'john smith' records with an option to link or attach them to the new record.
Hi i have a small issue with a few databases a friend has asked me to help with. let me explain then you will know all that has happened.
4 days ago my friends server crashed .. hard drive failure .. so he thought
he brought the machine to me to see if i can get it fixed .. turns out the raid firemware on his dell server was flakey and needed updating over a year ago which he hasnt done. anyway it crashed same day his tape back up system his tapes he had to wipe clean and start a fresh so he has no backups ... and the raid on his server failed so now he has no data.
i used easy recovery professional to pull all the files back which it has i have repaired all the exel files but when i have tryed to do repaires on the mdb files it just says failed so for the last 2 days i have been hunting the internet for access repair tools and everything i have tryed has failed. Some of these mdb files are over 1gb in size is there anyway to view the raw data like some other databases allowing me to pull all the tables and back?
when i try to open the files in access it comes up with an error saying unable to open un recognised formate. i have used advanced access repair tool i found on the net and that after spending an hour analizing the file said it failed.
this has been a real evil favour i did for a friend and i wish i never did it but i need to finish it can any one help im not a software guy as you may have noticed im a hardware guy myself so my knowledge on access is very limited.
I'm relatively new at Access and not quite sure where to post this problem. Anyway, I have a complaint database with multi-users. Twice now, I've had the data in two of my records change to what looks like a foreign language. I'm wondering if this has happened when a user tries to filter records within the database. Has anyone had similar problems such as this? If so, is there anyway to correct the text, or to prevent this from reoccuring?
I have just got back from leave and found out my contacts db has corrupted whilst i have been away. Unfortunately during this time the automated backup has copied the corrupted file so that is now useless as well.
When i try to open the file it says 'Error cannot find object 'Database'. I have tried doing a compact and repair on it but get the same message. Is there anyway i can get this back?
I saved a form as a different name so that I could work on it. I made some changes to the new saved form then tried to save it to the name of the old form, to overwrite it. It came up with an overwrite warning, i said yes and suddenly the database went crazy and had to shut down.
When I restarted, the form I tried to overwrite was gone from the list, but the one I had worked on was still there, so I thought, "thats ok, I'll just rename it".
Well, it won't let me rename it either, and comes up with error messages all the time now saying that the form that was overwritten no longer exists. What have I done!!!!
The FE of my database has been crashing during the last week and there have been a few other problems. I got errors saying that the BE was an 'unrecognised format'. I remember getting a 'not a valid bookmark' error also.
Another odd thing that was happening - when I put breakpoints in my code it was not breaking and stepping through it. It was like they weren't there. I realise now that editing the code while it was in break mode may have caused problems.
I didn't realise these issues were signs of corruption (until I started reading up on the subject and searching this forum) so have no idea when it started or what could be corrupt.
I used the compact and repair facility and it seemed to work fine. I can open all the forms and reports. I also decompiled the FE and it hasn't crashed since but I don't know if the problem is completly solved. From what I've read the problem could get much worse if I don't deal with it now.
The reason that I think that there may still be a problem is teh fact that the JEt compact utility will not work. I just get an error saying 'Error compacting database' straight away.
Is there a way to tell if something is corrupt or am I worring unnecessarily?
I have a database with a table with company names, then a relationship to another table that shows that companies' address, but I also want there to be an address 2 and 3 and so on, and some of our companies have multiple sites.So what Im asking is how would you be able to show multiple data, on a sing record.
As part of a larger multi-user system there is a time recording part with a simple table called tblTime with an autonumber field. Today at 11:45 users started reporting receiving a 3022 error. On looking at the table I noticed that if I tried to manually add a record then the ID field number inserted automatically was not the next number in sequence, but one that already existed, hence the error.
I have created a very simple database. I have one form and one table. I have items in the same table as different records that are similar but not the same. I would love to create a link between records to get to these similar records easily. I have read a lot about linking between tables on other things; is it possible to link between records on the same table? If so, any info on where to find it?
I'm experimenting with access and I figured I'd try making a small recipe database, and I entered in all my field names like: Item, Item description, Ingredients, Procedure, etc etc. And when I make my form I want to be able to have links in my ingredients list.
So for example:
Item: Birthday Cake Item Description: Cake for birthdays. Ingredients: Eggs, Flour, Frosting, etc.
Now eggs and flour in the ingredients list wouldn't have links since they're basic components. But for frosting, I want to be able to click it like a hyperlink and it'll send me to this record:
Item: Frosting Item Description: Sweet stuff that goes on cakes. Ingredients: Sugar, etc etc.
I found out i can link fields in different tables together. But is there a way to do what I'm describing above? Linking records to other records?
First of all, apologies if this is in the wrong forum, it's my first post and I'm new to the site.
I'm currently working on an Access database that stores personal details.
I would like to be able to link the database to a network drive so a user can see all related .doc .pdf .xls files on the network that are associated with that record.
************************** Here is the ideal situation:
User looks up record with unique ID 123456 in the database
Database then displays screen showing content of S:Users123456 (Where S: is a network drive)
User clicks database record showing "Personal Details.doc"
Before I spend an age trying to get this to work I thought I'd consult some experts.
I have a main data table for recording all possible insurance claims against a company. What I want to do is create say 2 incidents but link them in some way. i.e. One of our drivers had a car accident (1 claim against our motor policy), but then the driver of the other car sues us(1 claim against our public liability).
I can create 2 seperate records and maybe have a field to highlight parent/child reference numbers, but is there anyway I could allow the user to click a button and see the related records simultaneously?
I posted earlier today and despite all of my best efforst I have made very little progress. I keep hitting my head on the desk at the same point.
I am trying to get one tool entry to link to many records for each tool.
The form [frmVibrationResults] holds tool info, PK is [serial number/reference] as a text field.
The subform on this form called [frmVibrationMagnitude] holds test data for each tool. I want to be able to add a record for each tool for each test. At the moment it only lets me add one per tool. If I try and add more than one record for a tool I get an error message telling that I am duplicating information in the PK, index or relationship.
I have tried all day to solve this and can't proceeed without it working. Can anyone help. I've attached the zipped version of the DB.
basically i want to have a button that opens up a form that links to the record i'm currently viewing. But then i want to be able to navigate to the other records, in access when you use the wizard to find specific data on a form it doens't then let you navigate to the other records
I am trying to put together a database that tracks individual clients and what products they selected for a finance company. I have setup the CLIENTS list but because each client will have different (and multiple) services I wanted to add the SERVICES list as a separate item and then link each product to the individuals that each record relates to. There may also be two clients on the one product so again it would be ideal if the product (i.e a Home Loan product) was setup in the SERVICES list, and then I could link One or Two clients to that individual mortgage record using their data which is stored in the CLIENTS list.
Ok...I have an issue that I don't know how to resolve. I have a table called 'orders' in the orders table there is a place for " quantity', 'colours' and per unit. The cost per unit is based on quantity and colours. For example: 12-35 shirts 1 colour are $2.85 per unit. 12-35 2 colour are $3.50 and so on. I would like to be able to put in the quantity and # of colours and the Unit price fills in a field. I don't know how I can accomplish this.
I have created an Access database application that is stand alone for each account manager/client at our business except for one table that I want shared as a source of data across all separate databases that are created.
I've investigated automatic Database Splitting and this works, except I only want the one table to be split and the others remain unique to each database.
I tried exporting the table in question to another Access database and then linking the table into each other database, this seems to work except that referential integrity can't be set up as it was. Is there any way to keep the integrity between the external database and the databases it links to?
I'm using 2 databases. The first is my working database (LiTiMA.mdb) the second database (LiTiPA.mdb) is just for the password table. There is no link between the 2 databases. But when I open a form for editing the password in LiTiMA, a connection need to be created between the 2 databases. If the form is closed the connection need to be removed.
I have an access dbase trying to link a paradox table. I have Office 2003 and BDE 5.01 was installed on my machine. When I try to link to a paradox table its giving me an error "Unexpected Error from xternal database driver (11265)". On the other hand, I have Office XP on my laptop and BDE 5.01 installed, I tried to link to a paradox table and it works. :eek: :confused: What can I do to link to a paradox table using Office 2003? :confused: