Question about Microsoft Access 2000 Step by Step (1572319763) for PC

4 Answers

I have an ACCESS 2000 database I have been using for years. Suddenly, 3 problems have occurred. 1. Two command butons, FIND CLIENT and NEW CLIENT no longer function. I can use the BINOCULARS icon and the NEW icon on the status bar to perform the function but the command buttons will not work. 2. I had a calculated field to give me a client's annual salary. This no longer works. Instead the field now reads #NAME?. 3. I had a form listing all of the client's dependents. I can no longer add dependents to this form. All of these function have been working successfully for the last 4 years. They suddenly stopped functioning. Can you advise?

Posted by on

  • 2 more comments 
  • polkaman0510 Aug 03, 2009

    Need further assistance.

  • polkaman0510 Aug 03, 2009

    Accordingto Microsoft the hard limit on an Access dataase is 2GB and performance will take a hit over 250,000 records. Consequently, this should not be a problem.

  • polkaman0510 Aug 06, 2009

    Additional information: When I try using the referenced commnand buttons I get the following error message. " The expression on click you entered as the event property setting produced the following error: Ambiguous name detected; VISIT_click."

  • polkaman0510 Aug 12, 2009

    None of the previous solutions your "experts" have provided have solved the problems. If this continues I would like my money refunded.

    Thank you

×

4 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 1,555 Answers

From your current situation it seems that your backend is access and frontend is vb. Its going to be a very very long troubleshooting if we both did. If you get another access expert at your end it will be short and easy. Because we will exchange tables names and relations names and number of fields and source codes not command buttons names. I'd advise you under these circumstances either to call the programmer or put another person in front of me who has knowledge on access with relations and a bit of knowledge on java. Otherwise I will have to type a complete book out here. sorry for your inconvinience sir.

Posted on Aug 12, 2009

  • Aruna Singh
    Aruna Singh Aug 13, 2009

    All your 03 command button seems to be using one common public sub (.) which can be detected only by seeing the source code written inside them. I'd like to know whether the database you are using is in mdb format or it has been converted to mde or exe format. If it is in mdb format then you can easilly copy and paste the codes written inside these command buttons over here so i provide you with amendments.


    Secondly I'd like to know whether you have recently changed any regional settings in your control panel.


    Finally, exactly which software you installed or updated or what changes you made before you started getting these errors.


    These informations are crucial in order to provide solution to your problem.



×

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 813 Answers

Are you using the same version of Access to open the database in which it was created? Take a backup of the database first, open Access >> click on Help and then click on Detect and Repair. Let it complete and then check for the issue.

Posted on Aug 03, 2009

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 555 Answers

Hello,

Please open your database in openform view to see and edit your commands set under your command button. Also try to back up your database cause if something happens to worst then atleast you have save your data to any possible damage. Also try to see the link manager of your database and have it refresh in order to eliminate error such as in your problem 2. Also try to see if your database reached to more that 1000 data cause based on experience Microsoft Access has a limitation of 1000 data capacity beyond 1000 thet you can assure your data will work properly due to its limitations.

Thanks

Posted on Aug 03, 2009

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 11,896 Answers

Try to find any updates you can for this program and download them.
(copy and paste this link in your address bar)
office.microsoft.com/Downloads/2000/Out2ksec.aspx
This is the update.

This is an extra service pack you can also download.
www.granite.ab.ca/access/msfixes.htm

Make sure the program is allowed through any firewalls and last solution would be to reinstall the program or upgrade to new version.

Posted on Aug 02, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

8 Answers

Access database 2003 problem with a copy of database file. How to fix?


You say corrupt, in what way exactly? Do you get any specific error numbers/messages?

Have you tried Access repair program? Compact and Repair. If not, use it. But ensure that you made a backup, it is necessary because all the recovery tips can make the damage even worse.

Also try Jet Compact Utility. This tool created by Microsoft and it is much like Compact and Repair, but more successful in repairing.

If no one of above advice helps, then perhaps you need more powerful solution. In this case try to run a good third-party. I would recommend Recovery Toolbox for Access. It must help you. https://access.recoverytoolbox.com/

Feb 23, 2015 | Microsoft Access 2003 for PC

3 Answers

How to fix mySQL corrupt databases?


you should follow two steps:

Create an appropriately named database on the target machine
Load the file using the mysql command:
$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]
Have a look how you can restore your tut_backup.sql file to the Tutorials database.
$ mysql -u root -p Tutorials < tut_backup.sql
To restore compressed backup files you can do the following:
gunzip < [backupfile.sql.gz] ' mysql -u [uname] -p[pass] [dbname]
If you need to restore a database that already exists, you'll need to use mysqlimport
command. The syntax for mysqlimport is as follows:
mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql]

Or make use of Repair Toolbox for MySQL

Demo version is here-: http://www.sql.repairtoolbox.com/

Feb 08, 2015 | Microsoft SQL Server 2000 Standard Edition...

8 Answers

Access 2007 corrupted database


You may try this third party tool programmed with best technology the tool support all windows and MS office versions. You may try free demo version of this software to preview your recovered access database. SysTools Access Recovery you may check How tool works and its user friendly interface make this easy to handle.

