I am creating a series of access databases that connect to each other via buttons on a form -- ie... click a button and another db opens with it's main form. I created this system in MSAccess 2003 in 2000 format. On my development machine which is running office 2003, everything works perfectly, but as soon as I move the system to another machine running office 2000 (which is what most of my end users have) the program does not work. I am using a 'createobject(access.application) followed by an opencurrentDatabase and openForm for the link between the programs. I am hopelessly confused as to why it works on one machine and not the other if the database format is 2000.I seem to have all the correct references set as far as I can tell. What does happen is I get 'ghost' Msaccess sessions created, but the secondary database/form will not display. I have to go into task manager and actually delete the sessions to clear out memory. any help you can offer will be greatly appreciated. I hope I explained this somewhat clearly - it is confusing to me........
Bev A.
access vba issues
Hot Topic
- Just gotta have a moan
- Introducing our newest forum!
- Detecting which version of MS Office is installed (for templates)?
- VBA and Excel Deleting Worksheets without user interaction
- Superscripting in PowerPoint
- Reading a .LBD file
- I need to install ACTIVEX so I can be able to Download.
- Security of source code in vba
- Removing Hyperlinks
- printing .doc, .xls, and .pdf files from a list of filenames using an excel vba macro
Microsoft ISV
- Problem about the "Find" function in VBA editor
- Integer values cannot be gathered when reading Excel file
- SQL Server 2005 Resourse Kit exception
- WORKING ON WORKBOOK WITHOUT OPENING IT
- Excel macro to send email not running
- Fixed!!!
- Charts.Add method causing error
- pass parameter to stored procedure
- Moving to Office 2003
- Word Automation; documents and templates
access vba issues
Wu Leilei
Hi Bev,
This happened to myself also. I had an Access 2000 database, which was split into front end forms and back end data. I updated the front end forms in Access 2003 and was surprised when it stopped working on all machines that had 2000 running on them.
I think the database format of 2000 only relates to the data rather than forms. When the data in Access 2003 says it's in 2000 format it's the data that is stored in a format compatible with Access 2000, but the forms are not.
I couldn't find a fix but lucky I had a backup of the Access 2000 front end. So now my system runs with two front ends, one for 2003 and one for 2000, that access one back end data store (2000).
Unfortunately it means I cannot modify the 2000 version because as soon as I do, with 2003, the system won't work.