Sharing Access

[Profector]

Is there a way to share the back end of an Access 2003 database with users that don't have Access?

I've split my db into front and backend and it works fine if the user has Access 2003. This there another way to split that wouldn't require me to buy Access for everyone else.

The database is actually links to SQL tables, which has more than enough SQL user licenses.

Thanks for reading

Larry

 

[pbaldy]

If you just want them to have access to the data, you can connect to it with Excel with the same ODBC driver.

 

[Profector]

What I'm wanting to share are all the form and reports. We're are actually using a ODBC to link Access to SQL.

 

[pbaldy]

That's the front end, and that's all in Access, so users would need to have either the full or runtime version of Access. For 2003, the runtime version was included in a developer package. The 2007 version is free and available on the MS site.

 

[Profector]

Thanks for the reply. Would the 2007 runtime work with the front end that i've created with 2003?

I did type in back end in the first post. My mistake.

 

[HiTechCoach]

What I'm wanting to share are all the form and reports. We're are actually using a ODBC to link Access to SQL.

There is the Access runtime version. This will allow users to only "run" your database. The can not get to the database container or make design changes, but the can edit the data within your forms.

The Access 2007 version of the runtime is a free download from Microsoft.

 

[pbaldy]

I have users with the 2007 runtime that run 2000 MDE files, so I assume it will run 2003 files as well.

 

[Profector]

Thanks for the replies again. That should solve my problem.