Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-13-2012, 01:03 PM   #1
bluetongue
Newly Registered User
 
Join Date: Jul 2004
Location: Canberra, Australia
Posts: 34
Thanks: 1
Thanked 2 Times in 1 Post
bluetongue is on a distinguished road
Can you convert a split database from mdb to accdb?

I have a database in Access 2003 format with the backend on a network drive and the frontend on individual PCs.

I converted the backend to 2007 format. then converted the frontend and relinked all the tables. The code behind the forms no longer works giving a 'File not Found' error when controls on the form are clicked. The form code is visible in the VBA editor but seems no longer linked to the controls.

There were network drive problems before and after the conversion giving a "Could not send the command to the program" error message. I repeated the conversion on my own PC using backup copies on my own PC and relinked before the conversion, but with the same result. This leads me to believe the problem is with the conversion and not with the network drive.

Fortunately, I have backups and can restore to a working set of databases about 5 days old.

The message which appears after conversion seems to indicate that you cannot link tables between access 2003 and 2007 versions.

I also on occasions received a "Cannot convert attached files" message - could this be due to memo field in one of the tables?

I would be grateful for any assistance.

bluetongue is offline   Reply With Quote
Old 06-13-2012, 01:31 PM   #2
mdlueck
Sr. Application Developer
 
Join Date: Jun 2011
Posts: 2,600
Thanks: 112
Thanked 294 Times in 282 Posts
mdlueck will become famous soon enough mdlueck will become famous soon enough
Re: Can you convert a split database from mdb to accdb?

Have you tried running the Linked Table Manager? Since you say the BE changed from a .mdb to an .accdb file, I would look there first.
__________________
--
Michael Lueck
Lueck Data Systems

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
mdlueck is offline   Reply With Quote
Old 06-13-2012, 03:58 PM   #3
bluetongue
Newly Registered User
 
Join Date: Jul 2004
Location: Canberra, Australia
Posts: 34
Thanks: 1
Thanked 2 Times in 1 Post
bluetongue is on a distinguished road
Re: Can you convert a split database from mdb to accdb?

I used the Linked table manager to relink the files.

The problem occurs during the conversion of the form - VBA displays a number of "File not Found" messages in rapid succession.

bluetongue is offline   Reply With Quote
Old 06-13-2012, 06:59 PM   #4
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,336
Thanks: 13
Thanked 1,403 Times in 1,337 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
Re: Can you convert a split database from mdb to accdb?

All the databases I have converted have had SQL Server BE's so I haven't run into this. Start by converting the FE first because a 2007 FE can link to a 2003 BE but not vice versa. Once that works, you can convert the BE. Then use the linked tables manager to relink the tables. If that fails, delete the links and relink from scratch.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Old 06-16-2012, 01:08 PM   #5
bluetongue
Newly Registered User
 
Join Date: Jul 2004
Location: Canberra, Australia
Posts: 34
Thanks: 1
Thanked 2 Times in 1 Post
bluetongue is on a distinguished road
Re: Can you convert a split database from mdb to accdb?

When attempting to convert the database on my work PC I received several "File not found" messages from VBA.

When attempting the conversion on my home PC there were no "File not found " messages instead I received a message stating

"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 backup your database before attempting to open the database and delete the VBA project.

"To create a backup copy, click Cancel and then make a backup copy of youe database. To open the database and delete the VBA project without creating a backup copy, click OK."

There seems to be no way around this without doing this and recoding the forms, reports and modules
bluetongue is offline   Reply With Quote
Old 06-17-2012, 11:55 AM   #6
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,336
Thanks: 13
Thanked 1,403 Times in 1,337 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
Re: Can you convert a split database from mdb to accdb?

Go back to the original files and start again but this time do the FE first.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
working fine in.mdb but not in .accdb database WalterInOz Modules & VBA 6 03-22-2011 06:35 AM
Can we convert .accdb to .mdb with only tables exported to .mdb PKJ Modules & VBA 9 03-14-2010 11:37 AM
Question Access 2007 accdb creates Database.mdb Maritza General 0 08-17-2009 04:53 AM
Creating 2 user accounts in accdb database Eeebs General 1 04-23-2009 06:39 AM
Convert ACCDB to MDB raskew General 8 06-07-2008 05:48 PM




All times are GMT -8. The time now is 09:13 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World