Unsplit database

Hello,

I've split a database, but now need to unsplit it so that I can add a
password to the back end database (and have the application work without
issue).

I can import the tables from the backend db into the frontend db (the
imported tables have "_1" appended to the end as the tables already exist as
a linked table - e.g. customer imported as customer_1), however, all of my
forms, queries are using the linked table. How do I get my forms, queries,
etc to point to the imported table? I can't change the linked table to point
to the local table using Linked Table Manager (when I click on a linked
table, and choose "Always prompt for new location" - it says it can't find
the input table or query - I'm selecting the same file as the linked table
exists in, which is probably not the right thing to do, but am stuck).

Help!

Pete

Before anything, back it up.

You can go ahead and delete all linked tables, then import in all tables
from backend. That will "unsplit" the database without that _1 suffix.

If anything goes wrong, you can try again with a copy of back-up.


Petemeister2k wrote:
Hello,

I've split a database, but now need to unsplit it so that I can add a
password to the back end database (and have the application work without
issue).

I can import the tables from the backend db into the frontend db (the
imported tables have "_1" appended to the end as the tables already exist as
a linked table - e.g. customer imported as customer_1), however, all of my
forms, queries are using the linked table. How do I get my forms, queries,
etc to point to the imported table? I can't change the linked table to point
to the local table using Linked Table Manager (when I click on a linked
table, and choose "Always prompt for new location" - it says it can't find
the input table or query - I'm selecting the same file as the linked table
exists in, which is probably not the right thing to do, but am stuck).

Help!

Pete

Don't do it. It isn't necessary. Here is what you should do.

Delete all the links to the tables in the back end in your front end database.
Open the back end database and create a password for it, then close the back
end.
Open the front end and using the Linked Table Manager, recreate the links to
your back end tables. When you do, it will prompt for the password. Once
the table is linked, the password will be added to the table's connect string
and you will not have to enter the password again, but it will prevent a user
from opening the back end directly unless they have one of the multitude of
Access password crackers that can be downloaded from the internet. Some are
free.


--
Dave Hargis, Microsoft Access MVP


"Petemeister2k" wrote:

Hello,

I've split a database, but now need to unsplit it so that I can add a
password to the back end database (and have the application work without
issue).

I can import the tables from the backend db into the frontend db (the
imported tables have "_1" appended to the end as the tables already exist as
a linked table - e.g. customer imported as customer_1), however, all of my
forms, queries are using the linked table. How do I get my forms, queries,
etc to point to the imported table? I can't change the linked table to point
to the local table using Linked Table Manager (when I click on a linked
table, and choose "Always prompt for new location" - it says it can't find
the input table or query - I'm selecting the same file as the linked table
exists in, which is probably not the right thing to do, but am stuck).

Help!

Pete

Dave,

Thank you - worked like a charm!

Pete

"Klatuu" wrote:

Don't do it. It isn't necessary. Here is what you should do.

Delete all the links to the tables in the back end in your front end database.
Open the back end database and create a password for it, then close the back
end.
Open the front end and using the Linked Table Manager, recreate the links to
your back end tables. When you do, it will prompt for the password. Once
the table is linked, the password will be added to the table's connect string
and you will not have to enter the password again, but it will prevent a user
from opening the back end directly unless they have one of the multitude of
Access password crackers that can be downloaded from the internet. Some are
free.


--
Dave Hargis, Microsoft Access MVP


"Petemeister2k" wrote:

Hello,

I've split a database, but now need to unsplit it so that I can add a
password to the back end database (and have the application work without
issue).

I can import the tables from the backend db into the frontend db (the
imported tables have "_1" appended to the end as the tables already exist as
a linked table - e.g. customer imported as customer_1), however, all of my
forms, queries are using the linked table. How do I get my forms, queries,
etc to point to the imported table? I can't change the linked table to point
to the local table using Linked Table Manager (when I click on a linked
table, and choose "Always prompt for new location" - it says it can't find
the input table or query - I'm selecting the same file as the linked table
exists in, which is probably not the right thing to do, but am stuck).

Help!

Pete