If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Unsplit database
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 |
#3
|
|||
|
|||
Unsplit database
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 |
#4
|
|||
|
|||
Unsplit database
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 |
Thread Tools | |
Display Modes | |
|
|