473,245 Members | 1,567 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,245 software developers and data experts.

Temporary Tables. Where will they be created

I have 2 databases called (for example) "progs.mdb" and "files.mdb".
Both these databases reside on computer "myserver". The progs database
has links to the tables in the files database.
"myclient1" runs a shortcut "msaccess.exe \\myserver\progs.mdb /x
startmacro".
"myclient2" runs his shortcut "msaccess.exe \\myserver\progs.mdb /x
startmacro".

If I use a temporary table I take it that it will be created on
"myserver" in the "progs.mdb" and if the two users try to create the
table at the same time I'm going to have big problems.

I need to create the temporary tables on the clients machine but still
retain a central progs database.

Thanks Mike
Nov 12 '05 #1
3 3224
Actually, you are raising the probability of corruption if you have multiple
users logging in to the same front-end or monolithic database. You need to
give each user a copy of the front-end and link to the shared tables
database.

Where temporary tables are created depends on how you go about creating
them, but normally, they are in the database that the user is executing
(front-end). However, there is a method for creating a temporary database
and creating temporary tables in that, then deleting the temporary database
when done to avoid memory bloat. You'll find it at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.

He's also got the best collection of information and links on multiuser
Access environments that I know about, so it'd be a good place to go and
explore.

Larry Linson
Microsoft Access MVP

"Mike Ridley" <gi******@hotmail.com> wrote in message
news:e5*************************@posting.google.co m...
I have 2 databases called (for example) "progs.mdb" and "files.mdb".
Both these databases reside on computer "myserver". The progs database
has links to the tables in the files database.
"myclient1" runs a shortcut "msaccess.exe \\myserver\progs.mdb /x
startmacro".
"myclient2" runs his shortcut "msaccess.exe \\myserver\progs.mdb /x
startmacro".

If I use a temporary table I take it that it will be created on
"myserver" in the "progs.mdb" and if the two users try to create the
table at the same time I'm going to have big problems.

I need to create the temporary tables on the clients machine but still
retain a central progs database.

Thanks Mike

Nov 12 '05 #2
Thanks for the information. I found Tony's site very helpful.
Calling the front end "progs.mdb" from the server saves me having to
maintain separate copies on the client PCs.

"Larry Linson" <bo*****@localhost.not> wrote in message news:<lX*****************@nwrddc03.gnilink.net>...
Actually, you are raising the probability of corruption if you have multiple
users logging in to the same front-end or monolithic database. You need to
give each user a copy of the front-end and link to the shared tables
database.

Where temporary tables are created depends on how you go about creating
them, but normally, they are in the database that the user is executing
(front-end). However, there is a method for creating a temporary database
and creating temporary tables in that, then deleting the temporary database
when done to avoid memory bloat. You'll find it at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm.

He's also got the best collection of information and links on multiuser
Access environments that I know about, so it'd be a good place to go and
explore.

Larry Linson
Microsoft Access MVP

"Mike Ridley" <gi******@hotmail.com> wrote in message
news:e5*************************@posting.google.co m...
I have 2 databases called (for example) "progs.mdb" and "files.mdb".
Both these databases reside on computer "myserver". The progs database
has links to the tables in the files database.
"myclient1" runs a shortcut "msaccess.exe \\myserver\progs.mdb /x
startmacro".
"myclient2" runs his shortcut "msaccess.exe \\myserver\progs.mdb /x
startmacro".

If I use a temporary table I take it that it will be created on
"myserver" in the "progs.mdb" and if the two users try to create the
table at the same time I'm going to have big problems.

I need to create the temporary tables on the clients machine but still
retain a central progs database.

Thanks Mike

Nov 12 '05 #3
gi******@hotmail.com (Mike Ridley) wrote in
news:e5**************************@posting.google.c om:
Calling the front end "progs.mdb" from the server saves me having
to maintain separate copies on the client PCs


And is absolutely the wrong thing to do, as eventually, it will blow
up in your face for any number of reasons. You may be lucky and only
corrupt the front end. Or you may corrupt the back end data file, as
well.

Users of a shared front end can also experience weird behavior, not
limited to getting write conflict dialogs when they close forms (for
example, if they've applied a filter/sort, the default is to save
that on close of the form, and if someone else has done the same
thing, there could be a write conflict between the two people
closing the form).

And, of course, from A2K on, you can't actually make changes in the
front end while users are in it, so that "advantage" (I would have
called it "disaster waiting to happen") is gone.

It was never a good idea.

The Access documentation has never suggested such a multi-user setup
for as long as I've been using it (since 1996, with Access 2.0). I
don't understand how anyone who has a multi-user app could end up
with the impression that it's a good idea.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Peter Gorelczenko | last post by:
I'm running as normal user (not root or database owner). This user has c= reate=20 temporary table priv. show tables partial: GRANT CREATE TEMPORARY TABLES ON `foobar0`.* TO 'foo'@'localhost'...
2
by: Ryan | last post by:
Just a quicky about temporarary tables. If using QA, when you create a temporary table, it gets dropped if you close the query. Otherwise you need to state 'DROP TABLE myTable' so that you can...
11
by: randi_clausen | last post by:
Using SQL against a DB2 table the 'with' key word is used to dynamically create a temporary table with an SQL statement that is retained for the duration of that SQL statement. What is the...
30
by: btober | last post by:
Whenever I create a temporary table, with something like CREATE TEMPORARY TABLE temptable1 AS SELECT * FROM paid.ad_hoc_query; New schemas appear, with names like "pg_temp_1". I guess the...
1
by: Sampath Reddy | last post by:
Hi Everybody, We are using UDB v8.1 I will explain about my Stored procedures which we are executing in UDB AIX box. We have 3 millions(apporox) of data in 22 tables. By applying the business...
4
by: Mike Ridley | last post by:
I have 2 databases called (for example) "progs.mdb" and "files.mdb". Both these databases reside on computer "myserver". The progs database has links to the tables in the files database....
0
by: Zlatko Matić | last post by:
I tried to work with postgres temporary tables from MS Access, but unsuccessfully... I was able to create temporary table by pass-through query, also I succeeded in creating linked table through...
8
by: Martijn van Oosterhout | last post by:
Currently you can create temporary tables that are deleted at the end of the session. But how about temporary views? It's just a table with a rule so I don't imagine it would be terribly difficult....
1
by: Stefan van Roosmalen | last post by:
Hi there, Is there a way to list the TEMPORATY tables? I have tried SHOW TABLES, but this command only list the regular tables. Thank you very much for your answer. Regards, Stefan.
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.