Windows Support Forum

Microsoft Access XP Database Password Problem

Q: Microsoft Access XP Database Password Problem

Hi everyone,

While I am not a tremendously experienced Microsoft Access user, I did manage to set a database password for a file of mine.

I thought this had made it secure however now we have discovered that when the file is emailed to another computer it can be opened without having to put in the password.

I thought that putting a password on the database would mean that the password would need to be entered no matter where the file was opened. Is there any way I can secure my file across any computer that it could possibly be opened up on.

We are running Office XP on Windows XP.

Thanks,

Layla

https://forums.techguy.org/threads/microsoft-access-xp-database-password-problem.279387/
Relevancy 100%
Preferred Solution: Microsoft Access XP Database Password Problem

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/directdownload.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Relevancy 89.44%

I am thinking about creating a password database in MS Access. Does anyone know where to find a template for type of database. I would want to encrypt it but I have found a lot of software to get the password of a Microsoft Access Database, Is this software good enough to protect all of my passwords? I had bought one, but it seems like Microsoft Access could do a much better job than the one I bought.
Thanks,
Joe
 

A:Password Management Database Microsoft Access

Joe, are you talking about a Database that contains Passwords?
Which I assume that you want to protect?
 

https://forums.techguy.org/threads/password-management-database-microsoft-access.802381/
Relevancy 70.09%

hi everyone
i have question may someone can help me please
if i want make id card for some employer by Microsoft Access is this program helpful for this
cand i make design for id and put it Microsoft Access and put information in it and like this

i think may question is not verey clear but any way you can tray to understand
at the end could i make database by Microsoft Access

 

A:about Microsoft Access for database

no one can help
 

https://forums.techguy.org/threads/about-microsoft-access-for-database.995144/
Relevancy 69.66%

Is there a way to have an Access Database require a password when the Shift key is held down while opening?
 

Relevancy 69.23%

Hi to all Little background first I operate and look after a D cad package for a company in Philippines there are many changes being done monthly weekly and daily microsoft database scratch access from to the data we use for production Price microsoft access database from scratch changes to materials changes to construction methods of the cabinets we build changes to the hardware used in the construction etc To date I have been using a spreadsheet with column headings Item code ----Date reported ------reported by ---------- Nature of report -------------- dated completed ---------------completed by -----completed by comments Now as this list grows its getting more and more difficult to track what changes were done and when as some items have had major changes or times I used to use a purpose built DB for our customers when I was in sales back in Australia but no longer have a copy of this on my PC So what I figured was to make one myself The brief is this Fire up the program and a dialog input box appears with the above headings and input box s next to the headings The user clicks NEW microsoft access database from scratch i guess and inputs the info date can be automaticly generated The program I use is based to a large degree on ACCESS DB s and has info available from those tables if thats possible for the ITEM CODE input but also need to be manually input microsoft access database from scratch also as the cabinet assemblies themselves are not stored in a DB materials door styles construction methods and the like are however Once the info is saved its stored for later recall as an example the item code -xxx-c- relates to a cabinet say they want the construction changed from dowel joints to a cam fitting this would be entered into the NATURE OF REPORT field In weeks time the boss goes down and sees the change of construction and asks the question WHO WHAT WHY AND WHEN I need to be able to go to the report screen enter the item code and print out or view everything and all the changes that have been done on that item shows the date reported what was the nature of the report and the date completed reported by who and completed by who and completed by comments There you go Am I aiming too high for my first attempt at an access DB is there something thats a template that I can just modify to suit my needs Regards Steve nbsp

A:microsoft access database from scratch

Beard, welcome to the Forum.
This sounds like a nice little beginner database which could probably be expanded in the future.
If you already have an Excel workbook with this data I would start by Importing it.
I would then create a "cabinet" table with an Autonumber ID field and the Item Code as an Indexed field with "No Duplicates" set.
Then create an Append query that appends all the Item Codes from the imported table.
That will give you the start of a table of Item codes than can be selected using a Combo rather than having the user type in the data.
You then replace the Item codes in the Imported table with the ID number from the new Item Codes table.
 

https://forums.techguy.org/threads/microsoft-access-database-from-scratch.1048671/
Relevancy 69.23%

Hi,

I have an MS Access Database. However two people will have to work on it from different places in a City. Is it possible to make the database available through the internet or something similar maybe? Any ideas would be great cause I cant get my head around it.

Thanks guys.
 

Relevancy 69.23%

Dear all

I have setup a number of databases in Microsoft Access 97 and have them setup as various DSNs on an NT 4 server with IIS 4. (SP6)

Web pages connecting to them all work great.

However, I now use Access XP and would rather not have to keep converting databases to and from Access 97 format.

So, what I'm asking is how can I get the Access XP/2002 database driver onto the server?

I have visted www.microsoft.com/data and downloaded (and installed) MDAC 2.7 RTM but this hasn't added the later driver to the ODBC settings within control panel. I've also tried downloading and installing Jet 4 but without any success.

Would installing OXP on the server help? I'd have to remove it afterwards because I only have the one licence.

Please help me out if you can - it would save me tonnes of time.

Many thanks

Gareth
 

Relevancy 69.23%

Hi I am currently working on my Database assignment due in days trying to finish it up I currently have finished making all tables set everything up properly in field propeties and such Now I m facing to the main part of this assignment creating the forms I am required to make a database for Rick Smith of course a fake company so the user can add new customers in new sales and new products in And what I m stuck at the moment is Screenshot of relationship diagram with all the details inside How many queries do I need to make If so what do they need to have Both each In forms I m making Sale form with Sale Line subform Products form Customer form and a Switchboard I can do this myself Do I only need sub-forms for Sale Should I put sub-forms Access: Questions Database Microsoft for others S Should I do the Price of total per items Subtotal GST and Total of all in Query or on the actual form The preview of Sale form is How do I seperate the Subtotals GST and Total from the subform part Are they still in sub-form If so am I meant to make them in the forms rather than making them in Queries I made forms so far just like the ones I mentioned before Everything is working except for Sale Sale Sub-Form When I open a Sale form it asks you to put the Sales Number I m looking for I do not want to do that And let s say I just type and get in there are a lot of stuff which are not required in there Got person s name he bought items but Microsoft Access: Database Questions displays every single items of them I might need to rar and host the data as well to explain this Here s the requirement in pdf http www sendspace com file ewrm I did all field requirements and everything I just need to make forms and possibly queries Regards Maverick The True P S If any of you have a spare time willing to help me out over MSN please let me know I would appriciate Microsoft Access: Database Questions that nbsp

https://forums.techguy.org/threads/microsoft-access-database-questions.502968/
Relevancy 69.23%

I'm not too hot at creating a database in Access, so I was wondering if there was anyone out their prepared to help me construct one.

This database is designed to search for property from various locations and from various price ranges, you can also pick the type of property, the amount of bedrooms and have the result in descending or ascending order.

For location just use: Location 1, Location 2, Location 3, and Any
Price Ranges use: 30,000, 50,000, 70,000, 90,000, and 110,000
Type of property please use: houses, flats, and bungalows
Bedrooms use: 1, 2, 3, 4 or 5+

Fill in any data you wish, I think this needs to have a query setup?

Thanks for your help
Chris124
 

Relevancy 69.23%

Good morning everyone,

My database at work has hit a snag. Whenever I open it I get this error (see attach.) Once I click on yes, it still does not open. It just shows the loading circle (Vista) constantly...

A colleague and myself are the only ones who use this database - it holds 17,000+ files that we have to track. Hers works fine, albeit slowly.

Any help out there with this one? Always appreciated.

Thanks
 

http://www.techspot.com/community/topics/microsoft-access-database-issues.194266/
Relevancy 69.23%

Hi can someone please help me to remove a password i have set on my access database I know the password but i am unable to find a way to remove it i have done a search database 2010 Access password removal on the microsoft web site and i have got the followinf info Remove a password Open the database in Exclusive mode How do I open a database in Exclusive mode On the File tab click Open In the Open dialog box browse to the file that you want to open and then select the file Click the arrow next to the Open button and then click Open Exclusive The following figure depicts the menu On the File tab click Info and then click Decrypt Database The Unset Database Password dialog box appears Type your password in the Password Access 2010 database password removal box and then click OK I have followed these instructions but when i get to theclick On the File tab then click Info and then click Decrypt Database the Decrypt database option is not there So can someone help me please

A:Access 2010 database password removal

Hi i am not sure what the security is. when it loads it asks me for the password and then works fine it just will not let me remove the password.
If i open it in the exclusive mode i put in the password and the i get to option to set a password.
But whatever i enter it say not a valid password if i try and set a new one.

So does this mean it might be user level security

I enter data into this database on a daily basis and i have some old backups and it will let me remove the password from them ok but not the latest version.

Regards to you all

Hope you can help

http://www.sevenforums.com/microsoft-office/124098-access-2010-database-password-removal.html
Relevancy 68.37%

I am in the process of developing an Access 2003 application, and almost done. While I was fixing some errors with controls on one of the reports, seems like the database corrupted. Now, I keep getting "microsoft office access has detected corruption in this file....etc". It instructs me to Compact & Repair, but when I get the same error message when I try that. If I open a blank database & try to import objects from the corrupted database, I cannot access/view the objects of the corrupted file from the blank database. Unfortunately, I dont have a backup of the file, I can try to restore to an earlier storage point (using System Restore), but will lose considerable work. Any ideas?

A:How to fix corruption error in Microsoft Access database

It is sometimes a good idea to decompile your database and then compacting and repairing. I had a similar issue just the other week, my database kept of throwing an error "File not found" however i have no code within my DB that searching or references ANY file. I just decompiled the code and it all worked again..Create a shortcut and enter the below into the taget, you can also copy paste a shortcut and edit the target to the below. You will need the path to where MS ACCESS is installed and the path to where you database is stored.Then run the shortcut and it should decompile your database. Once you've sucessfully done that, compact and repair it again."C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" "c:\YourDatabaseName.mdb" /decompilemessage edited by AlwaysWillingToLearn

