Search results

I have an access database on a server. Everyone the data and front end are both on the server. Problem: I need ODBC drivers to get to data on a SQL server. When link to the data on one machine, it works fine. But some machines the ODBC connection doesn't work! I have to update using the...

The mysterious error message "You can't perform that action at this time", number 2486 is appearing and ruining my life. The debug takes me to loads of different spots, such as commands to save, commands to print, etc. Code just seems to break down. Now, the thing is, it only happens when...

I am working at a company that has installed Access 2000 from Disc 19 of the Office Test Platform & Development Tools CDs, date June 1999. Debugging does not work here - that is to say, either I haven't done something to turn it on, or it is missing from the CD. The company, ahem, does not...

A random and mysterious error 2486 "You can't carry out that action at the present time" appears, sort of freezes people's machines, and makes them angry at me. I can find no documentation on this error whatsoever anywhere. If anyone has ever seen it before, please at least reply that it...

Networked, single source program, accessed by many users, SOME people have greyed out textboxes on some reports they print out. Why? Why? Tell me while I still have some hair.

I am the sole designer of a multiuser ordertaking system for a small company. When I put it on the network, numerous surreal messages began to appear, such as the one above, Error 2486. I also get alot, for NO apparant reason, Message 0, whose description is blank! Has anyone seen these...

SOME of my forms are giving me the same error. When a user makes a change, the program "may have encountered an error while trying to save a record"...Informs me that changes will be lost, and do I want to close it. Note, however, that changes are NOT lost, they are saved. What is up? The...

How to log in from an outside application (such as Java) to enter a Jet Secured database? It tells us we don't have permission, even though we are (trying) to provide it with userID and password. Any idea how to do this? In desperation, I just exported the tables to a new unsecured database...

I want to set the Visible property on some buttons to False based on the CurrentUser()'s Group membership. Is there some way to determine this? Users cant get to the admin functions, etc. On Load, I could check by currentuser's name, but they will change. How to code it based on group...

I need to add ID numbers (not autonumber) to a group of records, DMax() + 1. This works fine using a query when there is only one at a time, but records are appended in bunches and I need to make an easy function to add a non-unique identifier on. The user just wants to click a button to add...

When I try to use the 2000 Security Wizard, I get the cryptic message: "Object variable or With block variable not set" and I can't proceed any further. I am not using any class modules in the database - why does this come up? I also get error messages in some other wizards, such as "Only...

How to add a method? Its there in the library, the library is activated, VB recognized OldValue (it capitalizes it correctly when I type "oldvalue". But when I run it, it gives me error 438 - "Object doesn't support this property or method." the code looks like this: Private Sub...

I have a database I am converting from Aproach. I would like the ease of creating a filter in a form, then use that filter on (complex) pre-created reports. Something like a button to open reports, but show only the records that are currently filtered. Nowhere can I find anyway to do this...