Search results

Thanks Pat, I think :) The purpose of the database was to maintain contacts, whilst also allowing it to show the persons place within a companies (clients) structure. How do I get that information out, how do I can a form to show contacts (names) within the companies? The more I think about it...

Thanks for that, I've created the DB with the replationship (I think!) though without data in it, or a form/query, I can't get my head around how it all works, in terms of it doing what it needs to do? Thanks, Alan

Pat, thanks but you lost me there :)

Gotcha, Glaxiom's suggestion using drive mappings, fixing the path to a drive, and making sure the network drive always points to the correct folder seems the most obvious one. Failing that, his other suggestion is more complicated but will work just the same I'm sure!

Thanks Glaxiom, I think I get the concept, any chance you can outline what tables are required, and the links? Sorry, I know that's essentially asking you to do the job for me :)

Thanks Glaxiom, but you lost me :( A junction table? Is this a term or is it a different type of table? I really am lost... The contacts could live under any 1 company, but should all be displayed if listing contacts at the top level. Thanks for the starting point, but I think I'm too new to this :(

Dan, if it helps, since troubleshooting our issues, our server OS is win2003 r2 and we have no issues now!

Not sure I understand this, why do you need to re-link the tables? Are you users accessing it from different places, with different paths/drive letters? I run front end/back end databases all the time, the front end can sit wherever, as long as the back end stays consistent?

We had HUGE problems doing something like this, when we had the backend on a Novell file server. Are you running the backend on a Microsoft server? What is the O/S for the backend server? To be fair, our files were never that sort of size (back end less than 20MB, front end much bigger as it had...

Hi, Sorry to ask such a full on question with my 1st post, but our sales department want a database to maintain contacts in it. Simple I thought, easy enough. But now, they want it to have a "hierarchical" layout to it, so it can depict a companies structure. Basically, what was a simple company...