http://www.computing.net/answers/office/how-to-fix-corruption-error-in-microsoft-access-database/19933.html
Relevancy 68.37%

hi,

I want to send group mail to email-addresses that are in my access database, but I can't find a way how to export the address' in a form that I don't have to manually copy and paste each address.... like this--> [email protected], [email protected], [email protected].... please help, I can't find the solution
 

A:Group mail from microsoft access database?

What type of group mail are you doing?
 

https://forums.techguy.org/threads/group-mail-from-microsoft-access-database.646734/
Relevancy 68.37%

When opening Microsoft Access, the norm is to have a samller window inside the large window pop up that says the type of data base. Then you can click on the icon inside to open up the database. Well, someone in my office closed out the smaller window and I can't figure out how to get it back. I tried looking in the recent history to no avail.

I know this is a stupid question, but I can't figure it out and the database holds my list of clients which I desperately need. Any help would be appreciated.
 

Relevancy 68.37%

Although I've used Access for 15 or so years, I've never password-protected a database. I did so today after spending 2.5 hours cleaning out garbage left by some people who didn't know what they were doing. I then copied the database, both the client and server sides -- I thought -- to a jump drive. When I got back to my office, I found that the files that were on the jump drive were the ones I had put there early this morning before going to the organization where we did the cleanup. Does that mean that password-protected databases cannot be copied to a drive outside of the one they're on?
 

Relevancy 67.51%

Hello,
Unfortunately i'm not an expert in Microsoft Access 2010, but i've come across a problem with one of my databases that is running on a Windows 7 computer.
The problem is that when the database runs, it has a very very slow response time, yet if I copy it to another Windows 7 or XP computer the response time is fast.
So far I have updated the computer with Windows 7 updates, and modified the registry buffer size to 50000 in the Access Connectivity Engine setting, but the Microsoft Access database is still very slow at loading and accessing the data.
Any help greatly appreciated.
thanks,
Paul.

A:Microsoft Access : database response time slow.

Hello Tilbo7, welcome to Seven Forums.

Is there perhaps something in this MS Article which helps:
Description of the Access 2010 hotfix package (Ace-x-none.msp): August 30, 2011

http://www.sevenforums.com/microsoft-office/222886-microsoft-access-database-response-time-slow.html
Relevancy 67.51%

Hi! I hope someone could help me out.

I am using this Microsoft Access that has a database that is as old as 20-30years on an old desktop. It has been passed down to me for generations that used to work on this Access. Used it as a contact list, and a Report Generator Software that I use to generate a report that I could print via Access. The database is working fine, but is super super super slow! (The computer CPU even have a floppy disk reader, and it takes 10 minutes for the desktop to start. That's how old the computer is!).

I bought a brand new desktop an updated one, and I wanted to transfer all data from the Microsoft Access and Report Generator Software to my new desktop. How can I do this without missing a single data?

Thank you for those people that would try and help me out.

CarleeDungee
 

http://www.pcreview.co.uk/threads/transferring-microsoft-access-database-to-a-brand-new-desktop.4070946/
Relevancy 67.51%

Is there any url out there on Internet that lists all Access 97 Microsoft Jet Database Engine Errors? I.e. Run-time error: 63933

Tried that on help menu to no avail, paper clip is laughing at me.
 

Relevancy 67.51%

Can i limit password sequrity to only certain database objects?

Basicly i want users to be able to open the database and view certain objects without being hassled for a password. Its only when they view certain forms, tables, and designs i want them to be asked for a password.
 

A:MS Access - Security - Can i limit password sequrity to only certain database objects

Not as far as I know with Access Security. The normal security just requires the one logon password, after that the abilty of the user to look at the data is controlled by your security settings.
I would find it far more annying to put in a passwod everytime I wanted to look at certain forms rather tha entering it just once at the beginning.
You can use VBA to create Input Message boxes to do what you want to do though if you really must.
 

https://forums.techguy.org/threads/ms-access-security-can-i-limit-password-sequrity-to-only-certain-database-objects.497465/
Relevancy 67.08%

Hi all I ve amended the MS-supplied Order Entry database for my own use and for the last years of running my small business Entry issue Access Default Order Microsoft database I ve not had any issues with it However I ran the Receivable Ageing report Default Microsoft Access Order Entry database issue a couple of days ago to let one of my customers know what amount he had outstanding There were amounts in Current - days amp - days He s made a payment today and I ve allocated that payment across several invoices but having run the query again I find that there is still an amount in - I ve looked I m the Order Entry table for balances that aren t but the only ones I can find are within days I ve been into the Payments table the Order Details table etc but cannot for the life of me find where this outstanding value relates to Is there any way I can modify the Receivable Ageing query to include order numbers which show the orders that generate this amount I have two invoices for that exact amount but both are showing as paid in full Any help gratefully received Martin nbsp

http://www.pcreview.co.uk/threads/default-microsoft-access-order-entry-database-issue.4069249/
Relevancy 66.22%

I have an Access Database when I Open it display this massage (
The Microsoft Access database engine could not find the object 'Databases')
I search about this massage in internet I found an answer that said open a new access
File and import your database but unfortunately I have got this massage again please help me
 

http://www.pcreview.co.uk/threads/error-the-microsoft-access-database-engine-could-not-find-the-object-databases.4071032/
Relevancy 66.22%

I am in the process of developing an Access 2003 application, and almost done. While I was fixing some errors with controls on one of the reports, seems like the database corrupted. Now, I keep getting "microsoft office access has detected corruption in this file....etc". It instructs me to Compact & Repair, but when I get the same error message when I try that. If I open a blank database & try to import objects from the corrupted database, I cannot access/view the objects of the corrupted file from the blank database. Unfortunately, I dont have a backup of the file, I can try to restore to an earlier storage point (using System Restore), but will lose considerable work. Any ideas?
 

https://forums.techguy.org/threads/how-to-fix-error-in-database-microsoft-office-access-has-detected-corruption-in-this-file.1154046/
Relevancy 63.21%

Hey there Hope someone can help me out having a very perplexing problem that is happening in Microsoft Works with a database that my work has been using over the years without any problems The only way to explain it is that when you work on the database one day the next day some of the information disappears in the report view mode no one is deleting it The columns A to F seem to go missing Now A-F are the ones containing the data I need I dont know if makes any difference if I were to put that missing information back into those cells into columns from H onwards How can I get those missing A-F columns back Works problem Microsoft database Does anyone have any idea why they go missing periodically Just recently after a hardware upgrade this has started to happen I know that the version we are using of Works is Would upgrading the software help this problem Would appreciate anyones input greatly nbsp

https://forums.techguy.org/threads/microsoft-works-database-problem.730375/
Relevancy 63.21%

I am working with the Microsoft Works Database program that comes with Windows XP. I am listing a number of books, their isbn's and their prices. I evidently punched a wrong button because now every time I enter a new book the price from the previous entry is automatically entered for the new book. For example, if the price for the previous book was 19.99 that is automatically entered as the price for the next book.

It's not a big problem, because I can override it by simply entering the correct price, but still it's annoying. Anyone know how I can undo this default price setting?

Thanks!

Patrick
 

A:Problem with Microsoft Works Database

Look in the Options of the program.
 

https://forums.techguy.org/threads/problem-with-microsoft-works-database.1026415/
Relevancy 61.49%

I have a really confounding problem Situation Small non-profit organization with workstations mostly Dell Pentium s Office network uses a Buffalo server and router I don t know for sure but assume the network is problem database Access a simple Base-T The organization runs on the MS Access databases I ve designed one of which is a reservation system The major tables for that system are the Signups table where the information for each reservation is collected and the EventSched which simply contains data for all the events for the year with event type date departure and return time location program type etc The tables contain a lot of links to auxiliary tables per the attachment The database is a client server design Forms on the workstations tables on the Buffalo Each year I go in and set up the reservation tables for the next year in this case I did that yesterday I first copied the database containing the tables to a file with the name quot PublicSailTbls mdb quot After deleting all the records in the Signups EventSched Manifest and HowPaid tables to make them ready for next year s entries on the workstation on which I was doing this I also copied the Forms client side of the split database changed the name to quot PublicSailForms mdb quot and changed the links to the tables file on the Buffalo This is the same process I have used for the last years Problem is the Signups form Access database problem will open on Access database problem only two of the workstations On the others the system goes into quot indefinite busy quot hourglass Task Manager indicates Access and everything else is quot not responding quot but attempts to quot end task quot fail Only way to restore the system is to select quot Restart quot Because it worked on two workstations we thought perhaps the network was not working properly so quot regenned quot it shut all computers down shut the Buffalo and router down waited one minute then brought the network back up Didn t change anything system still works on two of the workstations but not on the others Anybody have a clue as to what s going on where I should look for the cause of this odd problem nbsp

Relevancy 61.49%

In my database program the user has the option to delete clients from a list or add new ones. This works fine unless all clients are deleted and the database becomes empty. Once this happens, the user is still able to add new clients to the empty database. However, back in the forms area, it will not allow new data to be entered in the fields for the new clients.
 

Relevancy 61.49%

I tried to open a database but I can't open it. I got an error message "unreconized database format". Is it corrupted? Please help me to fix and how can I open this database. thanks.
 

Relevancy 60.63%

I ve got a database thats causing me a big headache and I can t figure out how to fix the issue I m pretty sure its in the VBA code but I don t know because i m not much of an expert in that area so hoping someone here can help help! please database problem, Solved: Access me with this I attached the db link if someone wants to have a look into it dummie info So the problem is that on the owners list and owners form When each record is opened on the owners list its the same as record and does not reflect the correct customer record Clicking save and new will do nothing When I click quot New Solved: Access database problem, please help! Owner quot it opens a form of a customer record instead of Solved: Access database problem, please help! a blank form to input data into I get a few various errors when trying to create a report in accounting too How can I fix this so the records do not default to the first and be able to Solved: Access database problem, please help! save and close too Any help would be much appreciated dl dropbox com u Rental zip nbsp

A:Solved: Access database problem, please help!

You appear to have posted an "Evaluation" database, which does not have all it's features working.
I assume You need to purchase the full privilege database to have those features working.
 

https://forums.techguy.org/threads/solved-access-database-problem-please-help.1070242/
Relevancy 60.63%

As part of my coursework, I have to create an Access Database. I have a slight problem where, if you go to the form 'frmCustomer' and try to add a new record in the frmAllBookings subform within the frmBooking subform, it will not let you add the new record and will display the following error:

Cannot add record(s); join key of table 'tblBooking' not in recordset.

I have gone through all the settings and I can't figure out what's causing it. Everything else seems to work fine.

I have uploaded a copy of the file. Any help on this would be greatly appreciated.

Matthew.
 

Relevancy 60.63%

I have designed a database, I have several different forms attached to a main form by tabs. What I am trying to do is attach a seperate notes sub-form to each form, but what is happening right now is that when I input a note it shows up on each individual record.
Any help would be appreciated. Thank you.
 

A:ms access database notes problem

Lisa8 said:

I have designed a database, I have several different forms attached to a main form by tabs. What I am trying to do is attach a seperate notes sub-form to each form, but what is happening right now is that when I input a note it shows up on each individual record.
Any help would be appreciated. Thank you.Click to expand...

The separate notes - where do they write to? It sounds like you may have them all writing to the same cell in the same table.
 

https://forums.techguy.org/threads/ms-access-database-notes-problem.555663/
Relevancy 60.63%

Mum has asked me to print off an old access database. I tried access 2007 but it refused to open it citing security concerns and other reasons. So I then tried Access 2002 in XP Mode but save as is greyed out and export to says it cant find the path.

A:Problem saving an old access database

What version was the DB originally created in?

No matter which, the 2007 version should open it fine... just ignore the security warnings... they appear on many of my old DB's from 03 and previous versions. Yet after ignoring the warnings they open just fine. Once you do open it, save as a Access 2007 file format and you will be fine in the future. Office 2010 due out later this year!

http://www.sevenforums.com/microsoft-office/52148-problem-saving-old-access-database.html
Relevancy 60.63%

I had an issue earlier in a coursework Database project, which has now been resolved. I have started to create the invoice and the 'Subtotal', 'Discount' and 'Total' calculated fields display '#Error'. They work in the 'frmBookingTotals' subform on the 'frmCustomer' form and I have copied them directly from the form, but yet they don't work in the invoice. The record source of the invoice points to the fields which are referenced by the calculated fields and I have checked for obvious errors, so I can't see what's wrong.

I have attached a copy of the file I am working on.

Thanks for any help,

Matthew.
 

A:Solved: Access Database Problem 2

Problem solved. I've just found out it matters where you put the fields.
 

https://forums.techguy.org/threads/solved-access-database-problem-2.920913/
Relevancy 60.63%

The problem How do I make a database that has Problem Conceptual Database - MS ACCESS an infinite amount of customers who can receive an infinite amount MS ACCESS - Database Conceptual Problem of products that are never same price The reason they are never the same price is because each damaged item has a different price based on the inspection of damage I cannot wrap my head around building this database I want to take a phone call and in that call take down all the pertinent contact information carrier information order information and the items that are damaged I want to be able to add - items onto order See below for a really abbreviated version of what fields I need I then need to be able to create a form that displays all this information and be able to enter information that updates all tables tblCustomer ------------ CustID OrderID ItemID CustLName Customer Last Name CustFName Customer First Name CustPhone Customer Phone CustFax Customer Fax CustEmail Customer Email DateCall Date of Phone Call tblOrderInfo ------------- OrderID CarrierID OrderNum Order Num RefA Reference A of order RefB Reference B of Order custNo Customer Number picklist Pick List Number tracking Tracking Pro Number tblItem -------------- ItemID ItemType Item ItemDesc ItemQty ItemWt ItemCost ItemNet tblCarrier ---------- CarrierID CarrierName Carriercontactinformation - broken down further TerminalContactInformation TerminalName InterlineCarrierName InterlineCarrierContact Information these could break off as well but for the purpose of what I need I am not including them DocumentFlags - lots of flags for different things I am really unsure how to explain what I need but I cannot enter the customer information and then the item information without it saying it cannot update the other table because the information is not there I know its not there I want to put it in I am not sure how to set this up at all Can someone please help me Thank you nbsp

Relevancy 60.63%

Hiyas I ve got a pc here that s having problems with a database in Access XP version The error is as follows quot This database is in an unexpected state Miscrosoft Access can t open it This database has been converted from a prior version of Microsoft Access by using the DAO CompactDatabase method instead of the Convert Database command on the Tools menu Database Utilities submenu This has left the database in a partially converted state If you have a copy of the database in its original format use the Access Problem Solved: Database with Convert Database command on the Tools menu Database Utilities submenu to convert it If the original database is no longer available create a new database and import your tables and queries to preserve your data Your other databse objects can t be recovered quot Solved: Problem with Access Database It s only this one database Solved: Problem with Access Database giving this error all the others appear to be working fine What apparently happened was the lady was working on the database when Microsoft asked if she would like to install an update She said no Solved: Problem with Access Database to if a few times but the message would not go away so eventually she clicked yes After the update was installed she could no longer get into the database because of the above error So far i ve tried to repair the database and convert it but it keeps telling me that i don t have permission so i must contact the creator of the object I ve removed the updates from the past few days just to see if that would help but no joy Even trying to access the database on another machine yields the same results Does anyone know how to solve this problem Any help would be greatly appreciated Regards BW nbsp

A:Solved: Problem with Access Database

Doing the convert database creates a new copy of the original database in the new version of Access, the old version should still be available.
 

https://forums.techguy.org/threads/solved-problem-with-access-database.479458/
Relevancy 60.63%

Hello,

I'm currently creating a simple database program using Vb.net as for my API and Ms Access as for my database.

I'm doing a log-in window in my program where there is a username and password textbox.

I have created an account table (with 3 attributes - id, username and password) in MS Access and it's properly connected to my vb.net program (I just tested it a while ago by inserting id, username, and password using the program that i've created in vb.net).

