Search results for query: *

I have an interesting problem, and I wonder if anyone else has had the same effect: I created a FE/BE database at home in Access 2000 under Win 2000, with the latest versions of Jet and of the service packs. It ran well on my machine and on my client's network, where the Front-ends all ran on...

I have created a form that shows the user how much inventory is available at a given time for a given product or a category of products. They can then take an order for the quantity of the particular colour of product the client wants. Because the size range can vary from inquiry to inquiry...

I am trying to validate dates in a manner that is easier for the user than the input masks. But when I try to use an ISDATE(me!txtDate) in the BeforeUpdate event of my form, Access 2000 rejects the bad data before it gets to the BeforeUpdate. It seems to be seeing that the data is not a date...

I have a front-end/back-end database made up of about 10 related tables; I have been working to speed it up, and thought I had it working fine. I have just found out, however, that when I open a two copies of the database on separate workstations (connected by 100-base ethernet to a Win2000...

In thread181-31163, one repondent suggests that often networks can be tweeked to make it better for databases (rather than being optimized for email and file transfers). Can someone tell me how to do this, and whether this can be done with Windows ME? (Our Access backend is being served (for the...

I have a front end/back end Access 2000 db with 5 users, with 16 tables, and approx 450 records in the main table. A single user (all alone, no one else in the office, no other programs open) opens the form which accesses the main table (and links to several of the others; each link is on a...

When I was last at my client's office, working on their multi-user Access 2000 database (shared across an ethernet network of 5 users, with a 2Meg backend on the server and a 7Meg front-end on each machine), the database got slower and slower and finally crashed at the end of the day; the...

I get two errors when I try to add new records via a subforms on it: a) "The value you entered isn't valid for this field. For example, you may have entered text in a numeric field, or a number that is larger than the FieldSize setting permits." This occurs when I type a first...

I receive this error message "Records in table MasterListCodes would have no records on the 'one' side" at an odd time in my Access 97 database: I have just changed the numeric code for the industry of a particular company and in the AfterUpdate Event of the combo box I do a lookup...