compact on close option

[Abbey Normal]

Does anyone know why I can remove this option from the users' database? I
have about 10 users accessing a db and they dont have delete authority to the
db folder. the db is leaving copies db1,db2,db3 because it can't delete
it/replace it; To keep from having all the extra copies of the db, I'd like
to just remove the option, but it won't let uncheck it. [I uncheck it, click
apply, click ok, exit database, get back in, and it is still checked....] Any
ideas anyone can give me would be appreciated! Thank you,

 

['69 Camaro]

Hi.

This problem is occuring for two reasons:

1.) The database is in a multiuser environment, but it is not split. (Your
change is being overwritten by someone else who has the database file open
at the same time.)

2.) All users must have "Full Control" Windows security permissions on the
network directory where the Access database is located.

For more information on split databases, please see the following Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#SplitDB

For more information on methods to avoid problems in a multiuser
environment, please see the following Web page for a link to the article,
"Multiuser Databases":

http://www.Access.QBuilt.com/html/articles.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Abbey Normal]

Okay, so I need to split it, and I've been reading a bit about it. Can anyone
answer some initial questions?
1. I have 10 users (including me, developing) accessing it. Can I split it
one at a time - i.e. Me, then when i'm more familiar with that process
everyone else?
2. How do I make an MDE? and Distribute it - is it part of the splitting
utility? or does someone know of a web site where I can read more about that?
3. I'm also cosidering just upgrading to msSQL - should I just do that, and
ignore splitting entirely? (about 5 of the users will need to access the
split db over a wan in about 4-5 months)
Thanks for any info shared!!

Hi.

This problem is occuring for two reasons:

1.) The database is in a multiuser environment, but it is not split. (Your
change is being overwritten by someone else who has the database file open
at the same time.)

2.) All users must have "Full Control" Windows security permissions on the
network directory where the Access database is located.

For more information on split databases, please see the following Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#SplitDB

For more information on methods to avoid problems in a multiuser
environment, please see the following Web page for a link to the article,
"Multiuser Databases":

http://www.Access.QBuilt.com/html/articles.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

Does anyone know why I can remove this option from the users' database? I
have about 10 users accessing a db and they dont have delete authority to the
db folder. the db is leaving copies db1,db2,db3 because it can't delete
it/replace it; To keep from having all the extra copies of the db, I'd like
to just remove the option, but it won't let uncheck it. [I uncheck it, click
apply, click ok, exit database, get back in, and it is still checked....] Any
ideas anyone can give me would be appreciated! Thank you,

 

['69 Camaro]

Hi.

Okay, so I need to split it,

Before you split it, make sure that all users have "Full Control" Windows
security permissions on the shared network directory where the database
tables are going to be.

Can I split it
one at a time - i.e. Me, then when i'm more familiar with that process
everyone else?

A wise decision. Make a copy of the database and play with just the copy.
Test functionality to ensure that everything still works after the split.
When you are comfortable splitting the database on your play copy, then you
can split the production version that everyone else uses.

How do I make an MDE?

See the Access Help topic: "About MDE files (MDB)." When ready to create
the MDE file, select the Tools menu -> Database Utilities -> Make MDE
file... and follow the steps. If you have problems, please see the "Can't
make an MDE!" checklist on the following Web page to help you determine why
you can't create the MDE database:

http://www.Access.QBuilt.com/html/conversion.html

and Distribute it

One can automate the distribution of the front end with Tony Toews's autofe
utility. Please see the following Web page for more information:

http://www.granite.ab.ca/access/autofe.htm

I'm also cosidering just upgrading to msSQL - should I just do that, and
ignore splitting entirely?

When you "upsize" to MS SQL Server, it will split the database for you.
However, there may be issues that will be difficult to troubleshoot because
you won't know at first glance whether it's an Access issue or a SQL Server
issue. If you split the database first with the Database Splitter Wizard,
you'll have already worked out the split database issues within Access, so
you can focus mainly on SQL Server for the solutions to any problems.

(about 5 of the users will need to access the
split db over a wan in about 4-5 months)

Microsoft Access does not do well on a WAN. Use MS SQL Server for the back
end when you migrate to a WAN.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

Okay, so I need to split it, and I've been reading a bit about it. Can anyone
answer some initial questions?
1. I have 10 users (including me, developing) accessing it. Can I split it
one at a time - i.e. Me, then when i'm more familiar with that process
everyone else?
2. How do I make an MDE? and Distribute it - is it part of the splitting
utility? or does someone know of a web site where I can read more about that?
3. I'm also cosidering just upgrading to msSQL - should I just do that, and
ignore splitting entirely? (about 5 of the users will need to access the
split db over a wan in about 4-5 months)
Thanks for any info shared!!

Hi.

This problem is occuring for two reasons:

1.) The database is in a multiuser environment, but it is not split. (Your
change is being overwritten by someone else who has the database file open
at the same time.)

2.) All users must have "Full Control" Windows security permissions on the
network directory where the Access database is located.

For more information on split databases, please see the following Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#SplitDB

For more information on methods to avoid problems in a multiuser
environment, please see the following Web page for a link to the article,
"Multiuser Databases":

http://www.Access.QBuilt.com/html/articles.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

Does anyone know why I can remove this option from the users' database? I
have about 10 users accessing a db and they dont have delete authority

to
the

db folder. the db is leaving copies db1,db2,db3 because it can't delete
it/replace it; To keep from having all the extra copies of the db, I'd like
to just remove the option, but it won't let uncheck it. [I uncheck it, click
apply, click ok, exit database, get back in, and it is still

checked....]
Any

ideas anyone can give me would be appreciated! Thank you,

 

[Douglas J. Steele]

Option 1 doesn't really make sense. Split it, and give everyone his/her own
copy of the front-end. You won't gain the true benefits of splitting until
your users aren't sharing the same front-end.

Tools | Database Utilties | Make MDE File. Make sure you've compiled the
database first to catch any errors that might prevent the conversion.

Moving to SQL Server is still going to require splitting. The only
difference is that your back-end will be in SQL Server, not a Jet database.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Okay, so I need to split it, and I've been reading a bit about it. Can anyone
answer some initial questions?
1. I have 10 users (including me, developing) accessing it. Can I split it
one at a time - i.e. Me, then when i'm more familiar with that process
everyone else?
2. How do I make an MDE? and Distribute it - is it part of the splitting
utility? or does someone know of a web site where I can read more about that?
3. I'm also cosidering just upgrading to msSQL - should I just do that, and
ignore splitting entirely? (about 5 of the users will need to access the
split db over a wan in about 4-5 months)
Thanks for any info shared!!

Hi.

This problem is occuring for two reasons:

1.) The database is in a multiuser environment, but it is not split. (Your
change is being overwritten by someone else who has the database file open
at the same time.)

2.) All users must have "Full Control" Windows security permissions on the
network directory where the Access database is located.

For more information on split databases, please see the following Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#SplitDB

For more information on methods to avoid problems in a multiuser
environment, please see the following Web page for a link to the article,
"Multiuser Databases":

http://www.Access.QBuilt.com/html/articles.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

Does anyone know why I can remove this option from the users' database? I
have about 10 users accessing a db and they dont have delete authority

to
the

db folder. the db is leaving copies db1,db2,db3 because it can't delete
it/replace it; To keep from having all the extra copies of the db, I'd like
to just remove the option, but it won't let uncheck it. [I uncheck it, click
apply, click ok, exit database, get back in, and it is still

checked....]
Any

ideas anyone can give me would be appreciated! Thank you,