My problem now is I can't figure out how to check the inputs in username and password textbox (in my log-in program) and check if it's equal to the records of username and password in my database in MS Access.

Any help is highly appreciated.
 

A:Database query problem in VB.NET (via Ms Access)

This is how I'm doing the log-in form

Dim main As New Main

Dim cnOledb As OleDbConnection
Dim cmOledb As OleDbCommand
Dim result As Integer
Dim sql As String

Try
sql = "SELECT account_username FROM users WHERE account_username = " & PrepareStr(txtUser.Text) & " "

cnOledb = New OleDbConnection(ConnectionString)
cnOledb.Open()

cmOledb = New OleDbCommand(sql, cnOledb)
result = cmOledb.ExecuteNonQuery()

MsgBox(result, MsgBoxStyle.OKOnly)
MsgBox(sql, MsgBoxStyle.OKOnly)
If result = 0 Then
MsgBox("Invalid Password", MsgBoxStyle.OKOnly)
ElseIf result = 1 Then
main.Show()
End If

cnOledb.Dispose()
cmOledb.Dispose()
cnOledb.Close()
Catch Exp As Exception
MsgBox(Exp.Message, MsgBoxStyle.Critical, "OLEDB Error")
Catch Exp As Exception
MsgBox(Exp.Message, MsgBoxStyle.Critical, "General Error")
End Try

I want the cmOledb.executenonquery() to return a value 1 when he found a match in my sql statement, however it always keeps returning 0 even if my sql statement is correct
 

https://forums.techguy.org/threads/database-query-problem-in-vb-net-via-ms-access.396220/
Relevancy 60.63%

I'm using Windows XP and Microsoft Access 2003. When I make a report or label, the background color is gray. I've tried to change the background in design view and it seems to be changed, but the report still shows and prints the gray background. I think there must be a background color default somewhere that I changed since all new reports and labels seem to show and print in gray now. Any help to get rid of this would be appreciated. Thanks!
 

A:Simple Access database problem

Hi dhari,

Welcome.

Ok...to change an object's (form, label, textbox) background or back color the following code should work:

objectname.backcolor = rgb color

so for example if your label's name is Label1...you should write:

Label1.backcolor = vbWhite

or

label1.backcolor = RGB(255,255,255)

The color you choose is up to you.

Hope this helps.

Best,
Zhouma
 

https://forums.techguy.org/threads/simple-access-database-problem.878183/
Relevancy 60.2%

Whenever i open MS Access 2002, it opens fine, but once i try to open an individual database, it crashes with a general Win XP msg saying there was a problem and it had to close, this happens everytime without fail, and after exactly five seconds of being open.

i've tried uninstall/reinstall, i've tried updating all files from MS office online, it is registered

i'm out of ideas here, any help would be appreciated
 

Relevancy 59.34%

Hi Guys,

Im trying to write some code that will copy my access database , tables and data to a new sql server database, ive got the code to create the sql database but i need to populate it from my application

Any answers would be grateful

Thanks
Mark
 

A:Copy an access database to SQL server database using VB.NET

Google: import access to sql server
 

https://forums.techguy.org/threads/copy-an-access-database-to-sql-server-database-using-vb-net.1045442/
Relevancy 59.34%

