Search results

a) My database had 7,000 records. b) Performance was acceptable when I used a form to review/edit records. The form source is a Query. c) I added 80,000 records. e) The performance dramactically decreased. It now takes 4 seconds on the form when I go to the next record. f) This will be a...

My fix has it's problems with multiusers.

I figured it out. 1) I changed my orginal table name from "data" to "all records" 2) I created a "Make-Table" Query that filters to the table "data" performance problem solved. hope this helps others.

I figured it out. 1) I changed my orginal table name from "data" to "all records" 2) I created a "Make-Table" Query that filters to the table "data" performance problem solved. hope this helps others.

I read that you can improve performance by using a saved Query instead of a sql Query. Rookie Question...how do I make a Query I created using the Wizard a Saved Query? My problem.... When my table has 7000 and I use a Query to bring it in the form, the speed of going to the next record is...

I'm trying to increase speed. I did all the common tasks, such as changing field types and compress and repair. 1) The database has a Table with 7000 records. When I open a form, I could press "next record" and go to the next record in less than a second. 2) I added 80,000 records. Now when I...

I'm planning on using the Security Wizard. But I don't know if there is a better alternative. I need to set up logons for 25 different users. Each user can only access their assigned data. The manager can access all data. What is the best way to incorporate user security/logon's? :confused...

Here's an example to create a form to add an appointment to Outlook. Of course the names can be changed and other fields can be added. Create the following table (name it tblAppointments) Field Name: Appt Data Type: Text Field Size: 50 Required: Yes Field...

Outllook Calendar I figured it out. It's awesome. I can now enter a Subject, Date and Time and with one press of the button, it adds an appointment to Outlook a a Pop up message appears to remind me of the appointment!

I would recommend starting with "The Complete Reference" Access 2002. It's affordable and easy to understand. I've designed a few DB's, I consider myself beyond the beginners stage and I find myself still using it. Good Luck!

I'm using MS XP. Can a Date I enter into my Access db automatically be sent to MS Outlook Calendar so I receive a pop-up message reminding me of the appointment? If so, how? thanks!