PC Review


Reply
Thread Tools Rate Thread

Access 2007 Runtime Cannot Open Database After A Table Is Created In It

 
 
Stewart Berman
Guest
Posts: n/a
 
      26th Feb 2010
We have an application split into a front end (code, queries, forms, macros)
and a back end (primarily tables).

The application is distributed in compiled form and is installed with the
Access 2007 Runtime package.

Part of the process occasional opens the back end directly in Runtime.

We normally distribute updates to the application by sending out a new front
end. Occasionally, an update will require a new table in the back end which
the front end will create.

The problem we have run into is that following sequence crashes the back
end:
1. An update is run that adds one or more tables to the back end.
2. The back end is opened and closed.
3. Another update is run that adds one or more tables to the back
end.
4. The back end is opened and crashes.

What is strange is that if the database is opened using a full version of
Access 2007 after before step (4) the back end can be opened in Runtime.

We have tried three methods for creating tables in the back end:
1. Create a database object connected to the back end and run create
table SQL.
2. Create a database object connected to the back end and create the
table in code. (i.e. db.createtable, etc.)
3. Use a DoCmd.TransferDatabase to transfer a copy of a table in the
front end to the back end.

All three results in the same crash after the second update is run.

This is 100% reproducible starting with a brand new back end database with
nothing in it.

Is this a known bug? Is there anyway around this?

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007 runtime database not open in Windows Server 2003 Casey Wong Microsoft Access 1 16th Oct 2009 10:02 PM
use adp file created in Access 2000 in runtime 2007 Bob Microsoft Access Getting Started 0 23rd Jan 2008 01:36 AM
BCM 2007: Cannot open local BCM database, but it is created fine . =?Utf-8?B?UGF1bCBAIEJsdWUgSXZ5?= Microsoft Outlook BCM 5 3rd Aug 2007 08:12 PM
I cannot open an access database in XP which was created in NT =?Utf-8?B?UGhpbA==?= Microsoft Access 1 16th Feb 2006 03:23 PM
how many table can i created in a database(ms access)? =?Utf-8?B?YW1yaXNo?= Microsoft Access Getting Started 2 18th Feb 2005 12:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:56 PM.