Here's the question- how do I open a form in an existing database from another db in Access 2010 using VBA and give it focus. I can open the external db and it's form but cannot figure how to give it focus. I'm trying to create a master form that will call various databases that each have a form. Seems simple, open the master menu, click on a button that then opens the called db and the associated form. Do my business exit the db and am back at the master form. I would be okay to just close the master db, all it has it the main menu or leave it open. Doesn't matter which I just want to open the called db and form and have its focus.
 

http://www.pcreview.co.uk/threads/how-to-open-existing-database-from-another-database-using-access-vba.4070487/
Relevancy 59.34%

Hi,
I don't support Access, nor have I been trained in it, but I've been asked if I can help in this problem.
An Access database connects externally to a SQLServer database at login time for the application. How do I find which external database they are connecting to? I know that there is a way to go behind the forms to see the source code, but I cant remember how to do this.
I cannot find an obvious User/System file dsn on the PC to give me a clue.
Thanks in advance
 

Relevancy 59.34%

I'm building a database application in Visual Basic .NET and I want to know what is the equivalent code of this when I want to make a connection to mysql:

Protected connString As String = _
"Provider = Microsoft.Jet.OLEDB.4.0;" & _
"Data Source = " & loc & "\dbProject.mdb;"

Private cn As OleDb.OleDbConnection = New OleDb.OleDbConnection(connString)

Private ConnectionString As String = connString
 

A:Exporting MS Access Database to MySQL Database

You would have to have the MySQL driver for it on the server regardless.
 

https://forums.techguy.org/threads/exporting-ms-access-database-to-mysql-database.389139/
Relevancy 58.91%

Hi there I am attempting to export a table from Access to a txt file which will then be merged into Adobe InDesign CS I am following the instructions from InDesign to accomplish this merge which requires that the file be in a txt or csv format I am trying to keep my list from the table in Access in alphabetical order which is how the design of the table is saved When I export the table to txt format it when from .txt Solved: of 2000 Problem: database design changes exported fo Access to un-alphabetizes the list When I select quot Save Formatted quot during the export process I end up with a txt file in a code that InDesign will not accept in the merge I have tried exporting the table to Excel and then to a txt file but InDesign will not let me merge the files that are created that way Any ideas about what I can do short of exporting the table anyway and then seeing how well I can manually cut paste and alphabetize the fields Thanks Stacie nbsp

A:Solved: Problem: design of database from Access 2000 changes when exported to .txt fo

https://forums.techguy.org/threads/solved-problem-design-of-database-from-access-2000-changes-when-exported-to-txt-fo.736044/
Relevancy 58.05%

I am reposting this question I was unable to get back to it in a timely manner to provide the data so here is my question again with supporting files I have an access application that produces from Access in Problem when data Excel' using database 'Analyze converting char a report that can be downloaded into excel using the option on the toolbar to Analyze in Excel I am having a Problem converting char data when using 'Analyze in Excel' from Access database problem with one of the columns which is getting the data converted to a negative number in some cases or some other type of char data I assume it s because the data some of the data is all numeric so it assumes a numeric field but then it runs into char data and is making some kind of data conversion I am trying to see if anyone knows how I can fix this The data is automatically being loaded into access from a teradata relational table and it is defined as char in the table and that s what it should be in excel It is also defined as text data in the access database which is correct But when loading it into excel from access it is not always correct I am attaching a sample of data The file beginning with database is what my query returns The file beginning with rpt is what the report returns and then is put into excel using Analyze it in Excel The data that gets converted incorrectly is in a column called MPN Look for a value of in the column called CPN This is the CPN that has the incorrect value in the file beginning with rpt I included the entire file because I wonder if it has to do with excel somehow looking at the first X number of records and determining a field type Not sure I can attach a sample of the access application if that will help more I am displaying a report format from a from which is calling a report Then I select select the option to Analyze it in Excel This is where I am having the problem Thanks so much and thanks to all those who answered my previous post but I was not able to get sample data out there in a timely manner nbsp

A:Problem converting char data when using 'Analyze in Excel' from Access database

http://forums.techguy.org/business-applications/708011-option-analyze-file-into-excel.html

Please reply to your existing thread where you are already receiving help.
 

https://forums.techguy.org/threads/problem-converting-char-data-when-using-analyze-in-excel-from-access-database.728560/
Relevancy 56.76%

I have MS Access 2000. I initially created a long book list several years ago. I recently found a template from the MS database for books that I downloaded that I like better. I have tried importing the data from the old database to the new one but with no luck. Both are in Access 2000. I am running Win2K.
Thanks
 

Relevancy 53.75%

I created a password for an MS account more than a year ago. Have not needed to use it until today. Installing an app. Can't remember it. Is there anyway to reset or recover a MS PW? How can I fix this, short of a brand new re-install?

Bill

A:Microsoft Account password problem

Hello Bill,

You can use step 5 in OPTION TWO of the tutorial below to reset your Microsoft account password online at Microsoft. It'll then sync to your PC while it's online to change the password.

Microsoft Account Password - Change or Reset in Windows 8

http://www.eightforums.com/user-accounts-family-safety/71610-microsoft-account-password-problem.html
Relevancy 53.75%

I am having trouble accessing Outlook on a computer with a password protected "personal folder". While the exact reason for having a password protected folder is to ensure that others can not read / access the files in it, the owner of this computer reciently passed away and didn't leave any of his passwords behind. Is there any way to gain access to the personal folder or outlook as a whole?

I am running Microsoft Outlook 2002
Application name Outlook
Version 10.0
Build 2627

On Win XP home
OS Name Microsoft Windows XP Home Edition
Version 5.1.2600 Build 2600

Any ideas or suggestions would be usful, thanks.

A:Microsoft Outlook - Password Problem

Hi LordSoren.
As much as I'd like to help you it's against forum rules to post a solution.
If it was done using Outlook's built-in security functions, it's very simple.
If it was done with 3rd party software, it gets much more difficult.
All I can say is "seek and yee shall find". Sorry, I do believe you.

http://www.bleepingcomputer.com/forums/t/56105/microsoft-outlook-password-problem/
Relevancy 53.32%

I am working for a company that has four people (four different computers) entering data into four different Excel 2010 files on a shared drive. I would like to create a master file on my own computer for the purpose of generating reports. How do I create one Access database that includes all of the information from the four different excel files? Also, can this Access file be continuously updated as the four Excel files are updated each day? Thank you!!!
 

Relevancy 52.89%

According to what I've read, Access 2010 uses the same database format as Access 2007. So this should mean I can open and run a 2007 database (with a lot of VBA code) in Access 2010 with no trouble, yes?

So why do I have the feeling that something is not going to work? Is it because I have been through to many Access upgrades?

A:Any problems using Access 2007 database with Access 2010?

Hi bbinnard,

If you have not purchase Access 2010 yet, what I'd recommend is....download the Trial Version and play around with it for quite a while.

http://www.sevenforums.com/microsoft-office/191698-any-problems-using-access-2007-database-access-2010-a.html
Relevancy 52.46%

I am Arun Kumar Kushwaha and I have discovered one Big Loophole Security Leak in Microsoft's Windows Operating System worldwide through which we can Access Delete Copy Replace Important Data without Cracking Resetting the Login Password in Windows OS and for this we not need any can windows want user locked login I is access (locked microsoft with password) to Admin/ know account we know OS rd party Software CD DVD Pen drive CMD Script or any other means of hacking Devices tool only through Windows OS we can Access anybodies Computer Around the world and user will never get to know that his her computer has accessed by someone else This is purely Microsoft's Negligence towards user's Around the world I want to know is microsoft know we can access locked windows OS (locked Admin/ user account with login password) U can assume how much serious is this Issue if anybody can steal confidential Important data of Company Govt data or any other Sensitive Personal data of anyone who are using windows OS I have Talked through telephone to MS India regarding this Issue and they told me that there is no loophole in their OS and can't be accessed by anyone without having Login Password or User need to Reset login Password with tool software available also i have mailed to MS Technical support Team and also asked about this issue on Windows worldwide official support forum but not get any meaning full response from them I am asking this message to here coz i want to Spread this issue around the world so every user can secure their Data and also MS can rectify this issue by releasing an OS Update Thanks for reading Your's Truly Arun Kumar Kushwaha

https://social.technet.microsoft.com/Forums/en-US/a5bb2b05-44c4-40de-9de5-f98791edc8bf/i-want-to-know-is-microsoft-know-we-can-access-locked-windows-os-locked-admin-user-account-with?forum=mata
Relevancy 52.46%

I m working on a database manager application I need to figure out if the database the user wants to open requires a password and if so prompt for it I haven t found anything in ADO that will tell me this and it seems like a catch- that I need ADO to determine if the database requires password for Prompting database ADO/VB6 a a password to establish the ADO connection From what I ve seen different database providers Prompting for a database password ADO/VB6 return different values on quot invalid password quot events so testing the return code of the initial connection then prompting for a password to retry seems problematic I want to use this one application for MS Access SQL Server Oracle MySQL Sybase FoxPro Excel etc Basically whatever database provider the user Prompting for a database password ADO/VB6 chooses -- assuming it is OLEDB ADO or ODBC compliant What I m after is a replacement for the VB sample VisData That application does not correctly interpret recordcount on some tables does not support Access in its native format contains a bug that if you specify an invalid table in the Query window goes into an endless loop requiring Task Manager to shut it down Those are what I know about what else is there that I don t Anyway any help will be appreciated Thanks coderitr nbsp

https://forums.techguy.org/threads/prompting-for-a-database-password-ado-vb6.185464/
Relevancy 52.46%

