Potential Bug in Access 2007

I have noticed behavior in Access 2007 that could potentially delete/remove
relationships in your database when you try to split the database into a
front end and a back end using the “Database Tools�->�Access Database�
option. If you have a table locked (such as having the table open or a form
(such as the switchboard) accessing a table) when you try and split the
database you will get the following error “The database engine could not lock
table ‘table_name’ because it is already in use by another person or
process.� After clicking okay you will notice the split did not succeed
because you still have all of your local tables and no linked tables. You
will also notice all of your relationships defined in the database have been
deleted. Now the back end is created correctly. The tables exist and the
relationships are still defined. Now if you don’t realize your relationships
have been deleted you might delete the back end (since it does not contain
any of your custom objects, form, reports and so on) and try to redo the
split after releasing the lock on your table. The problem is the split works
but the back end is created without any relationships.

I just thought I would share this in hopes that somebody could avoid losing
their relationships. Always backup you database before doing a split.

Following your steps, I ended up with a different result.

As you stated, the back end tables were created, but the attempt to create
the relations in the back end failed because a form was open in the front
end. Therefore the back end tables lacked the relationships.

However, the front-end relations were still intact. So deleting the
(incomplete) back end would not cause any grief.

Tested in A2007 SP1.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"oracle8202" <oracle8202.DeleteThis@discussions.microsoft.com> wrote in message
news:4E928715-89AA-4497-9036-DF4AFCF1DE39@microsoft.com...
>I have noticed behavior in Access 2007 that could potentially delete/remove
> relationships in your database when you try to split the database into a
> front end and a back end using the “Database Tools�->�Access Database�
> option. If you have a table locked (such as having the table open or a
> form
> (such as the switchboard) accessing a table) when you try and split the
> database you will get the following error “The database engine could not
> lock
> table ‘table_name’ because it is already in use by another person or
> process.� After clicking okay you will notice the split did not succeed
> because you still have all of your local tables and no linked tables. You
> will also notice all of your relationships defined in the database have
> been
> deleted. Now the back end is created correctly. The tables exist and the
> relationships are still defined. Now if you don’t realize your
> relationships
> have been deleted you might delete the back end (since it does not contain
> any of your custom objects, form, reports and so on) and try to redo the
> split after releasing the lock on your table. The problem is the split
> works
> but the back end is created without any relationships.
>
> I just thought I would share this in hopes that somebody could avoid
> losing
> their relationships. Always backup you database before doing a split.