Open access in oxn user workspace

H

HDI

Hi,

I have multiple access front end object that are not multi user.

Is it possible (and how of course) to open a access front end object
in is own workspace?

Thx
 
A

aaron.kempf

use Access Data Projects and give everyone their own database

that way, everything is in one place, instead of in 100 different
files for each user
 
A

Aaron Kempf

you should just use Access Data Projects.

it is really really easy to give different users 'different copies of
queries' for example

and this just isn't possible in the MDB world
 
H

HDI

you should just use Access Data Projects.

it is really really easy to give different users 'different copies of
queries' for example

and this just isn't possible in the MDB world









- Tekst uit oorspronkelijk bericht weergeven -
Click to expand...


OK, but my back end has still access databases.
 
A

aaron.kempf

nobody should use MDB for anything

i'm sorry that you're too dumb to be a programmer

MDB isn't reliable

if it was a car, you guys would have traded it in under 'lemon laws'
 
T

Tony Toews [MVP]

HDI said:
OK, but my back end has still access databases.
Click to expand...

Aaron's answer for every question is to use ADPs and SQL Server.

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
 
T

Tony Toews [MVP]

HDI said:
I have multiple access front end object that are not multi user.

Is it possible (and how of course) to open a access front end object
in is own workspace?
Click to expand...

There is a CreateWorkspace method with lots of explanation in the
code. I suspect that isn't exactly what you are looking for.

What is your objective? What are you trying to do?

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
 
A

Aaron LIVES!

he's trying to allow different users to have different copies of the same
query

SQL Server allows this.. and you don't need multiple files
 
S

Susie Johnson

seriously tony

argue against the facts

SQL Server allows a different copy OF EVERY OBJECT FOR EVERY PARTICULAR USER

Does MDB?

SQL Server lets you do this in a managed way-- in one place-- on a server
 
H

HDI

There is a CreateWorkspace method with lots of explanation in the
code. I suspect that isn't exactly what you are looking for.

What is your objective? What are you trying to do?

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 athttp://www.granite.ab.ca/accsmstr.htm
Click to expand...

There are a lot of access programs that I have to rewrite with the
back end a sql server.
But I can't do everything at the same time.

So the problem is that the access front end files are on a share (A
access front end per user isn't an option for this situation) and the
reports are build on queries (build in code). So you see what happens
if more than one user is logged in. (Report A is build on query A and
query A is build on query B and query B is build on query C).

So if i know an easy access solution for this problem the users can
work for now and I can take my time for building a sql server
solution.

So my question is:

Is there a way that the user opens a front end and work in his own
workspace so he can create queries and other users can't see them.
Of course the best one.

If that isn't possible can I create the queries in memory and not in
the access front end file.

Don't blame me it is written in the past and I have to solve this.
 
T

Tony Toews [MVP]

HDI said:
There are a lot of access programs that I have to rewrite with the
back end a sql server.
But I can't do everything at the same time.

So the problem is that the access front end files are on a share (A
access front end per user isn't an option for this situation)
Click to expand...

Why is an Access FE per user not an option? Can you at least give each user their
own FE on the server?

We strongly, strongly urge each user to have their own copy of the FE. Preferably on
their local system but on the server otherwise.
and the
reports are build on queries (build in code). So you see what happens
if more than one user is logged in. (Report A is build on query A and
query A is build on query B and query B is build on query C).
Click to expand...

So the code creates the queries in the MDB? That's interesting. Usually I just
pass a WHERE clause to the report. Or the queries the report is based on uses
various fields on a form with selection criteria such as Job number, client name or
date ranges.
Is there a way that the user opens a front end and work in his own
workspace so he can create queries and other users can't see them.
Of course the best one.
Click to expand...

Not to my knowledge.
If that isn't possible can I create the queries in memory and not in
the access front end file.
Click to expand...

Again not to my knowledge.
Don't blame me it is written in the past and I have to solve this.
Click to expand...

Not a problem there.

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
 
Top