Hi I have a datbase in microsoft works that i m having a hard time trying to get out the answers to the questions i ask it because i m unsure how to ask My database consists of cards from texas holdem games that i have played it goes like this there are five columns containing flop flop flop turn and river Each title has a card value in it with either a letter or number representing the value of the card and also a letter representing which suit the card is S for spade d for diamond etc So the database is in rows of five something like this flop flop flop turn river Ad Qd Ah s Kc Nothing complex What I want to ask it is how many time that out microsoft database of of the first columns microsoft database are the same suit either specifically or independently I guess i would need to use a formula for this but am usure how to do it Also I want to know the standard deviation between each of the two suited flops happening Thanks nbsp

https://forums.techguy.org/threads/microsoft-database.247985/
Relevancy 52.03%

Is it possible to convert an Access 2000 database to Access 7.0? I have an old machine that I would like to run a database on but it only has Access 7.0 for WIndows 95.
 

Relevancy 52.03%

Hello All,
Our company had a photo booth with an F-35 fighter jet at a recent technology show. Individuals were allowed to have there pic taken in front of the aircraft with a pretty model. Now I have over 2500 pictures and over 2500 individuals that need their pic emailed to them. I have an Access database with a name, email address and a picture. Each name has a different image. How can I automatically send each person their picture through Outlook? I would like it to automatically populate a new email with the address and corresponding pic then have it be sent on its way while I am home sleeping. Can this be done? Is there a command that can run a VB script in Access to accomplish this? I thank you profusely in advance.

Scott
 

Relevancy 52.03%

a message pops up:

"you do not have the necessary permissions to use the object.
have your system administrator or the person who created this object establish the appropriate conditions for you."

how can i remove this message and access my database whilst still keeping it in working order?

please help iv spent so long making this thing and now its all gonna be for nothing
 

Relevancy 52.03%

Hi, I want to create a database of Asteroids with extensive information in one or more fields but I can't figure out how to expand the fields to allow this. On my dinosaur Tandy the database I had would create records just like index cards. I loved it. Any idea what I need to do? I've already tried the help and clicking everywhere.

Thank you.
 

https://forums.techguy.org/threads/microsoft-works-database.479724/
Relevancy 52.03%

Does anyone know how many record entries (not fields) are possible in a MWDB file? I was working on an inventory list when suddenly the database would not accept any more entries. I didn't know if the was a limit. Is there any database that has no limit as to entries?
 

A:Microsoft Works Database

I know microsoft access 2003 used to be a file size limit of 2GB - so would not expect works to be bigger (although, not yet found the spec)

Whats the filesize you currently have?
 

https://forums.techguy.org/threads/microsoft-works-database.873748/
Relevancy 52.03%

-------------------------------------------------------------------------------- Hi I have a question database microsoft datbase in microsoft works that i m having a hard time trying to get out the answers to the questions i ask it because i m microsoft database question unsure how to ask My database consists of cards from texas holdem games that i have played it goes like this there are five columns containing flop flop flop turn and river Each title has a card value in it with either a letter or number representing the value of the card and also a letter representing which suit the card is S for spade d for diamond etc So the database is in rows of five something like this flop flop flop turn river Ad Qd Ah s Kc Nothing complex What I want to ask it is how many microsoft database question time that out of of the first columns are the same suit either specifically or independently I guess i would need to use a formula for this but am usure how to do it Also I want to know the standard deviation between each of the two suited flops happening Thanks nbsp

A:microsoft database question

Are you sure it's a database? You'd probably be better off using a spreadsheet, then you could use a formula such as

=(RIGHT(A1,1)=RIGHT(B1,1))+(RIGHT(B1,1)=RIGHT(C1,1))+(RIGHT(A1,1)=RIGHT(C1,1))

, which returns "1" if 2 of 3 match or "0" if 0 of 3 match. Ugly I know, but it's all I can think of for now.

HTH,
Andy
 

https://forums.techguy.org/threads/microsoft-database-question.248430/
Relevancy 52.03%

i have the latest version of works and am having a problem with it.

when using the left scroll arrow....it gets "stuck" therefore not allowing me access to several of the fields on the left side of the document

i have played around with it and can't seem to get around it

can anyone help?
thanks
 

https://forums.techguy.org/threads/microsoft-works-database.736764/
Relevancy 52.03%

Hi I Microsoft database question have a datbase in microsoft works that i m having a hard time trying to get out the answers to the questions i ask it because i m unsure how to ask My database consists of cards from texas holdem games that i have Microsoft database question played it goes like this there are five columns containing flop flop flop turn and river Each Microsoft database question title has a card value in it with either a letter or number representing the value of the card and also a letter representing which suit the card is S for spade d for diamond etc So the database is in rows of five something like this flop flop flop turn river Ad Qd Ah s Kc Nothing complex What I want to ask it is how many times that out of of the first columns are the same suit either specifically or independently I guess i would need to use a formula for this but am usure how to do it Also I want to know the standard deviation between each of the two suited flops happening What I m basically asking is how do you filter each record for items that match It seems simple in theory but I cannot figure out how to do it Thanks nbsp

Relevancy 52.03%

