I have a database in which Access is automatically generating a
sequence of Admin tables. It is due to the ODBC error (which I
haven't found yet) listed in the table. Access seems to generate
these indefinitely, it looks like this in my listing of tables:
Admin - 00
Admin - 01
Admin - 02
Admin - 03
Admin - 04
....and so on (it got up to 47 before I noticed, LOL)
Why do these get generated? Is there an option to turn this "feature"
off? What's funny is I don't get an error box on the window that is
generating the errors, these Admin tables just get created silently.
Each table has one record in it, the ODBC error:
01003 - 8153 - [Microsoft][ODBC SQL Server Driver][SQL Server]Warning:
Null value is eliminated by an aggregate or other SET operation.
I am using Access 2003.
Any insight would be appreciated. I've been using Access for a long
time and I've never seen this before.
7  6440 
On 17 Apr 2007 06:57:43 -0700, n00b <ad****@email.comwrote:
I'm 99 percent sure these tables are generated by your app, not by
Access.
-Tom.
>I have a database in which Access is automatically generating a
sequence of Admin tables. It is due to the ODBC error (which I
haven't found yet) listed in the table. Access seems to generate
these indefinitely, it looks like this in my listing of tables:
Admin - 00
Admin - 01
Admin - 02
Admin - 03
Admin - 04
...and so on (it got up to 47 before I noticed, LOL)
Why do these get generated? Is there an option to turn this "feature"
off? What's funny is I don't get an error box on the window that is
generating the errors, these Admin tables just get created silently.
Each table has one record in it, the ODBC error:
01003 - 8153 - [Microsoft][ODBC SQL Server Driver][SQL Server]Warning:
Null value is eliminated by an aggregate or other SET operation.
I am using Access 2003.
Any insight would be appreciated. I've been using Access for a long
time and I've never seen this before.
On Apr 17, 9:13 am, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On 17 Apr 2007 06:57:43 -0700, n00b <adv...@email.comwrote:
I'm 99 percent sure these tables are generated by your app, not by
Access.
-Tom.
The app is Access, its a 100% Access application with links to SQL
Server. This access database is a front end, there is no application
outside of this database.
"n00b" <ad****@email.comwrote in message
news:11*********************@b75g2000hsg.googlegro ups.com...
On Apr 17, 9:13 am, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
>On 17 Apr 2007 06:57:43 -0700, n00b <adv...@email.comwrote:
I'm 99 percent sure these tables are generated by your app, not by
Access.
-Tom.
The app is Access, its a 100% Access application with links to SQL
Server. This access database is a front end, there is no application
outside of this database.
Access isn't an application as such, it's a tool to enable the user to build
a database application. Access won't do anything "automatically" unless
it's been programmed to do it. Looks to me like you have some pass-through
queries with the "Log Messages" option set to "yes". "Admin" is the default
username and that is why the tables are named as such.
Click in the "Log Messages" property of a pass-through query and press F1
for more info.
Keith. www.keithwilby.com
Access isn't an application as such, it's a tool to enable the user to build
a database application. Access won't do anything "automatically" unless
it's been programmed to do it. Looks to me like you have some pass-through
queries with the "Log Messages" option set to "yes". "Admin" is the default
username and that is why the tables are named as such.
Click in the "Log Messages" property of a pass-through query and press F1
for more info.
Keith.www.keithwilby.com
Thanks for your help, the log messages setting makes that happen, just
what I needed to know. I see that now in the help like you said.
Much appreciated!
On Tue, 17 Apr 2007 16:01:00 +0100, "Keith Wilby" <he**@there.com>
wrote:
Sweet. I had no idea about this option. Just felt it wasn't a
system-generated table. Turns out it was :-)
-Tom.
>"n00b" <ad****@email.comwrote in message
news:11*********************@b75g2000hsg.googlegr oups.com...
>On Apr 17, 9:13 am, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
>>On 17 Apr 2007 06:57:43 -0700, n00b <adv...@email.comwrote:
I'm 99 percent sure these tables are generated by your app, not by
Access.
-Tom.
The app is Access, its a 100% Access application with links to SQL
Server. This access database is a front end, there is no application
outside of this database.
Access isn't an application as such, it's a tool to enable the user to build
a database application. Access won't do anything "automatically" unless
it's been programmed to do it. Looks to me like you have some pass-through
queries with the "Log Messages" option set to "yes". "Admin" is the default
username and that is why the tables are named as such.
Click in the "Log Messages" property of a pass-through query and press F1
for more info.
Keith.
www.keithwilby.com
"Tom van Stiphout" <no*************@cox.netwrote in message
news:vs********************************@4ax.com...
On Tue, 17 Apr 2007 16:01:00 +0100, "Keith Wilby" <he**@there.com>
wrote:
Sweet. I had no idea about this option. Just felt it wasn't a
system-generated table. Turns out it was :-)
Hi Tom, see my "pass through query" threads. If it wasn't for all the
trouble I was having I wouldn't have known about that option either.
There's always something new to learn :-)
Keith.
"n00b" <ad****@email.comwrote in message
news:11**********************@b58g2000hsg.googlegr oups.com...
>
Thanks for your help, the log messages setting makes that happen, just
what I needed to know. I see that now in the help like you said.
Much appreciated!
No problem, glad to help.
Keith. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Perttu Pulkkinen |
last post by:
Hi all freaks!
I have been thinking hard, what would be good solution for a
straight-forward content management. I want to forget polls and forms etc..
and concentrate first only on different...
|
by: Google Mike |
last post by:
You know, while working on my moonlight corporation's LAMP project at
home this weekend, I couldn't help but wonder if people writing similar
projects are solving similar problems with having to...
|
by: Stephan Neuhaus |
last post by:
Hi all.
I'm having a problem that's driving me nuts. I am not familiar with
Access, but I have read the FAQ, searched google, read the Access
Security FAQ, and looked at the Access Web, to no...
|
by: Karam Chand |
last post by:
Hello,
My linux admin left the job. We had a PostgreSQL
installed under his username. He used to maintain it.
Now I am looking at the Linux box and I am just a
super duper newbie in Linux...
|
by: AnhTai |
last post by:
Hi all,
I've just installed MySQL 5.0 on my sun box (runing Solaris 10, install
from blastwave). This is my first time with MySQL so I don't have any
exp with it.
I have some troubles as:
-...
|
by: luckysingh |
last post by:
I've tried searching alot on the net but am not able to find how to allow a user (not admin/owner) to be able to create & populate the FullText Indexing Catalogs on the tables he creates.
Currently...
|
by: Rahul Babbar |
last post by:
Hi,
I have two users, both of which are part of db2grp1, which is the
admin user.
db2grp1 has atleast 2 users, user1 and user2.
I create a table in user2, name it table2.
When i try to delete...
|
by: gangac |
last post by:
I am currently working on an ms access application for a large insurance
company which generates reports for the user after the user inputs/select
some data....
Unfortunately the application has...
|
by: aklein |
last post by:
I was given a database to update and am running into the following
problem:
The database appears to have been secured using Access security (it is
an MDB, not MDE). Every form etc that I try to...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
| |
