|
 |
access thread: Clone tables
Message #1 by "Al Shah" <ashah1005@y...> on Wed, 14 Nov 2001 19:59:08
|
|
I have an Access 97 database that resides on a server Occasionaly when
users are running the application, clone tables with the user name and
date are created. There's no where in the code that create tables, and
there are make table queries. Any thoughts as to why this occurs?
Message #2 by "Pardee, Roy E" <roy.e.pardee@l...> on Thu, 15 Nov 2001 07:19:28 -0800
|
|
That's very odd... I can't imagine how this would happen without something
going on in code. Is it possible that there are other .mdb's referenced in
your front-end & that the code for creating them is there? (Open a code
window & look at Tools -> References.) The code for creating a table could
be SQL (e.g., "SELECT INTO", "CREATE TABLE") or DAO ("db.TableDefs.Append")
or ADOX (I don't actually know what that code would look like).
HTH,
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487
-----Original Message-----
From: Al Shah [mailto:ashah1005@y...]
Sent: Wednesday, November 14, 2001 11:59 AM
To: Access
Subject: [access] Clone tables
I have an Access 97 database that resides on a server Occasionaly when
users are running the application, clone tables with the user name and
date are created. There's no where in the code that create tables, and
there are make table queries. Any thoughts as to why this occurs?
Message #3 by "Al Shah" <ashah1005@y...> on Thu, 15 Nov 2001 17:00:01
|
|
Thanks for the reply. There are other mdbs linked to the front end, but
it's only tables. The other mdb don't have any modules or forms int them,
the primary purpose of those mdb is data repository. I think this might
be a scenario that may not have a reolution to it.
Thanks
Al
> That's very odd... I can't imagine how this would happen without
something
> going on in code. Is it possible that there are other .mdb's referenced
in
> your front-end & that the code for creating them is there? (Open a code
> window & look at Tools -> References.) The code for creating a table
could
> be SQL (e.g., "SELECT INTO", "CREATE TABLE") or DAO
("db.TableDefs.Append")
> or ADOX (I don't actually know what that code would look like).
>
> HTH,
>
> -Roy
>
> Roy Pardee
> Programmer/Analyst
> SWFPAC Lockheed Martin IT
> Extension 8487
>
> -----Original Message-----
> From: Al Shah [mailto:ashah1005@y...]
> Sent: Wednesday, November 14, 2001 11:59 AM
> To: Access
> Subject: [access] Clone tables
>
>
> I have an Access 97 database that resides on a server Occasionaly when
> users are running the application, clone tables with the user name and
> date are created. There's no where in the code that create tables, and
> there are make table queries. Any thoughts as to why this occurs?
|
|
|
View Cart