[ I have a dell 4700 running windows XP home edition. It came with quatro pro and word perfect software. I had one HP 3745 printer and everything worked fine.
a few months later I bought Microsoft Works Suite 2006 and installed it. Everything seemed to be OK. A few months later I bought and installed a HP all in one scanner 1600 series. Everything running fine.
Yesterday I tried printing some data from Microssoft spread sheet and I got this message.
Printer driver is missing or invalid. Run windows setup program to install printer software again.

All other applications print with no problems. What can be wrong here?
 

A:printing Microsoft database

When you have the "Microsoft spreadsheet" (whatever that is, assume the Works spreadsheet?) open, select File-Print and see what printer is selected as the default?
 

https://forums.techguy.org/threads/printing-microsoft-database.472749/
Relevancy 51.6%

please help to me to find out the solution of the password problem in my laptop , its windows 7 and the problems is i m typing the correct password but its saying password login failed ?? what to do ? ,the password which i am loging with its absolutely correct please help me out

A:Password Access Problem ??

Are you the only person who uses the machine? How do you know when a politician is lying? His mouth is moving.

http://www.computing.net/answers/security/password-access-problem-/39657.html
Relevancy 51.17%

Hi, I have a large list of items in a database that are numbered using a numbering row.They are then filtered to match certain criteria.So now the number row is no longer consecutive.What I want to do is make a new number row that tells me the occurence of each record happening.For instance,if my database stats at number 3 then the next number is 7,i want to have 7 -3 to give four.Basically,I want to know the distance between each record.If I could use a formula for the whole number row that would take a record and minus it from another?Thanks JIM
 

A:microsoft works database question

Help me please
 

https://forums.techguy.org/threads/microsoft-works-database-question.253761/
Relevancy 51.17%

I have experience with MS Exchange Server 2013 for two years. But today I have seen - Corrupted header information, when I opened program. How did it happen? What to do?

http://www.tenforums.com/software-apps/54187-microsoft-exchange-server-database.html
Relevancy 51.17%

Hi - and thanks in advance for your help.
When I ask to play the song "When" (Artist - the Kalin Twins) in Media Player,
credit for writing the song is given to Clint Ballard, Jr. Clint managed the Twins at the time that "When" hit the charts. He didn't write the song.

The correct writers are Jack Reardon and Paul Evans.
How do I correct the error in the database?
 

https://forums.techguy.org/threads/error-in-microsoft-music-database.724597/
Relevancy 51.17%

How can I get my MS Works database files to be able to be transferred to another program such as Open Office or Office? I have a lot of collected information in many files that I can't share with anyone else who doesn't have Works. The Office Database is far too complicated for me and much more powerful than I need for my own use.
 

A:Microsoft Works Database files

Did you TRY exporting?

A typical choice for database conversions is to export -> CSV format and then work with that
to create the imports. Hint: Export only one TABLE at a time.
 

http://www.techspot.com/community/topics/microsoft-works-database-files.207807/
Relevancy 51.17%

Does anyone know how to disable the wheel on a wheel mouse in an access application. I have set up a database which selects a particular record on a form. I have removed the record selector buttons in the preferences area, so with a regular mouse, the user cannot change records. However, if the user scrolls down the form with a wheel mouse, the page scrolls down, AND the record information in all the fields changes as well.
 

A:Microsoft Access Problem

If you are looking to simply disable the wheel on certain computers, the program that controls the MS wheel mouse has an option you could try. The tab "Wheel" near the bottom has a box named Exceptions which allow you to select Programs that you dont want the wheel functions to work within.
 

https://forums.techguy.org/threads/microsoft-access-problem.36318/
Relevancy 51.17%

In a query where I have linked two tables together, I cannot seem to build an expression that will eliminate repeat labels when people are on multiple lists.

Table 1 includes name, address, etc. each entry has a number code; that code is referenced in Table 2 where each person is on multiple lists.

In my old database I could use a string includes symbol @ to eliminate repeat lables but I do not know what to do in Access? I need something that will tell the program to only list the person once instead once for every list they are on. Any help would be appreciated! - Mara
 

A:Microsoft Access problem

Mara:
In design view of the query, hit View-Totals. On the Total line of the number code field, select "First." That way it shows you only the first instance of each value in that field.
 

https://forums.techguy.org/threads/microsoft-access-problem.36324/
Relevancy 50.74%

when I entered my roll number in the following site:-
Then after pressing "submit",it showed following error:-
plz help

I want to see my marks

A:Microsoft JET Database Engine error '80004005'

Is it computer problem or site problem ??

http://www.eightforums.com/network-sharing/23679-microsoft-jet-database-engine-error-80004005-a.html
Relevancy 50.74%

afternoon techies I ve been having a nuisance of a time with Access I need to VBA not Microsoft my in objects does display database the Solved: access VBA for one of the objects in my database a form to be exact and for whatever reason VBA does not display any of the objects in my database when I open the it Funnily enough it doesn t happen with other databases it only happens with the one I am currently using As far I can recall I never changed any settings in the database for this to occur My database is simple as it only contains a table and forms Any idea as to what could be going on here It would be fantastic if I can get an immediate response because I need Solved: Microsoft VBA does not display the objects in my database to get this project finished by the end of this week and I really need to gain access to VBA Thanks for your help guys May I further add this problem was not around yesterday only upon starting Access today did it occur I ve tried to use VBA with databases but only one was successful nbsp

Relevancy 50.74%

After a major crash I lost all of the Works Suite and had to reinstall it. Now the database crashes everytime I try to use it. Norton intercepts the crash and gives me this message:
OleMainThreadWndName
Everything else in the Suite works fine.
I need some help.
Thank you
Bonnie
 

Relevancy 50.74%

Does anyone know the location of the Micrososft Security Essentials database as I need to set up an event trap to prevent myself from inadvertently disconnecting from the internet whilst any update is in progesss?

A:Microsoft Security Essentials database location

Copy and paste this filepath into the Run field, but I don't hold out any promises it's the correct answer.

C:\Documents and Settings\All Users\Application Data\Microsoft\Microsoft Antimalware

http://www.sevenforums.com/system-security/185837-microsoft-security-essentials-database-location.html
Relevancy 50.74%

Hey all. My dad is having an issue with his computer that I've been unable to figure out, whether by my own means or just by searching. He is running Microsoft Works 6.0 on Windows Vista 32bit Home Edition, and is having some trouble printing from Works Database, which he uses quite a lot.

Whenever he tries to print something from Database (or go into print preview) he gets the following error:


Code:
The printer driver is missing or not valid.

Run the Windows Setup program to install the printer software again.
Naturally I have uninstalled and reinstalled the printer several times, but to no avail. Also an important note: This issue ONLY happens with Works Database, and not with any other product (Microsoft or otherwise).

If anyone has any suggestions it would be greatly appreciated
 

A:Microsoft Works Database printing issue

I have been doing more research and I'm starting to think that there is just a compatibility issue. I'm still wondering if anyone knows how to make this work with Vista.

If anyone has any suggestions on a program that is an alternative to Microsoft Database, that would also be pretty helpful. It's the only program my dad uses from the Works Suite.

Thanks again...
 

http://www.techspot.com/community/topics/microsoft-works-database-printing-issue.127443/
Relevancy 50.74%

Since installing Windows 10, I need to print a DVD database that I created on Microsoft Works Suite 2005. The error message I receive is "no default printer" or some such wording. The default printer IS set, and printing from any other site or app works fine. The laptop is a Lenovo, and the printer is Kodak. However, I do not see that the problem is in either of those, since it prints other things. When I look at compatibility for Windows 10, it reads that the Works 2005 is compatible. Please help, as frustration abounds. Thanks.
 

https://forums.techguy.org/threads/printing-database-from-microsoft-works-with-windows-10.1153754/
Relevancy 50.74%

hi,
Recently I have not been able to access microsoft websites - cannot tell exactly when - but when I try to access any using AOL and IE explorer I get "the web address you entered could not be found"
I can access all other website and my internet settings appear to be ok.
Why is this?
thanks

A:Microsoft websites - access problem

Make sure you have internet connection and can access other web sites in IE. You cannot access Microsoft's Windows Update through the AOL browser. You must use IE. In IE go to Tools/Windows Update. Does that work?

http://www.techsupportforum.com/forums/f10/microsoft-websites-access-problem-626878.html
Relevancy 50.74%

Please send me the most complex syntax for an update query of an Access 97 or 2000 database that you have on any of your databases.

I'm having trouble with syntax and syntax only and I'm having a hard time finding some samples on the Internet.

I'm getting error messages on syntax and I know enough about Access to know that I'm asking for the right results, just not in the right way.

Thanks,
 

Relevancy 50.74%

Browser MisroSoft problems -------------------------------------------------------------------------------- I cannot access any Microsoft XP BROWSER/ Access Problem WIN M'Soft WIN XP BROWSER/ Microsoft Access Problem url That is Update Media Catalog also same problem with Symantec I was using Norton System Works got a problem virus- I guess and couldn't get it to work and could not contact them At the time I had service pack loaded I found Grisoft AVG thru Raging Bull PC Advice board Downloaded it and uninstalled NSW Over the course first two days of testing AVG found the I-Worm bagel in twenty six files which are quarantined It is only in the last two days that I found I colud not access any MS sites Today with help I ran vcleaner exe in safe mode Did not help I am on DSL and called my service provider but they claim there is nothing in their firewall that would block anything I also have used Firefox and upgraded to But just yesterday quit that I have reloaded F'fox but am told to use IE only til problem is solved Sorry for such a long post but I am not familiar with this type thread Any comments can be made by e-mail as well as here OK with me THANX Have had this problem investigated at another forum and it was recommended that I bring it to this forum Tech Support Forum

A:WIN XP BROWSER/ Microsoft Access Problem

Hi nigel
In case you didnt know, MS doesnt play nice with FF, but symantec should. There may be deeper issues here but a good place to start is as follows.

If you haven't already, download, install, update immediately, then run AdawareSE. Make sure to customize the settings in Ad-aware for better scan results.

Then download, install, update immediately Spybot S&D.

Have each fix whatever problems they may find.

Next, run an online virus scan at TrendMicro or RAV Antivirus.
Please select the autoclean option when using Trend Micro.

Then get HijackThis . This program will help us determine if there are any spyware/malware on your computer. Run the scan, save the log, but do not fix anything yet. Many files it finds are harmless, and required for your system to operate.

Post your log in a new thread in the HijackThis Log Help forum. This our dedicated spyware/virus forum. One of the expert analysts there will look over your log and assist you. Please include a brief description of the problem you are having and what you have done to fix it so far.

http://www.techsupportforum.com/forums/f10/win-xp-browser-microsoft-access-problem-51216.html
Relevancy 50.31%

I have been running the software entitled WebResearch by Macropool on my Windows machine for quite a while with no problems Then about weeks ago it failed to start up and presented me with the following error message quot Microsoft Jet Database Module is broken or not present on your system quot In the days preceding this problem I had run the following on my computer BitDefender Antivirus TuneUpUtilities and SpeedUpMyPC I don t believe this last one made any changes as it was just the trial that demonstrates what the program could do if you purchase it I or is Database "Microsoft your present Module system" broken on not Jet really would prefer not "Microsoft Jet Database Module is broken or not present on your system" to do a System Restore because I spent hours hassling with installing a Roku box and messing with my router over Christmas I don t want to go through all that again I m hoping perhaps there may be an easier way to fix this problem Everything else seems to be working just fine Just that one program won t start Below is my HijackThis log I am also attaching a PDF of my initial problem report to WebResearch as well as their response I would be most grateful for any recommendations on how to address this issue GingerthreadsLogfile of Trend Micro HijackThis v Scan saved at PM on Platform Windows WinNT MSIE Internet Explorer v Boot mode NormalRunning processes C Program Files x Google GoogleToolbarNotifier GoogleToolbarNotifier exeC Program Files x Ashampoo Ashampoo Snap ashsnap exeC Program Files x Microsoft Office Office ONENOTEM EXEC Program Files x Shield shieldtray exeC Users Robin AppData Local Google Update GoogleCrashHandler exeC Program Files x Common Files Java Java Update jusched exeC Program Files x Mozilla Firefox firefox exeC Program Files x Microsoft Office Office OUTLOOK EXEC Program Files x Trend Micro HiJackThis HiJackThis exeC windows SysWOW DllHost exeR - HKLM Software Microsoft Internet Explorer Main Default Search URL http go microsoft com fwlink LinkId R - HKLM Software Microsoft Internet Explorer Main Search Page http go microsoft com fwlink LinkId R - HKLM Software Microsoft Internet Explorer Search SearchAssistant R - HKLM Software Microsoft Internet Explorer Search CustomizeSearch R - HKLM Software Microsoft Internet Explorer Main Local Page C Windows SysWOW blank htmR - HKCU Software Microsoft Internet Explorer Main Window Title Poet Where Is Your Pen R - HKCU Software Microsoft Windows CurrentVersion Internet Settings ProxyOverride localR - HKCU Software Microsoft Internet Explorer Toolbar LinksFolderName O - BHO AcroIEHelperStub - DF C-E AD- -A -FA C EBDC - C Program Files x Common Files Adobe Acrobat ActiveX AcroIEHelperShim dllO - BHO WebResearch Browser Helper Object - E - DC- - -D B C DBEF - C Program Files x WebResearch WRShell dllO - BHO Windows Live ID Sign-in Helper - D - C - ABF- ECC- C - C Program Files x Common Files Microsoft Shared Windows Live WindowsLiveLogin dllO - BHO Google Toolbar Helper - AA ED - DD- d - -CF F - C Program Files x Google Google Toolbar GoogleToolbar dllO - BHO SkypeIEPluginBHO - AE - E C- ED - F B-F F A - C Program Files x Skype Toolbars Internet Explorer skypeieplugin dllO - BHO Google Toolbar Notifier BHO - AF DE - D - -B FA-CE B AD D - C Program Files x Google GoogleToolbarNotifier swg dllO - BHO URLRedirectionBHO - B F A - E - -BA - B E FF - C PROGRA MIF BA Office URLREDIR DLLO - BHO LMS KnowledgeWorkshop Browser Helper Object for Internet Explorer - C BE E - - B - - BC DD CDD - C Program Files x LMS KWorkshop LdKWIExploreAddin dllO - BHO Java Plug-In SSV Helper - DBC -A - b-BC - C C C A - C Program Files x Java jre bin jp ssv dllO - BHO TOSHIBA Media Controller Plug-in - F C -EFFA- d -B - B B B - C Program Files x TOSHIBA TOSHIBA Media Controller Plug-in TOSHIBAMediaControllerIE dllO - Toolbar Ultra Recall - C C- A - f e-B AF- E BBD - C Program Files x UltraRecall Integration IEToolbar dllO - Toolbar Google Toolbar - C B - - d - B ... Read more

A:"Microsoft Jet Database Module is broken or not present on your system"

Hello and welcome to Bleeping ComputerWe apologize for the delay in responding to your request for help. Here at Bleeping Computer we get overwhelmed at times, and we are trying our best to keep up. Please note that your topic was not intentionally overlooked. Our mission is to help everyone in need, but sometimes it takes just a little longer to get to every request for help. No one is ignored here.If you have since resolved the original problem you were having, we would appreciate you letting us know. If not please perform the following steps below so we can have a look at the current condition of your machine. If you have not done so, include a clear description of the problems you're having, along with any steps you may have performed so far.Upon completing the steps below I will review and take the steps necessary with you to get your machine back in working order clean and free of malware.Thanks and again sorry for the delay.Download OTL to your desktop.Double click on the icon to run it. Make sure all other windows are closed and to let it run uninterrupted.When the window appears, underneath Output at the top change it to Minimal Output.Under the Standard Registry box change it to All.Check the boxes beside LOP Check and Purity Check.Click the Run Scan button. Do not change any settings unless otherwise told to do so. The scan wont take long.
When the scan completes, it will open two notepad windows. OTL.Txt and Extras.Txt. These are saved in the same location as OTL.Please copy (Edit->Select All, Edit->Copy) the contents of these files, one at a time, and post it with your next reply.AndPlease download Sophos Anti-rootkit & save it to your desktop.alternate download linkNote: If using the vendor's download site you will be asked to register with MySophos so an email containing an activation link can be sent to your email address.Be sure to print out and read the Sophos Anti-Rookit User Manual and Release Notes.Double-click sar_15_sfx.exe to begin the installation, read the license agreement and click Accept.Allow the default location of C:\Program Files\Sophos\Sophos Anti-Rootkit and click Install.A message will appear "Sophos Anti-Rootkit was successfully installed. Click 'yes' to start it now".Click Yes and allow the driver and its randomly named .tmp file (i.e. F.tmp) to load if asked.If the scan did not start automatically, make sure the following are checked:Running processesWindows RegistryLocal Hard DrivesClick Start scan.Sophos Anti-Rootkit will scan the selected areas and display any suspicious files in the upper panel.When the scan is complete, a pop-up screen will appear with "Rootkit Scan Results". Click OK to continue.Click on the suspicious file to display more information about it in the lower panel which also includes whether the item is recommended for removal.
Files tagged as Removable: No are not marked for removal and cannot be removed.Files tagged as Removable: Yes (clean up recommended) are marked for removal by default.Files tagged as Removable: Yes (but clean up not recommended) are not marked for removal because Sophos did not recognize them. These files will require further investigation.Select only items recommended for removal, then click "Clean up checked items". You will be asked to confirm, click Yes.A pop up window will appear advising the cleanup will finish when you restart your computer. Click Restart Now.After reboot, a dialog box displays the files you selected for removal and the action taken.Click Empty list and then click Continue to re-scan your computer a second time to ensure everything was cleaned.When done, go to Start > Run and type or copy/paste: %temp%\sarscan.logThis should open the log from the rootkit scan. Please post this log in your next reply. If you have a problem, you can find sarscan.log in C:\Documents and Settings\<username>\Local Settings\Temp\... Read more

http://www.bleepingcomputer.com/forums/t/369681/microsoft-jet-database-module-is-broken-or-not-present-on-your-system/
Relevancy 50.31%

Ok I have one more question-a few people have other versions of Access in my program and need to use the database that I created in Access 97. A few people tried and couldn't open it. Is there an easy way to converting this so they can use it on their computers? Thanks for the help.
 

A:Access 97 database in Access 2000?

Access should prompt them to either open the DB file or convert it to the newer version on startup. If it doesn't you can open the newer version of Access and go to Tools > Database Utilities > Convert Database.
Warning: Everything in your DB may not convert properly so be ready to do some work if this happens.
 

https://forums.techguy.org/threads/access-97-database-in-access-2000.443343/
Relevancy 50.31%

Hi everybody I have a problem with my MS Access and can amp t use the wizard for creating database objects forms report table queries etc Whenever I choose Wizard option to create those database objects I get the following error message Microsoft Access can amp t find the wizard or there is syntax error in the Declaration section of a Visual Basic module Wizard Can't access Access MS database The wizard you need may be missing from the libraries key of the Can't access MS Access database Wizard Microsoft Access section of the Windows Registry To make sure that the wizard is in the Windows Registry run Setup to reinstall Microsoft Access and the compile all Visual Basic modules in the database I reinstalled the MS Access as instructed in the message but I don amp t know where to find and compile those Visual Basic modules I also don amp t know how to get to libraries key of the Microsoft Access section of the Windows Registry I tried to reinstall the software by using two different versions of software CDs MS Office and XP and both failed to solve the problem I also tried unsuccessfully to access Add-Ins feature from the Tools menu in order to add the missing component Please help me ishak nbsp

A:Can't access MS Access database Wizard

Funny I had the same error last night. I ran Setup from the CD (from RUN prompt) checked off the access wizard. Then went and did what I was doing, it still asked to install the feature but it worked that time.

If that does not help the is an MS article, basically, if you are in "Break mode" of a module that could also cause it.

http://support.microsoft.com/kb/208204/en-us
 

https://forums.techguy.org/threads/cant-access-ms-access-database-wizard.553449/
Relevancy 49.88%

Using Windows 10 and Chrome Browser.
This involves Hotmail, OneDrive, OneNote.
---------------------------------------------
When accessing my Hotmail yesterday, MS notified me that there was suspicious activity that someone tried to login my email account and advised me to change the PW. I did it.

Today when I turned on my computer, It said that I failed to login to OneDrive (I did not try to access OneDrive to begin with, I just powered up my computer). It asked me to login.
I typed in the New PW that I just established yesterday. It took it, but asked me to change the PW again (I just did it last night). So, I changed the PW again (because OneDrive asked me to change.)

Now I can not access MS OneNote. OneNote doesn't recognize the new PW. Please help.

Sure appreciate very much.

http://www.tenforums.com/user-accounts-family-safety/58192-password-word-problem-can-not-access-onenote-anymore.html
Relevancy 49.88%

Posted this in Operating Systems forum shoulda read the board topics on Access Problem Microsoft Hyperlink 2000 a little closer sigh Operating System Win Problem with MS Access Issue Hyperlinking ------------------ You click on the form field called Message Subject and it tells me the following msg Unable to access http message subject filename so then I click OK What I want to do is be able to click Hyperlink Problem on Microsoft 2000 Access on this field and it will automatically open up what I want to see which is the File of the message subject Now my question is how do I fix this problem and either direct it to the drive and folders the files are stored and or if I can make it look for keywords in the field s message subject that it will look for and open the right one too Do I or should I a create a localhost page that way all the files will open up b is there some other way that I am just too narrow minded to see and figure out myself and maybe you guys can help me out Thanks if you can Kind Regards Joseph A Medeiros I ll be checking for updates on this and also be looking forward to any emails you may send my way at email protected or email protected Thanks again nbsp

Relevancy 49.88%

I've been improving the design of an Access database that I created some time ago. One of the MsgBox "helpful info" boxes that I added a long time ago no longer applies, but I cannot locate it to edit or delete it. It probably was created in Access 2003, and I am now using Access 2007. Is this the problem? How do I solve it?

Thanks for any help you can give me!
 

A:Solved: Microsoft Access 2007 problem

Hey Jahfgh,

Mostly anything created in 2003, you should be able to find in 2007.

Is the msg box attached to a form or report? Did you check the macros and/or VBA code attached to that specific form or report in Design view? Also while in Design view you can check the code for that form/report by clicking on the "design" tab (in the ribbon) and then clicking on the icon next to the property sheet (in the Tools section...far right ribbon in the Design tab) that's a a square w/ blue (bottom left corner), red (top) and yellow dot (bottom right corner) of the square (not sure what it's called).

