form disable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which is accessed by the users in network.

I don't want the users to go to Form design and make changes

How can I achieve it ?

Thanks
 
Create an MDE for the front end. The users will not be able to modify the
forms, reports, or change the code.

Presumably you have already split your database so there is one shared back
end, and a separate front end for each user.
 
Thanks, Allen for your reply

1.] dbase is split, file name xyz_be. but which version should I share
xyz_be or xyz.mdb. At the moment sharing the xyz.mdb. though if I need to
make any changes in query or form design it doesnot allow since users are
using my dbase

2.] while creating MDE getting error 'Microsoft Access was unable to create
MDE'

plz help...
 
Share the datafile on a location where everyone can connect.

Give each user a separate copy of the MDE.

There are several reasons why you might not be able to create an MDE, such
as:
- You are not using the default file format. For example, you are using
Access 2002 or 2003 with the Access 2000 file format.

- Your code does not compile (when you open a code window, and choose
Compile from the Debug menu.)

- The file is corrupt, or has broken references.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Gerald said:
Thanks, Allen for your reply

1.] dbase is split, file name xyz_be. but which version should I share
xyz_be or xyz.mdb. At the moment sharing the xyz.mdb. though if I need to
make any changes in query or form design it doesnot allow since users are
using my dbase

2.] while creating MDE getting error 'Microsoft Access was unable to
create
MDE'

plz help...


Allen Browne said:
Create an MDE for the front end. The users will not be able to modify the
forms, reports, or change the code.

Presumably you have already split your database so there is one shared
back
end, and a separate front end for each user.
Click to expand...
Click to expand...
 
how to give each user separate copy of MDE
also not clear on the database split. do I need to split the database if I
create another table in mdb

Thanks

Allen Browne said:
Share the datafile on a location where everyone can connect.

Give each user a separate copy of the MDE.

There are several reasons why you might not be able to create an MDE, such
as:
- You are not using the default file format. For example, you are using
Access 2002 or 2003 with the Access 2000 file format.

- Your code does not compile (when you open a code window, and choose
Compile from the Debug menu.)

- The file is corrupt, or has broken references.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Gerald said:
Thanks, Allen for your reply

1.] dbase is split, file name xyz_be. but which version should I share
xyz_be or xyz.mdb. At the moment sharing the xyz.mdb. though if I need to
make any changes in query or form design it doesnot allow since users are
using my dbase

2.] while creating MDE getting error 'Microsoft Access was unable to
create
MDE'

plz help...


Allen Browne said:
Create an MDE for the front end. The users will not be able to modify the
forms, reports, or change the code.

Presumably you have already split your database so there is one shared
back
end, and a separate front end for each user.

I have a form which is accessed by the users in network.

I don't want the users to go to Form design and make changes
Click to expand...
Click to expand...
Click to expand...
 
Regarding the reasons for splitting, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html

There is a wizard to help you do that:
Tools | Database Utilities | Database Splitter.

The front end becomes the software to install on each workstation.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Gerald said:
how to give each user separate copy of MDE
also not clear on the database split. do I need to split the database if I
create another table in mdb

Thanks

Allen Browne said:
Share the datafile on a location where everyone can connect.

Give each user a separate copy of the MDE.

There are several reasons why you might not be able to create an MDE,
such
as:
- You are not using the default file format. For example, you are using
Access 2002 or 2003 with the Access 2000 file format.

- Your code does not compile (when you open a code window, and choose
Compile from the Debug menu.)

- The file is corrupt, or has broken references.

Gerald said:
Thanks, Allen for your reply

1.] dbase is split, file name xyz_be. but which version should I share
xyz_be or xyz.mdb. At the moment sharing the xyz.mdb. though if I need
to
make any changes in query or form design it doesnot allow since users
are
using my dbase

2.] while creating MDE getting error 'Microsoft Access was unable to
create
MDE'

plz help...


:

Create an MDE for the front end. The users will not be able to modify
the
forms, reports, or change the code.

Presumably you have already split your database so there is one shared
back
end, and a separate front end for each user.

I have a form which is accessed by the users in network.

I don't want the users to go to Form design and make changes
Click to expand...
Click to expand...
Click to expand...
 
Thanks for your patience, I shall work on your suggestion

I split my dbase on my system and now I will make MDE on the mdb file on
each users, lets c how it works

Many thanks

Allen Browne said:
Regarding the reasons for splitting, see:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html

There is a wizard to help you do that:
Tools | Database Utilities | Database Splitter.

The front end becomes the software to install on each workstation.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Gerald said:
how to give each user separate copy of MDE
also not clear on the database split. do I need to split the database if I
create another table in mdb

Thanks

Allen Browne said:
Share the datafile on a location where everyone can connect.

Give each user a separate copy of the MDE.

There are several reasons why you might not be able to create an MDE,
such
as:
- You are not using the default file format. For example, you are using
Access 2002 or 2003 with the Access 2000 file format.

- Your code does not compile (when you open a code window, and choose
Compile from the Debug menu.)

- The file is corrupt, or has broken references.

Thanks, Allen for your reply

1.] dbase is split, file name xyz_be. but which version should I share
xyz_be or xyz.mdb. At the moment sharing the xyz.mdb. though if I need
to
make any changes in query or form design it doesnot allow since users
are
using my dbase

2.] while creating MDE getting error 'Microsoft Access was unable to
create
MDE'

plz help...


:

Create an MDE for the front end. The users will not be able to modify
the
forms, reports, or change the code.

Presumably you have already split your database so there is one shared
back
end, and a separate front end for each user.

I have a form which is accessed by the users in network.

I don't want the users to go to Form design and make changes
Click to expand...
Click to expand...
Click to expand...
 
Back
Top