can't run a query on other computers but it works fine on mine - w

L

Lorina

Hi
I have a very simple query (pulls 4 fields from one table) and I have it on
a switchboard to run. It's saved in a folder on the network and I have added
that folder to trusted. It works great for me on my computer. But when I
try to open it on anyone other computer I get a box that says "there was an
error executing the command" and that is all it says!

I have opened it on mine in Access 2007 and also on our Termserver with
Access 2003 (written in 2003). What am I missing to make it able for others
to use it?
 
T

Tom Wickerath

Hi Lorina,

Split the database into two .mdb (or .accdb if that applies) files: a
"Front-End" (FE) application file, and a "Back-End" (BE) data file. The FE
application file will contain all of your queries, forms, reports, macros,
modules and perhaps any local (unshared) tables. The BE data file will
contain the tables that hold shared data.

The BE database is installed on the file server, and each user must have
RWED privileges for the folder in question. An easy test to verify such
privileges for each user is to sit down at their computer, logged in as that
user, and attempt to save a new text file with NotePad or WordPad to the
shared folder. You should also be able to edit the contents of this text
file, and delete this file. Then move on to the next person's PC and repeat
this sequence of tests.

A copy of the FE application file is installed on each user's local hard
drive, so that no two users are ever opening the same FE file.

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm

Good Luck!


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top