shared database

[Pammy]

If a database is on our server, and it is shared, can several open the
database and work on it at the same time? I keep getting an error that say
someone has it opened Exclusive.

 

[Jerry Whittle]

Yes as long as someone doesn't have it open Exclusively. ;-)

Also all the users need read, write, create, and delete or modify privileges
to both the database file AND the entire folder it's in.

Also a lot rides on what you mean by "work on it". For the most part only
one person can be making design changes such as creating or editing forms at
a time. Data entry, deletion, or editing should not be a problem though.

 

[Beetle]

Your db should be split into a Front End and Back End. The FE contains
the queries, forms, reports, and code. The BE contains the tables and
relationships. Onlt the BE should reside on the server. Each user should
have their own copy of the FE, preferebly on their local drive. You then
link each FE to the BE through the network. Use UNC path naming for the
link, rather than drive letter naming. So the path would look like;

\\Servername\SomeFile\YourApp.mdb

instead of

S:\SomeFile\YourApp.mdb

You should NOT have multiple users share the same db over the network. That
is a common cause of corruption in Access applications. Also, Access is
somewhat limited in the number of users. There are varying opinions, but
in general, more than 20-30 would probably be pushing it. It depends
somewhat on whether the users are actively updating many records on a
daily basis, or just viewing them, etc.

 

[Fairytale]

Beetle, I have been told that there is a "free viewer" version of Access that
will enable users that do not have the full "Access" program version to view
& update through a form. The "snapshot viewer" does not seem to allow this
and I can not seem to find one that does. Do you know what that might be?

 

[Beetle]

Some versions of Access have what is called a "Runtime version" which
will allow users without Access installed on their computers to use the db.
If you have Access 2007, the runtime version is a free download. You can
find info about it at;

http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en

However, in prior versions of Access, the runtime was part of the Developers
edition, which is neither free nor cheap from what I understand.

 

[Tony Toews [MVP]]

Some versions of Access have what is called a "Runtime version" which
will allow users without Access installed on their computers to use the db.

All versions of Access since A2.0 had the runtime.

However, in prior versions of Access, the runtime was part of the Developers
edition, which is neither free nor cheap from what I understand.

Well it was called different things and available in differently named
packages. The A2003 was part of Visual Studio Tools for Office.

Microsoft Access (Office) Developer Edition FAQ
http://www.granite.ab.ca/access/developereditionfaq.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Beetle]

Thanks for clarifying that Tony. I've never had a need for a runtime version
so I don't know that much about it. I was just trying to pass along what
little I did know (which might be said for a lot of my answers <g>).
--
_________

Sean Bailey

 

[Fairytale]

This is really great information, thank you both!

The A2003 as part of Visual Studio Tools for Office, is that an older
version of the developer or something? I have Access 2003 as part of the MS
Office Professional Edition. Would I have the ability to set this up with
what I have?

Darla Weber

 

[a a r o n . k e m p f]

NOPE. With an Access backend; you cannot maintain it without kicking
everyone else out of the application.
Sometimes you have random locking problems; and you need to reboot the
file server.

It's best to move to a real database-- like SQL Server.

Find someone on CraigsList to do the work for you.
You'll be much happier.

-Aaron

 

[Tony Toews [MVP]]

The A2003 was part of Visual Studio Tools for Office.

I apologize for missing a key word in there.

The A2003 runtime was part of Visual Studio Tools for Office.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

This is really great information, thank you both!

The A2003 as part of Visual Studio Tools for Office, is that an older
version of the developer or something?

I missed a key word in my explanation.

The A2003 runtime was part of VSTO ( Visual Studio Tools for Office)

I have Access 2003 as part of the MS
Office Professional Edition. Would I have the ability to set this up with
what I have?

No. You need to purchase VSTO. Which is not available from Microsoft
or resellers any more. So you can try Ebay or elsewhere. Also who
knows just how authentic any such versions would be anyhow.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

NOPE. With an Access backend; you cannot maintain it without kicking
everyone else out of the application.
Sometimes you have random locking problems; and you need to reboot the
file server.

Rubbish. My clients never had to reboot servers due to Access.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[aaron_kempf]

don't lie, retard.

Of course they had to reboot file servers to clean up Access locking
problems.
Get over it Tony.

This wonderful invention out there-- called the 90s-- was surpassed
when Access 2000 came out and ADP became the technology of choice.

-Aaron

 

[Jerry Whittle]

Mr Toews creates high quality, well designed database applications. Even I
have never rebooted a server due to a problem with an Access BE.

Must be you.

 

[So Sorry For Poor Aaron]

Must be you.

Egads, no. It couldn't be Aaron, not poor, pitiful litle Aaron. With
Aaron, it's always somebody else. It was somebody else making threats, it
was somebody else using pseudonums, it was somebody else cyberstalking, it
was somebody else lying there cuffed on the sidewalk surrounded by the SWAT
team, it was somebody else pleading guilty after making a deal to get only
probation. It was somebody else, later on, who denied online making that
deal.

It couldn't be Aaron who did something that required rebooting servers... he
never does anything wrong. He just sits there quietly, polishing his fake
halo and waiting for the next opportunity to put it on and play the role of
"angel".

 

[Jerry Whittle]

Must have been before my time here. I did see another poster mention a
restraining order once before.

 

[a a r o n _ k e m p f]

Jerry;

I call bullshit.

You've _NEVER_ had to reboot a file server in order to clean up
locking problems?
You've _NEVER_ had an Access locking problem -- where windows won't
release the lock?

I totally call bullshit.

Nothing wrong with me-- or the things I say.
But the lying MVP and the lying cop -- that made an appointment with
me--- and then got trigger happy?

They can just screw themselves.

-Aaron