Recent content by KathyL

I have an Access DB with a few ODBC links to some tables in an external 3rd party My SQL DB. I'm able to use a similar ODBC connection to this same SQL db with Crystal Reports and multiple users have no problem running their Crystal Reports. However, Access is only allowing me to configure...

Thanks for the quick reply. I'll try other views.

Is this a Microsoft bug? Can it be fixed? For Access 2007, when I open the navigation panel (pane), and view objects by tables, queries, forms, and reports, the items in the list scroll and move up and down for as much as 30 seconds, before it stops. When I am trying to alphabetically find...

‘I wish to be able to select multiple products for the client each of which will have a varying table of fixed fields, but I wish it to be only relevant to that client. But I am unsure how to create this in the Main Table or in separate ones, and as for relationships... how do you link these...

have you compiled the DB with Access 2007?

Have you tried going to Tools -> share workbook and clicking the allow more than one users check box? This should sovle your problem - you may also want to look at the advanced options that relate to data integrity also....

On more than one occasion, to have a fast solution, I have done the following. I get a copy of a good working DB from the past. I then export all needed tables from the corrupted DB over to the good working DB... and then you have a fully repaired DB with all current data. Then you can try...

Which release of Access are you using? 2003 or 2007? Have you done a compact and repair? What do you mean by “no debugging happened” or “debugger isn’t working”? You only need to do a ‘Debug, Compile’ if you have changed code. It doesn’t need to be run if you only change queries or things not...

Are you trying this criteria??? Like [Enter last name] & “*”

I design my own security screens and control access to updates/adds/etc. I'd suggest getting a good Access/VB programmer who can do the same for you.

Sorry, trusted connections is something you do with Access 2007, and I see you said you're doing Access 2003. When you hang, are you using administrative tools to see exactly who is still connected to the DB? I don't think this is an Access problem, I think it is a network problem, and you...

Have you set up trusted locations in the trust center for all client PCs?

"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the...

These two are simple. 1) Use a concatination string and the "like" operand.... criteria would be Like [Enter last name] & “*” 2) Criteria would be Between [Enter start date] and [Enter end date]

This is tricky. Doing updates through a query having joined tables can be difficult unless you’re experienced with doing it. You have to understand inner and outer joins. I would probably control all of this using VB code in the background. You don’t say if you’re going to do this manually all...