ACCDE backend?

[Guest]

I have a split database with the backend running on the server and the
front-end on the workstations. My question is should the backend be a ACCDE
file like the front end? I did a test and it seemed to work but I do not want
to deploy without confirmation that this is the correct thing to do.

 

[Douglas J. Steele]

There's no reason to use an ACCDE as the backend. The purpose of an ACCDE is
to prevent the ability to change code, and there shouldn't be any code in
the backend.

 

[Guest]

thanks

There's no reason to use an ACCDE as the backend. The purpose of an ACCDE is
to prevent the ability to change code, and there shouldn't be any code in
the backend.

 

[Tony Toews [MVP]]

There's no reason to use an ACCDE as the backend. The purpose of an ACCDE is
to prevent the ability to change code, and there shouldn't be any code in
the backend.

Well, other than a form with a red stop sign telling users to not do anything in the
database. And some code to close the MDB.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[David W. Fenton]

Well, other than a form with a red stop sign telling users to not
do anything in the database. And some code to close the MDB.

Can be done with a MsgBox launched from an Autoexec macro -- no code
needed.

 

[Tony Toews [MVP]]

Can be done with a MsgBox launched from an Autoexec macro -- no code
needed.

Good point. And then a quit immediately there after.

Nah, give them a Do you wish to exit now? message with a yes and no. Then exit
anyhow. <smile>

But a form looks slightly nicer.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Larry Linson]

Nah, give them a Do you wish to exit now?
message with a yes and no. Then exit
anyhow. <smile>

Tony, you misspelled <evil grin>!

 

[Tony Toews [MVP]]

Tony, you misspelled <evil grin>!

Thanks for the correction. <smile>

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/