Combining databases

We have a developer who created an initial database. He gave me access
to the database via the network by linking me into the main tables and
giving me access to add and modify.

I then designed reports and queries on my computer, which work fine on
my computer. He imported the new objects into the main database and
everything worked great on his computer.

The problem is trying to distribute this to other users who only have
the Access Run Time Environment on their machines. We are getting a
fatal error when we try to open the database on their machines. This
error was not present until my developer imported my objects into the
main database.

This is all based on Access 2003.

The developer has ensured me that all permissions have been properly
set for all users.

Please help.

Thanks in advance.

Troy

Re: Combining databases

schreef in bericht =
news:0ad0842a-7090-49ce-b809-1915331f4a96@m3g2000hsc.googleg roups.com...
> We have a developer who created an initial database. He gave me access
> to the database via the network by linking me into the main tables and
> giving me access to add and modify.
>=20
> I then designed reports and queries on my computer, which work fine on
> my computer. He imported the new objects into the main database and
> everything worked great on his computer.
>=20
> The problem is trying to distribute this to other users who only have
> the Access Run Time Environment on their machines. We are getting a
> fatal error when we try to open the database on their machines. This
> error was not present until my developer imported my objects into the
> main database.
>=20
> This is all based on Access 2003.
>=20
> The developer has ensured me that all permissions have been properly
> set for all users.
>=20
> Please help.
>=20
> Thanks in advance.
>=20
> Troy

Nice question but ...what's the 'fatal' error ??=20
Any 'message' from Access ??
Please explain a bit more. We can't see your database here.

Are you using external references ??=20
Does the database compile ??

Arno R

Re: Combining databases

Hi Troy,

You have a couple of options. One option is to load Access 2003 on all
the workstations.

Another option, the option I use, is to deploy mdb files using the
Visual Studio 2005 "Click Once" deployment feature which can deploy most
anything from mdb's, Excel files, and .Net applications. This requires
the .Net 2.0 framework on all workstations and on the server (which is
free from msdn). "Click Once" will load the Access runtime for you and
all required files. Incase you decide to experiment with this option --
here is the code for deploying an mdb (or ADP in my case)

//code for deploying files using C# - if you remove the brackets {},
///, ; , change 'using' to 'Imports' and change Process p to Dim p As
Process = new Process() then it is vb.Net code
---------------------------------------------
using System;
using System.Diagnostics;

namespace SubscriberClient {
static class Program {
///