Also while in the Microsoft Visual Basic window you can use the find function just like in Word by going into Edit and clicking on Find or using Ctrl + F.

If none of the above works, maybe post a zipped version of your database minus the confidential info.

Hope this info helps.

Best,
Zhouma
 

https://forums.techguy.org/threads/solved-microsoft-access-2007-problem.891434/
Relevancy 49.88%

Operating System Win Problem with MS Access Microsoft Hyperlink on Access Problem 2000 Issue Hyperlinking Hyperlink Problem on Microsoft 2000 Access ------------------ You click on the form field called Message Subject and it tells me the following msg Unable to access Hyperlink Problem on Microsoft 2000 Access http message subject filename so then I click OK What I want to do is be able to click on this field and it will automatically open up what I want to see which is the File of the message subject Now my question is how do I fix this problem and either direct it to the drive and folders the files are stored and or if I can make it look for keywords in the field s message subject that it will look for and open the right one too Do I or should I a create a localhost page that way all the files will open up b is there some other way that I am just too Hyperlink Problem on Microsoft 2000 Access narrow minded to see and figure out myself and maybe you guys can help me out Thanks if you can Kind Regards Joseph A Medeiros I ll be checking for updates on this and also be looking forward to any emails you may send my way at email protected or email protected Thanks again nbsp

https://forums.techguy.org/threads/hyperlink-problem-on-microsoft-2000-access.238845/
Relevancy 49.88%

Hello ,

I have three tables

1. Company Name Table
2. Address Table
3. Contact Person Name Table

Primary Key of Customer Name is cusid and the other tables are linked to this Company table by this Cus ID .

