Starting a Switchboard 1

[anasazii]

Hello all!

I'm designing a switchboard for my database, and I wanted to know if what I want to do is possible. I've only been working with Access for the past 3 months, so please bear with me if this is a dumb question.

I have 3 separate databases that hold information for my company, and relationship wise, they have to be kept separate. What I would like to do is build a switchboard linking all 3 of the dbs. Is this at all possible, and if so, please point me to where I could find more information on this, or let me know what I need to do.

Thank you for your help!
Janel

 

[tlbroadbent]

Perhaps, the easiest and simplest path to what you want is to create a new database and link the tables of the other three databases in this database. You could then create the switchboard, forms, queries, reports, etc. that you require in the new database leaving the other databases intact. If needed you could even import queries, forms, reports, etc. from the other databases. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[anasazii]

Terry,
Thanks a bunch! It took me a few tries, but I think I've got it working now.
Janel

 

[anasazii]

Hello again.

I've managed to get my Switchboard up and running, but I did stumble across another problem, which I don't know if there will be a solution to or not. I had to use the DB on another cpu, and the Switchboard was unable to open any of my forms. I'm pretty sure that this is because it's looking for the exact path of the forms/db/etc.

For example, when I click on an option from the SB to take me to a form, I get an 'Action Failed' message, pointing to my macro that opens the particular form.
When I try opening the form directly from the form window, I get the following error: "Run-Time Error '3044' 'C:/My Documents/database/DP.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you're connected to the server on which the file resides."

Currently, I have been doing everything on my cpu and the other users have been accessing the dbs via 'Network Neighborhood' or just mapping my drive. The problems arose after I linked the tables. I'm not too familiar w/the "networking" of our system, but I do know that we are using MSWin 98, and not using NT or a server of any kind.

So, I guess my question would be is there any way around this, or am I wasting my time since we aren't hooked up to a server? I suppose a switchboard isn't that important, but it is kind of nice in the sense that the users only have to go to one location, can then access everything from there, and also don't have to worry about the underlying components. Also, I would really like to have some type of user interface, so if a switchboard isn't possible, are there any other possibilities in this type of situation?


Thanks for your help,
Janel

 

[THoey]

The invalid path message is probably due to using the wrong slash (should be "\" instead of "/&quot. Try the following:

'C:\My Documents\database\DP.mdb'

Hope that helps... Terry M. Hoey

Please read the following FAQ to learn how to help me help you...