Prev: product key for 2007
Next: Where I get an http:// address for Search Point in Access 2007?
From: kblakedunham on 23 Jun 2008 16:41
I'm fairly new to Access in general, and am using 2007. I created a simple
database and I was experimenting with some features. I ended up converting
it to an .accde database. I need to make other changes to the database, and
I don't know how to undo the .accde conversion. I've changed the file
extension back to .accdb - and it still opens as if it was .accde. I don't
know what else to do. I'm trying to avoid starting from scratch. If anyone
can help, it would be greatly appreciated.
From: Klatuu on 23 Jun 2008 16:46
You should still have the accdb version. When you make an sccde, it doesn't
replace the accdb, it only uses it to create the accde.
Sorry, but the internal format has been changed and you can't get it back.
the accde is specifically designed to prevent users from making any
modifications.
--
Dave Hargis, Microsoft Access MVP


"kblakedunham" wrote:

> I'm fairly new to Access in general, and am using 2007. I created a simple
> database and I was experimenting with some features. I ended up converting
> it to an .accde database. I need to make other changes to the database, and
> I don't know how to undo the .accde conversion. I've changed the file
> extension back to .accdb - and it still opens as if it was .accde. I don't
> know what else to do. I'm trying to avoid starting from scratch. If anyone
> can help, it would be greatly appreciated.
From: Douglas J. Steele on 23 Jun 2008 19:04
There is no "undo" capability. When you created the accde, you needed to
keep the accdb for situations such as this.

Note that you also need to split your application into a front-end
(containing the queries, forms, reports, macros and modules), linked to a
back-end (containing the tables and relations) so that existing data isn't
impacted by changing the application. Note that there's no point in
converting the back-end to an accde.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"kblakedunham" <kblakedunham(a)discussions.microsoft.com> wrote in message
news:65892DF2-6107-4DFC-8176-D7B3AB40C586(a)microsoft.com...
> I'm fairly new to Access in general, and am using 2007. I created a
> simple
> database and I was experimenting with some features. I ended up
> converting
> it to an .accde database. I need to make other changes to the database,
> and
> I don't know how to undo the .accde conversion. I've changed the file
> extension back to .accdb - and it still opens as if it was .accde. I
> don't
> know what else to do. I'm trying to avoid starting from scratch. If
> anyone
> can help, it would be greatly appreciated.


From: markinboone on 1 Jul 2008 12:34
So what would be the basic steps to get data added to an ACCDE file merged
into the original ACCDB file? Or is there a way to keep them in synch?


From: John W. Vinson on 1 Jul 2008 13:27
On Tue, 1 Jul 2008 09:34:02 -0700, markinboone
<markinboone(a)discussions.microsoft.com> wrote:

>So what would be the basic steps to get data added to an ACCDE file merged
>into the original ACCDB file? Or is there a way to keep them in synch?
>

You should probably not be storing *data* in an ACCDE file *AT ALL*. You can,
but the most recommended solution - especially for multiuser systems - is to
store data in a "backend" accdb (or SQL/Server Express or any of dozens of
other data stores), and use a .accde file as a frontend, linked to the tables.

That said, there is nothing at all difficult about adding *data* to existing
tables in an accde file. You can use forms to edit or enter data; enter data
directly into table datasheets; import data... it is NOT necessary to convert
back to a accdb file. The only thing you can't do in a accde which you can do
in an accdb file is change the actual *DESIGN* of the forms, reports, or
tables. You can change the content without changing the design.
--

John W. Vinson [MVP]
 |  Next  |  Last
Pages: 1 2
Prev: product key for 2007
Next: Where I get an http:// address for Search Point in Access 2007?