I have a requirement in which I have to write a query to get data from all these tables .Now it is easily possible if all the three tables have data for one Cusid ie 3 . But the problem is if any one of the table i.e Contact person name for a Cust id =3 THERE IS NO DATA but has address at cust id= 3 my query fails .I know a join can help me to get data from 2 tables but i am not sure how a join will help me to get this data from three tables even though there may not be data in one of the table.
Please HELP !!
 

Relevancy 49.88%

Hello there a friend of mine pointed me in the direction of this website as im a little stuck and was after a little help So last week i got a little virus hundreds of pop ups I then switched my pc off only for it not to turn back on windows just kept kinda clicking over and restarting before getting to the main screen I tried going in on safe mode but it wasnt happening so i decided to re-install windows So this all goes fine get my computer to turn back on and although its completely bare its working I re-install my Microsoft Windows Problem Access? Virus? cable broadband and set about re-installing all the old programmes Which is when i get my problem any time i try to access a microsoft site to download an update for say windows media player i just get this Address Not Found Firefox can t find the server at www microsoft com Also when i go on google to go on a website its linking me to all kinds of rubbish youtube videos and plenty of spyware antivirus Windows Problem Virus? Microsoft Access? adverts instead of the page im trying to get to Ive run both Windows Problem Virus? Microsoft Access? Search and destroy and Malwarebytes But im still getting the same problem This is my HijackThis log Logfile of HijackThis v Scan saved at PM on Platform Windows XP SP WinNT MSIE Internet Explorer v SP Running processes C WINDOWS System smss exe C WINDOWS system winlogon exe C WINDOWS system services exe C WINDOWS system Windows Problem Virus? Microsoft Access? lsass exe C WINDOWS system svchost exe C WINDOWS System svchost exe C WINDOWS system spoolsv exe C WINDOWS system cisvc exe C Program Files Java jre bin jqs exe C WINDOWS System snmp exe C WINDOWS System svchost exe C WINDOWS Explorer EXE C Program Files BroadJump Client Foundation CFD exe C Program Files Analog Devices Core smax pnp exe C Program Files Java jre bin jusched exe C Program Files DellSupport DSAgnt exe C Program Files Spybot - Search amp Destroy TeaTimer exe C WINDOWS system cidaemon exe C Program Files Mozilla Firefox firefox exe C Program Files Windows Live Messenger msnmsgr exe C WINDOWS Microsoft NET Framework v mscorsvw exe C Program Files Kontiki KService exe C Documents and Settings Frankie Cornell Desktop HijackThis exe R - HKCU Software Microsoft Internet Explorer Main Start Page http www virginmedia com O - BHO Spybot-S amp D IE Protection - - F - D - - D F - C Program Files Spybot - Search amp Destroy SDHelper dll O - BHO no name - E D - A- EC-A -BA D E E - no file O - BHO Java tm Plug-In SSV Helper - DBC -A - b-BC - C C C A - C Program Files Java jre bin jp ssv dll O - BHO JQSIEStartDetectorImpl - E E F - CE- C -BC -EABFE F C - C Program Files Java jre lib deploy jqs ie jqs plugin dll O - HKLM Run BJCFD C Program Files BroadJump Client Foundation CFD exe O - HKLM Run SoundMAXPnP C Program Files Analog Devices Core smax pnp exe O - HKLM Run SunJavaUpdateSched quot C Program Files Java jre bin jusched exe quot O - HKLM Run oD quot C Program Files Kontiki KHost exe quot -all O - HKCU Run DellSupport quot C Program Files DellSupport DSAgnt exe quot startup O - HKCU Run MessengerPlus quot C Program Files MessengerPlus MsgPlus exe quot WinStart O - HKCU Run msnmsgr quot C Program Files Windows Live Messenger msnmsgr exe quot background O - HKCU Run SpybotSD TeaTimer C Program Files Spybot - Search amp Destroy TeaTimer exe O - Extra button no name - DFB A - F - C -A - CAB FD A - C Program Files Spybot - Search amp Destroy SDHelper dll O - Extra Tools menuitem Spybot - Search amp amp Destroy Configuration - DFB A - F - C -A - CAB FD A - C Program Files Spybot - Search amp Destroy SDHelper dll O - Extra button Messenger - FB F -F - d -BB E- C F - C Program Files Messenger msmsgs exe O - Extra Tools menuitem Windows Messenger - FB F -F - d -BB E- C F - C Program Files Messenger msmsgs exe O - Protocol livecall - A - C - - F- E F - C PROGRA WI F MESSEN MSGRAP DLL O - Protocol msnim - A - C - - F- E F - C PROGRA WI F MESSEN MSGRAP DLL O - Service Java Quick Starter... Read more

A:Windows Problem Virus? Microsoft Access?

bumpety bump anyone?
 

https://forums.techguy.org/threads/windows-problem-virus-microsoft-access.809398/
Relevancy 49.88%

My husband is taking at Access class His assignment was to create and print a pivot table chart No problem It went slick and LOOKED good on the screen till he printed it It came out as a mirror image If you held it up in the mirror everthing was correct looking Even stranger the title of the query which was quirky problem Microsoft Very Access printing used for the pivot table printed CORRECTLY on top EVEN STRANGER to look at the graph right after it was done all the axis figures were correct when he went to print preview the numbers along the axis had changed but at least they werent in mirror image in print Very quirky Microsoft Access printing problem preview it LOOKED Very quirky Microsoft Access printing problem ok but when printed it came out mirror image Everything else prints fine WinXP OS and HP OfficeJet K printer I have never in years of dealing with applications and printers seen anything like this Anybody have any thoughts It would be greatly appreciated OH by the way husband re-did project at school and it printed fine Again any ideas would be appreciated Thanks much nbsp

https://forums.techguy.org/threads/very-quirky-microsoft-access-printing-problem.350288/
Relevancy 49.88%

Hello I'm glad to have found this forum and hope someone can query Microsoft running Access - Problem help me I am a new Access user within the past months My company already had all of their databases Microsoft Access - Problem running query set up when I came so it was easy enough to just add or edit information Now I have been asked to set up a query based on certain fields in one of the tables I'll try to be brief with this We have a table containing all of our client information name address phone numbers date of their appointments who referred them clothing sizes etc For the new query we only need their name who referred them the date of their appointment and the phone numbers We want this new query only to show people in the past months for our follow up person to call When I tried to create and run the query it gave me just the fields I wanted but of course gave me all dates going back to Again I only want to see from January to present So I sorted it by date and deleted everything prior to Jan We do want the new information from the client table to keep updating in the new query we just don't want the old stuff I had the list whittled down all looked good and then bam - I saved the new query and closed it and when I went back to the client table everything prior to Jan was deleted from there too Luckily we had a back up and were able to restore it except that now the primary key numbers are wayyyy off but we really don't use that anyway So is there a way to create this query that I'm talking about without losing all the data on the original table I noticed that after we restored the original table all of the old information came back to the new query as well Thanks in advance for any help

A:Microsoft Access - Problem running query

The answer to your final question is YES.
We have a bit of a problem with terminology here.
I'm not sure whether you do or do not want to delete all data prior to 6 months back. Let's assume you don't. Under normal (non-maintenance) circumstances, queries are used just to retrieve records you want to see.

In the query pane, under the fields is a Criteria row.
Look in HELP for Criteria.
I'll try to give you some pseudo-syntax.
What you need is to write something to the effect fieldName>=Today()-180 (roughly 180 days), the syntax might be Now()-180 (or is that in Excel?). Or you can fix the date and say >= '1/1/2005' (again, look in help for exact syntax), though I would not recommend ever using a constant or every couple months you'll have to edit the query to be current.

An alternative is to ask the user for a date range to display. I think that's called parameter queries in Access. Again look it up in help.

I haven't used Access in couple years, but I believe if in the query designer you double click in the cell under the field name, Access takes you to the expression writer where your fields and allowed function are displayed. Between help and the functions which you paste quite easily, nesting included, I think you'll get what you want this query to return, with your data untouched, as I feel it should be unless your company dictates otherwise.

In the same grid of fields and rows, you can specify the sequence of fields by dragging them around and you can specify the sort.

Have fun

http://www.bleepingcomputer.com/forums/t/22289/microsoft-access-problem-running-query/
Relevancy 49.88%

I have created a tracking program using access the main tracking page contains name address phone numbers computer information etc I also have two fields that I insert the problem and then the fix then that is printed out to give to the customer whenever the customer brings their computer back in for service I do a search for their account and it brings up all the pre existing info There last problem and cure are still in there I access database would like to find some way if it s possible to make this dump the items to a database for each customer in case I want to go into it again and look at past events Then the next time I open their account the problem and cure fields are empty but their data past problem and cure will still be in there I almost have this program or database to where it will do everything that I want it to do Any help would be very much appreciated Thanks chad nbsp

Relevancy 49.88%

I have an access data base program that we use as our special orders program, we use to be able to have more than one person log into this, but now only one at a time is able to.. The file is shared for all users.

thanks.
 

Relevancy 49.88%

What I have done is combine the Order Entry, Inventory Control and Customer Management databases together in Access 97 and Iím trying to get them to work together to be able to update when inventory comes in and goes out of my business.

Iím trying to figure out how to complete the actual receipt of merchandise on a purchase order in the database. I want to put in the current date or earlier (I may use yesterday's date when I finally get around to entering data) as my variables for the timing to update the inventory transaction table (units received and units on hand fields).

Can you give me the operators and operands in the expression builder and the complete proper syntax that I would need to tell an event has happened and to update the table.

Thank you in advance - you guys are so good!!
 

Relevancy 49.88%

Hi all,

I have an issue with an access database. When I print out a report one of my columns only prints out 4 out of the 5 digits. This happens with 2 machines. On other pcs the 5 digits appear in output of the report. I have checked the resolutions of the pcs and they are the same. I have expanded the column widths in design view and still the problem persists. I cannot figure out why only 4 digits appear out of the 5.

Can anybody help?

thanks