We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Access 2000

Medium Priority
374 Views
Last Modified: 2012-05-11
I have an access 2000 file format front end database which is run in Access 2007, tables are held in a back end SQL Server database and are linked to the front end. The front end is kept in a folder on a shared network drive where everyone accesses it.  I would like to upgrade the DB to Access 2007/2010, however when I have tried to do this, the following problem presents itself.

A lot of my queries/reports are opened via a popup form which allows users to select an option which then filters the resulting query/report by the chosen option. After the upgrade, the popup still works on my PC but will not popup on another PC when trying to open the same report.  The database locks up and I have to force a quit.  

Can anyone assist please?
Comment
Watch Question

Graham MandenoConsultant
CERTIFIED EXPERT

Commented:
Hi Andy

Start by looking for differences on the two systems: Same version of Access? Same operating system? Same permissions on the SQL Server database? ... etc.

Also: Does the code compile OK? Does your front-end use DAO or ADO (or both)?  What references does your VBA project have, and in what order?  Does it include any "foreign" DLLs or ActiveX controls?

-- Graham [Access MVP since 1996]

Author

Commented:
Hi Graham
Thanks for the quick response. I will check these tomorrow, being in UK it is 2320 and too late to start looking now. Several things I do know for sure - same version of Access & operating system, I do have greater level of permissions compared to anyone else.  I could also paste an example if my code tomorrow if that would help?

Rgds
Andy
Graham MandenoConsultant
CERTIFIED EXPERT

Commented:
Hi Andy

Don't bother posting any code (yet!)  Just check that the code compiles (Debug > Compile project) and check the references (Tools > References) for any "MISSING" references or other anomalies.

One thing that happens when you upgrade to ACCDB format is that the DAO 3.x reference is replaced by the "MS Office xx.0 Access database engine object library" (ADE) and it gets placed at the bottom of the list.  Moving it up to its normal 3rd place often helps, especially if you also have a reference to ADO.

I'm in New Zealand, so I can see we might have a few time-zone lags :-)

Cheers,
Graham

Author

Commented:
Hi Graham

Would you mind explaining DAO & ADO a bit more and where I would check for this?

I have moved "MS Office xx.0 Access database engine object library" item to position 3 in the list and I think, not wholly confident, that this has sorted my issue.

Does it include any "foreign" DLLs or ActiveX controls?  Could you also please clarify where I would check this?

Thanks again
Andy
Consultant
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I have been trying to sort this problem for months, then along comes Graham with a spot-on answer and a full explanation of what happens during an upgrade from 2000 to 2007.  I am a very happy chap.  Thanks Graham, much appreciated
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.