Merging split Db

[Ammarhm]

[FONT=&quot]Hello,
My apologies if this question was asked before
I have myself created an access database (with great help from this forum), then split the database into frontend and backbone tables. During the last months thousands of data have been input into the table
Now, because of changes to the structure of our server I decided to merge the database (makes life easier with the very complex new server system and a non understanding IT department who wouldn’t give any help or support)
The I have tried few tricks, from copy-paste which obviously dose not work to importing external data. What i think is happening is that the relations in those tables seems to be lost after moving the tables
I even considered rebuilding relations but the database is so complex that it would really take some time to do that
I even have an old unsplitt copy of the whole database, which contains about 12 different tables. All the important data that have been added during the years were stored in one table, so I tired copying just the contents of the table from the split database to the non split one, again it did not work, when I run a query it seems it cannot find any data though there are in fact there
I would really appreciate all help
Regards[/FONT]

 

[spikepl]

Re: Merging splitt Db

Grab the db containing tables and open it. Use the external data wizard to import from the frontend all forms, queries, modules, macros, and any tables that may be local to your frontend. You are done.

 

[boblarson]

1. Sorry for the change in server methods.

2. You should NOT be trying to bring this back into one database. (corruption issues especially but also potential collision issues with multiple users)

3. What is so tricky about the server setup that you can't relink the frontend with the backend?

 

[Ammarhm]

[FONT=&quot]

3. What is so tricky about the server setup that you can't relink the frontend with the backend?

Hi and thanks everyone for the great answers
So here is the dilemma: I work at a large "company" with an excess of 10000 PCs. Our "fantastic" IT has introduced this new PC environment (which actually only makes it easier for the IT department to manage all those PCs centrally, the thing is that we are about 15 persons who use this Db, everyone has his unique login, but all are connected to the server (along with other servers depending on your permissions), the interesting thing is that this server shows for example to me as a mapped hard disk named "E", while it could be "G" to another use, so as soon as I split the Db and give the forend a path to the backed, it seems to work for me but not for other users who see the database located at a mapped HD with a different name!!!!!
Have you ever seen anything like this? Any way to deal with this??
Best regards[/FONT]

 

[boblarson]

Yes, the way to deal with it is to use Universal Naming Convention as the linked table path instead of drive letters.

See here for how to do that:
http://www.btabdevelopment.com/ts/unc

 

[Ammarhm]

Yes, the way to deal with it is to use Universal Naming Convention as the linked table path instead of drive letters.

See here for how to do that:
http://www.btabdevelopment.com/ts/unc

Realy appreciate your answer, I will try that with our IT, hope they will give me the full UNC path (they are quite paranoid!)
Regards

 

[boblarson]

Here's a way you can bypass them. Open your backend from its location on the server. Go to Modules and click ADD. You aren't going to save this module but you need to open the VBA window.

Go to the IMMEDIATE WINDOW (post back if you don't know what that is) and then type in it:

?CurrentProject.Path

and hit enter.

You should see something with two backslashes which is the UNC path to the database. Copy that and use it for relinking.

Once you have that info, just close your backend and choose to NOT save the module.

 

[Ammarhm]

Thanks again Bob, you really made my day. I really dont know how I would have maanged to so this project without the help from this forum
Bob, I am going to post another very challenging question today, I hope I would get an answer from you
Regards

 

[Ammarhm]

Here's a way you can bypass them. Open your backend from its location on the server. Go to Modules and click ADD. You aren't going to save this module but you need to open the VBA window.

Go to the IMMEDIATE WINDOW (post back if you don't know what that is) and then type in it:

?CurrentProject.Path

and hit enter.

You should see something with two backslashes which is the UNC path to the database. Copy that and use it for relinking.

Once you have that info, just close your backend and choose to NOT save the module.

Hello again Bob
I have done what you suggested, strangely i did not get the UNC, rather a path that looked like this:
G:\myfoldername\mysubfoldername
Any suggestion?
Cheers

 

[boblarson]

Hello again Bob
I have done what you suggested, strangely i did not get the UNC, rather a path that looked like this:
G:\myfoldername\mysubfoldername
Any suggestion?
Cheers

You can use this code here:
http://access.mvps.org/access/api/api0003.htm

put that into a new, blank database shell inside a new module (standard module) and then run that from the Immediate Window (you don't have to save the new database file nor save the new module, it is just to get this information)

From the Immediate Window:

?fGetUNCPath("G:")

 

[Galaxiom]

Try the Map Network Drive facility in Windows to find the UNC path for a mapped drive. Right click on MyComputer or look under the Tools menu when viewing a folder.

The drives that are already mapped to a user are shown. Unfortunately it does not show those mapped to the machine.