Splash Page

[sicklr]

I have created a splash form that loads immediately when one opens the database. I have a few tables, and the associated forms and pages. I want my fellow employees to be able to load up the splash page and hit the button for their dept, to go add data. The macro and module work fine, but I have a weird problem.

Once the user hits the button they want, the page loads up in a seperate window, like I want it to. However, the splash page stays active, unless you exit it. I don't want the users of this database to have to exit the splash page before they enter data, in case they want to access more than one table.

Is there anyway to disable this "always on top" mentallity of my splash page?


Thanks in advance,
`Ryan

 

[boblarson]

It's not really a "splash" form really, because a splash is the form that loads and shows your program info and then goes away. What you are using is a switchboard (albeit a custom one and not using the switchboard manager, most likely). What you need to do is to make sure the form's POPUP and MODAL properties are set to NO.

 

[sicklr]

Fair enough

Switchboard sounds much better.

And yeah, that did the trick.

Now that I've got your attention, its time for the tricky question

I am saving this database on a private websever that a co-worker runs. He gave me shared admin powers to access these files. Whenever I try to open them, I need to log-in with a login and PW. There is also a company wide public drive. Would I be able to just copy and paste the database over to the P: drive, and have it be full access to others? Is there any other way to publish this to our company intranet?

`Ryan

 

[boblarson]

An mdb file can be moved (if you are using workgroup security, that can be a little tricky - I've heard as I don't use it much as I haven't needed to) readily and others can use it.

However, if you are going to put it on a server, for multiple people to use, you should split it into a frontend/backend (there is a utility for this at Tools > Database Utilities > Database Splitter) and have each user have a frontend on their machine (look into the Samples area of this forum for a tool I created to enable frontends to be automatically updated for users when you make design changes to the master).

But, it sounds like you are wanting to put it on an Intranet website. Is that correct? If so I think you need to use Data Access Pages instead of normal forms.

 

[sicklr]

Very cool.

I split it up, and now I have two databases. I can send out the orignal via email / CD now, correct? Since I'm using a sever, all the form and table links are UNC. Will those links transfer OK?

`Ryan

 

[rainman89]

Leave the backend on the server and send the front end out to people! as long as the file paths are similar the links should stay the same

 

[CEH]

To add to Rays post....... You might consider changing the front end to a .mde file...... little security... And when you link the two.... BEFORE you send them out... link to your backend db thru "My Network places" NOT by picking the drive letter on your server.

 

[boblarson]

To add to Rays post....... You might consider changing the front end to a .mde file...... little security... And when you link the two.... BEFORE you send them out... link to your backend db thru "My Network places" NOT by picking the drive letter on your server.

or you can do it by either typing or pasting the network location like this:

 

[sicklr]

That sounds exactly like what I want to do. Thanks for everyone's help. One more question. When I attempt to use the linked table manager accroding to Bob's directions, I get a warning msg saying "The microsoft jet database engine cannot find the input table or query 'AAA'. Make sure it exsists and it's name is spelled correctly". I have already spilt the table into a FE and BE. Anyone know how to solve this?


Thanks,
`Ryan

 

[CEH]

Bobs suggestion is fine... but one typo and your sunk.......
After you click "always prompt for new location" and then "Select all" click OK..... and follow the path..... beginning with "My Network Places" once you find your backend I think you'll be fine.