Moving backend database
But if I rename the _be in the original location (which really should be deleted -- but glad I didn't yet), my front-end will not even come up (it shows the template page for newdatabases).
If I rename the _be database in the original location (which should not be involved anymore) to its correct name, the front end comes up, and tables show they are still correctly pointing to the new location.
I need to know how the original _be database from which I copied for the move, could have any relationship to my _fe pointing to the new location.
This is all I need to be complete my split, since I will be moving the split database off my pc into a server environment, now that I have installed Bob Larson's tool to enable auto-updates (a great piece of work).
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have tried to link the frontend of the database onto the backend/SQL which I have followed the guide on MS (I hope is right ),
1st have I done it right by only moving the backend into SQL, 2nd when I have linked the frontend to the backend in SQL, I try to open one of the forms and it does not work, when I try and open the table in the frontend I get a message with says"ODBC - Call Failed" and when it opens it only has 63 recordes and not the 4500 which it should have and every field has #Name?
I was thinking about just copying the backend data to the users mydocuments folder and have the program access the data there but when changes were made then update the backend database.
Then update the local copy with the new id from the backend to the local version so the ID's and whatnot are controlled by the backend.
When the user opens the program after closing then it would just pull the backend data to the local machine again overwriting it.
I am grasping at straws here
Before the database is closed, I would like the user to be able to compact the backend of the database. Is itpossible to compact the backend of a database from the frontend? Or is this something that just needs to be done manually?
Must it be on a shared network location in a Windows environment? Can it be placed on some FTP server?
I have a backend-database on a network disk shared by 6 users. All users have a frontend client wich they use to administer the datebase. Everything in the frontend looks ok and they can query the latest data. However if I open up the backend database tables nothing has been updated since the middle of december. If I make a copy of the backend I can open it up and create new posts with ID-numbers that has already been taken by the frontend.
Ofcourse I have doublechecked that the clients are connected to the right backend file (there's only on backend file in the directory). Its all very strange and confusing, anyone with a good idea whats going on
No error messages are displayed. I did update the links but it did not make a difference.
Both the frontend and backend are located on the server but I also tried moving the frontend to the local computer and it did not make a difference
I today created a copy of both front and back end.
When I made changes in the copy of backend table definition,
They also reflected in the database in use.
Could someone please help with creating a duplicate backend where
I should be able to make changes without effecting the actual database in use and also test the changes using the front end.
My problem is that I need to create a form (Combo filters) with sub-form (List of the columns). I don't know how to show the data in this form / sub-form from backend database,
I have a split database, with the backend saved on a network.
1) How can I retrieve the name and location of the backend in VBA?
2) Is it possible to change the linked location for each table via VBA, say for example if I wanted to switch the tables to point to a backup version of the backend, or if a user had different drive mapping on a there machine which meant that the table location had to be remapped