Database Questions

[Guest]

I have an Access 97 database that is currently being used by multiple users, I have created and .mde file and a short cut to that file. I have a button on a form that I am tring to re-direct the user to another database (for data entry only) so that they do not have to remember to open up a couple of databases. The current event I created is as follows
Private Sub btnopnnewdbase_Click(
On Error GoTo Err_btnopnnewdbase_Clic

Dim stAppName As Strin
Dim stTestVal As Intege
Dim Qte: Qte = Chr(34

'Check system to see if Runtime or Full Version of Access installed - Runtime = -

stTestVal = SysCmd(acSysCmdRuntime

If stTestVal = -1 The
stAppName = Qte & "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" & Qte &
" /runtime " & Qte & "\\lexfile13\finance\PSSDDB\PSSDFD Prospecting Database.mde" & Qt
Els
stAppName = "msaccess.exe \\lexfile13\finance\PSSDDB\PSSDFD Prospecting Database.mde
End I

Call Shell(stAppName, 1
Exit_btnopnnewdbase_Click
Exit Su

Err_btnopnnewdbase_Click
MsgBox Err.Descriptio
Resume Exit_btnopnnewdbase_Clic

End Su

My first problem is that when I click on the button, I get an error that access command line used to start access contains and option that access does not recognize. When I click on OK (a couple of times) I get my second error: microsoft can not find a mdb file. The mdb file does not exist as I have created the mdb and put it in another folder

Any suggestions
Mickey

 

[Albert D. Kallal]

Can you double click on the file...and launch it?

Just use:

To run a word application you go:

application.FollowHyperlink "c:\my documents\test.doc"

To run a excel application you go:

application.FollowHyperlink "c:\my documents\test.xls"

To run a ms-access application you go:

application.FollowHyperlink "\\lexfile13\finance\PSSDDB\PSSDFD Prospecting
Database.mde"

I was not aware that you have to use the runtime switch to launch a mde file
with the runtime..

However, I do notice that you have a very bad setup (likely you are very new
to ms-access as what you have is very wrong).

You SHOULD NEVER EVER EVER allow more then one user into a database file.
That means you need to run a split setup, and your front end is a mde that
is PLACED ON EACH pc. That front end is then linked to the back end database
that resides on the server.

For information on splitting..check out:

http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm

and

http://www.granite.ab.ca/access/autofe.htm

 

[Guest]

Thanks for your help. I inherited this database from another user and this is only the tip of the iceberg. for what we do, I feel ok with the way it is set up

Thanks
Mickey