Do not have exclusive access error

S

Suzanne P.

I have a database that we just uploaded onto Citrix. Everything appears to
be working great except that when a second user tries to open the database
when one user is already in the DB, they get a message that says that they
don't have exclusive access and their changes won't be saved. I'm familiar
with this message occurring when there are two people in the database and one
person tries to go into design mode, but this is not the case. There are
simply two people in the database at one time and nobody is in design mode.
I also loaded other databases onto Citrix and they are NOT doing this, so I
know that Citrix is not the problem. Does anyone know what the problem is?

Thank you.
 
A

aaron.kempf

use ADP; if you care enough about your data to build a database-- use a
backend that will love you in return
 
S

Suzanne P.

I figured it out. I didn't create this database so there was a feature I
didn't realize was happening. For some reason when the user logs in to the
database, a make-table query is created, which of course was going into a
design change. Hopefully I can now figure out how to get rid of that make
table query but still accomplish what was happening.
 
A

aaron.kempf

uh instead of 'making a make-table query' you can just execute the
syntax

select *
into tmpTable
from myquery

no query; just dynamic sql

if you were in an adp you could do a lot more exciting stuff

this syntax just wont run in mdb

if exists (select 1 from sysobjects where name like 'tmpTable'
begin
drop table tmpTable
end

select *
into tmpTable
from myquery

this is one sproc in mdb; instead of some code and error handling and
two sql statements.

that is why adp and sql server is much simpler than mdb-- since you can
have a lot more going on in the background; sql server just gives you
more flexibility

-aaron
 
Top