Jan 11, 2015 | Microsoft Office Professional 2007 Full...

1 Answer

Syncing client with server - Restaurant Pro Express


Your getting a connection successful because your looking at the localhost. The server would be the network name of your server. And the password is case sensitive and is pcAmer1ca. (Note the number 1, not an i)

Jan 29, 2010 | Pc America Restaurant Pro Express

1 Answer

I installed DB2 in my laptop . then i go to all programs->DBCOPY1(default)-> command line tools -> command editor then write down query to create a table but i cant build it it is showing CREATE TABLE...


Hi,

Before you create a table you need to:-

1. create a database
2. create a username and password or use the admin generated userid
3. connect to the database

you can then create a table and use the database

Please post if you do not know how to do this and i'll give you some links

Dec 05, 2008 | IBM DB2 Connect Enterprise Edition for PC,...

1 Answer

MySQL Database


THE SYSTEM REQUIRMENTS ARE
MySQL Tools
1. A SQL server : This is an engine which provides access to your databases.
2. Client programs for accessing the server : A program allows you to enter queries directly and view results
3. A client library for writing your own programs : You can write your own programs into the client library using C.
Recommended Hardware Requirements For Mysql Installation
  1. Pentium V processor
  2. 128 MB RAM
Note that MySQL can be installed on a platform with as little as 32 MB
RECOMENDED SOFTWARE TOOLS for better performance
IT is recommended to have at least 128MB memory.
You can freely download MySQL from the website http://www.mysql.com MySQL runs on many varieties of UNIX, as well as on other non-UNIX systems, such as Windows and OS/2. MySQL runs on hardware from home PCs to high-end server. MySQL can be installed on Windows XP, Windows Server 2003, Red Hat Fedora Linux, Debian Linux, and others

Sep 08, 2008 | Sun MySQL

2 Answers

Compaq PE2160 with LINUX OS


Check to make sure all of your paths in the mount command are right. I had this issue a week ago and after putzing with it for a few days I noticed I was trying to mount a non-existent share. Fixed my ***** command and it worked right away. Other things to look at: Check your /etc/exports on the server and make sure the shares are in there. Also make sure that they are active by restarting nfs (/etc/init.d/nfsd restart (may be different now, that worked years ago)). Last, double check your mount command on the client. Make sure the share exists and the server is pingable. If this doesn't help, you may want to try searching on some linux specific forums. linuxquestions.org is good, or if you have ubuntu, ubuntuforums.com.

May 26, 2008 | Compaq Presario Desktop with Intel Pentium...

5 Answers

SQL SERVER 2000


Perform following steps to recover sql server database:
  • Create a database with same size that you are trying to recover
  • Shutdown the SQL server
  • Swap old mdf file with new mdf file
  • Start the SQL server
  • Database may go in suspect
  • Set database in emergency mode
  • Run DBCC CHECKDB with repair_allow_data_loss to repair database


USE [master]
GO
ALTER DATABASE [RdmStoreInformation] SET EMERGENCY
GO
ALTER DATABASE [RdmStoreInformation] SET SINGLE_USER
GO
DBCC CHECKDB ([RdmStoreInformation], REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE [RdmStoreInformation] SET MULTI_USER
GO
ALTER DATABASE [RdmStoreInformation] SET ONLINE


It may result some data loss. If you don't want to lose any single data then use 3rd party SQL repair software from Stellar Phoenix.

Mar 19, 2008 | Computers & Internet

1 Answer

Error 5


hi

check the permission of the share and also you may have to create a user just for sharing
This is a permission issue. If the net view command fails with a "System error 5 has occurred. Access is denied." message, 1) make sure you are logged on using an account that has permission to view the shares on the remote computer.
2) Need to cache credential: logon the same username and password on both computers or use net net use \\computername /user:username command.
3) Make sure the Netlogon service is running

the second question : it is a spyware

check this link in regards to clean t

Feb 13, 2008 | Microsoft Windows 2000 Professional for PC

1 Answer

SQL Server 2000


An easy way to transfer objects (tables, user defined functions, stored procedures, etc.) is to use Enterprise Manager's "Generate SQL" feature. Use this process at your own risk. Doing it wrong could mess up your existing database.

1. In Enterprise Manager, right-click on the old database and choose "All Tasks" then "Generate SQL Script".
2. In the dialog that comes up, click "Show All" then select the checkboxes for "all stored procedures" and "all user defined functions". (You might also want to check some other boxes, depending on your exact situation.)
3. Click the "generate" button and save the script that it creates.
4. Run the script in the NEW database.

If you run the script in your OLD database, it may destroy your objects, and that would be very bad. Make sure you run the script in your NEW database. (While we're on this subject, it's a good time to mention that you should back up your database before you start this process, and you should make changes to a test system before migrating it to production.)

That should move your stored procedures and user defined functions over.

You can use a similar process to move tables, views, users, and other objects over as well.

Jan 17, 2008 | Computers & Internet

Not finding what you are looking for?
Microsoft Access 2000 Step by Step (1572319763) for PC Logo

Related Topics:

58 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2727 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18391 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...