Access 2010 - when I move a linked back-end (BE) (and re-link) the FE wont open? (unless the old BE remains in original location).
6  2586 
Is this a database you have created yourself, or that someone else have created?
If it is created by someone else, it is possible to create dataconnections entirely in code, without linking tables. I sometimes use that approach myself, If I dont want the linked tables to be visible in the database explorer window.
the database was a combined FE/BE. I split it, then copied the BE somewhere else, then re-linked the FE to the new location. Everything works great until I delete the old BE, then the FE wont open. There seems to be some residual linkage. I have tried importing, linking etc and nothing works.
That much was clear from your original post. However you didn't answer the question I asked you.
The reason I ask is because if you have properly re-linked your tables it should work. A cause for it not to work is what I have mentioned above, custom code.
So please answer the question, and we can proceed from there.
there is no code for this. there are no hidden tables, and I try open it using shift-key (negating any code anyway). When I try opening it, Access attempts to open then 'switches' to start new database mode (as if I opened Access directly).
If I put the original BE back where it was, all works well (and data is saved to the new linked location.
When you relinked, did you check all objects and check the option that says always prompt for new location?
NeoPa 32,556
Expert Mod 16PB
Clive, you say you relinked the BE. How exactly did you do that, and did you test that it had worked reliably after you made the change(s)?
Sign in to post your reply or Sign up for a free account.
Similar topics
by: John |
last post by:
Could anyone please help me on this??
I have a php script page, which is basically quiz. Visitors (after login in
with their email address) are supposed to answer each question, and when
they...
|
by: chand |
last post by:
Hi.,
In my api.py file 'g_opt_list' is defined globally
g_opt_list =,,,,,,]
I am using this global list in the fucntion
def function ():
gloabl g_opt_list
|
by: Lyn Duong |
last post by:
Hi,
I have tried creating a linked server in microsoft sql 2000 to a db2
for vm database. I use a db2 v8 admin client, configure it via client
configuration setup and then in Microsoft SQL...
|
by: Mike Ridley |
last post by:
I am trying to create a new query using 3 linked tables. As soon as I
add the third table to the design grid Access crashes.
I have looked in the newsgroup and find that there have been problems...
|
by: Greg |
last post by:
I'm using a DataGridView object bound to an xml datasource. I have
added 2 unbound columns which are populated based on the calculations
of data from other columns. When the data in the other...
|
by: sara |
last post by:
I have an A2K database that has links to 3 of my other databases
(external links) to run some reports. The coding in any of the 4 is
pretty simple.
Recently when we make a new .mde for the...
|
by: Bjorn |
last post by:
Hi.
Every time i post data in a form the contents are being checked for
validity.
When i click the back-button, all data is gone and i have to retype it.
It's obvious that only a few or none of...
|
by: Flarky |
last post by:
Hi all,
I have a page that has links to other pages.
I want to be able to detect when the user has clicked
on Back (or typed Backspace) to move back to my page.
Is this possible?
Thanks.
|
by: gzeng |
last post by:
Is there any simple way to move the next pointer back to the beginning of a single linked list after it travers thru the list?
|
by: phpmel |
last post by:
Hi Guys,
I have a form that has input fields.
when the user presses submit a next page opens up to display whatever msgs need to be displayed. If the msg is an error and the go back by pressing...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| | |
