Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2005-02-08 : 06:13:32
|
i have a back-end and front-end MSAccess2003 DB. The back-end obviously just having the tables in it and linked into the front-end.i want to put the back-end part on a server and the front-end part on each client machine.if i convert the front-end part to an MDE file is there anyway of refreshing the links to the back-end part ?i am thinking that if i convert the front-end to an MDE before taking it to the client then i will need to refresh the links to the back-end part once it is on their network. or am i missing something  ====Paul |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-02-08 : 06:38:14
|
| I could be way off, it's been a while since I looked at this stuff, but I seem to remember one of the sample apps having a form that let you browse for the backend data files.Like I said, I may be totally wrong, but it's worth a look.Damian |
 |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-02-08 : 18:04:53
|
| Wont holding shift down whilst opening the mde open it in a normal access window?Andy |
|
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2005-02-09 : 05:54:02
|
i've been looking at this on and off for a day or two now and here are some useful posts...the first link may answer your query Andy.http://www.tek-tips.com/viewthread.cfm?qid=995124&page=1http://www.tek-tips.com/faqs.cfm?fid=90http://www.utteraccess.com/forums/access/access1305230.htmlhttp://www.xtremevbtalk.com/showthread.php?p=939587#post939587anyway my easiest option seems to be to actually create the MDE file on the client network who is luckily a friend of mine and will let me do it. That way i will have the back-end at its final location from the start and will not need to refresh the links at all after MDEing the front-end part. I've not tested this yet though.p.s. couldn't find the sample app Merkin mentioned though  ====Paul |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2005-02-09 : 06:34:54
|
| that's a great link - thanks Merkinto think i spent ages browsing the microsoft site yesterday to no great avail.====Paul |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-02-09 : 06:41:10
|
| No probs, I found it googling for "access linked tables dialog example". There were a few other links that came up that might help. That article mentions the Office 2000 Developer Tools CD, that could be where I saw the sample, I used to have that CD.Damian |
|
|
|
|
|
|
MDE files