Deploying a database

[tazz25]

Hi, I'm new to Access 2007 and I don't know how to publish my database or deploy it or whatever you call it... What I mean is, I'm done designing my database, and I'm ready for users to start using it... but I don't want them to be able to change design things about it... I just want them to see the database running as if it was a program all by itself. They all have Access 2007 too... but I just don't want them to be able to edit the design of the database.

So how do I save it as just a database and not an Access 2007 project file?

 

[SOS]

If your users are on the same network as you, then you would

1. Split your database to a frontend/backend (tables in the backend).

2. You can then create an ACCDE file which will lock down code and macros and form and report design.

3. Then you can just get each user a copy of the frontend (I think you can rename it ACCDR so it will run as if they were using the runtime, but if you do you'll need to make your own ribbons and have really good error handling).

4. Then you can use a tool like on MVP Bob Larson's site to do autoupdating to the frontends so you never have to worry if they have the most current version.

You might want to read this about splitting the database.

 

[SOS]

I just want them to see the database running as if it was a program all by itself.

I suggest you don't even go there. That is way too much hassle to deal with.

 

[irish634]

Something I've discovered early on in my database development. No matter how many precautions you take, if there's a hole (errors, security, etc), your users will find it. Especially in multi-user environments. There are many good tutorials on this site that help alleviate that and as a previous poster mentioned, robust error handling is a must. You are going to go through a debug phase where it will seem like you will have an error or something wrong all the time. All a part of learning.

If it's a multi user database, splitting is also a must. Follow the steps SOS suggested and you'll be off to a good start.

Hi, I'm new to Access 2007 and I don't know how to publish my database or deploy it or whatever you call it... What I mean is, I'm done designing my database, and I'm ready for users to start using it... but I don't want them to be able to change design things about it... I just want them to see the database running as if it was a program all by itself. They all have Access 2007 too... but I just don't want them to be able to edit the design of the database.

So how do I save it as just a database and not an Access 2007 project file?