From: ALLAN_ASHFORD via AccessMonster.com on
Hi Gina

You sure can have a look at the "bad" database. As a Zip file it's c. 9 MB
and its back-end c. 17 MB. I can log on remotely and transfer the zip files
or you can log on to me and do the same. The back-end is installed on a drive
mapping of E:\ACCESS, so to use this will save you having to relink the
tables. Also there are ODBC links to Sage Line50 Accounts, but these are not
used in the problem area, although the AUTOEXEC macro will fail to run
properly.

I can give you further pointers as to where the macro runs from as and when.

Let me know how you want to handle it. My e-mail is allannoble(a)btconnect.com,
my mobile +44 777 556 5340.

Allan

Gina Whipp wrote:
>Allan,
>
>There is SOMETHING different and I'll be d***ed I can't figure it out. Any
>chance I get look at the *bad* database?
>
>> Hi Gina
>>
>[quoted text clipped - 30 lines]
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>Allan

--
Message posted via http://www.accessmonster.com

From: Gina Whipp on
Allan,

I looked at evey query attached to that macro, ummm and there were alot, and
I see no reason why they would fail. I am now as stumped as you are. There
are no issues, nothing. The only thing I can think of is if they are
running at the same time then the second one gets stuck because the first
one has *frozen* the process and the second one can't get access to it until
it's done. But even that would be odd unless they are updating the same
data at the same time.

As a side note... Your field names, in some cases, use Reserved Words and
this will cause issues, especially should you upgrade to Access 2007 where
it really has a fit. You might want to have a look at...

http://allenbrowne.com/AppIssueBadWord.html

Some of your tables are designed in a flat file format, that would be more
like Excel spreadsheets then a relational database. If you would like to
take advantage of the power of using a well normalized database, have a look
at...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

http://www.databasedev.co.uk/table-of-contents.html


I am also sending this reply to your email...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"ALLAN_ASHFORD via AccessMonster.com" <u56735(a)uwe> wrote in message
news:a0a4ef46d0365(a)uwe...
> Hi Gina
>
> You sure can have a look at the "bad" database. As a Zip file it's c. 9 MB
> and its back-end c. 17 MB. I can log on remotely and transfer the zip
> files
> or you can log on to me and do the same. The back-end is installed on a
> drive
> mapping of E:\ACCESS, so to use this will save you having to relink the
> tables. Also there are ODBC links to Sage Line50 Accounts, but these are
> not
> used in the problem area, although the AUTOEXEC macro will fail to run
> properly.
>
> I can give you further pointers as to where the macro runs from as and
> when.
>
> Let me know how you want to handle it. My e-mail is > my mobile >
> Allan
>
> Gina Whipp wrote:
>>Allan,
>>
>>There is SOMETHING different and I'll be d***ed I can't figure it out.
>>Any
>>chance I get look at the *bad* database?
>>
>>> Hi Gina
>>>
>>[quoted text clipped - 30 lines]
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>Allan
>
> --
> Message posted via http://www.accessmonster.com
>


From: AccessVandal via AccessMonster.com on
Gina,

I notice the macros OpenQuery "View = Datasheet" and "Data Mode = Edit". Are
these necessary? It's already in datasheet. Not all joint query is Editable.

As far as I know, if you open the Append (Action Query) in DataSheet View,
the Append query will not modify the records, it will only show the data of
the records of the Append query.

Try to remove these, see if it works.

Gina Whipp wrote:
>Allan,
>
>I looked at evey query attached to that macro, ummm and there were alot, and
>I see no reason why they would fail. I am now as stumped as you are. There
snip...

--
Please Rate the posting if helps you.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1

From: Gina Whipp on
AccessVandal,

In the macro yes those settings are required and the other options are not
an option. The subject line is kind of deciptive because those queries he
is referring to are actually, make table and update queries. Oddly, enough
the macro runs in one database FE/BE set-up but not the other. He sent me a
copy of the database and I was looking for some reference to a table or
query that existed in the one database but not the other and after reviewing
MANY queries, found one. So now I am as stumped as he is.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"AccessVandal via AccessMonster.com" <u18947(a)uwe> wrote in message
news:a0e5bd16150f5(a)uwe...
> Gina,
>
> I notice the macros OpenQuery "View = Datasheet" and "Data Mode = Edit".
> Are
> these necessary? It's already in datasheet. Not all joint query is
> Editable.
>
> As far as I know, if you open the Append (Action Query) in DataSheet View,
> the Append query will not modify the records, it will only show the data
> of
> the records of the Append query.
>
> Try to remove these, see if it works.
>
> Gina Whipp wrote:
>>Allan,
>>
>>I looked at evey query attached to that macro, ummm and there were alot,
>>and
>>I see no reason why they would fail. I am now as stumped as you are.
>>There
> snip...
>
> --
> Please Rate the posting if helps you.
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200912/1
>


From: ALLAN_ASHFORD via AccessMonster.com on
Maybe no longer stumped!!

The table that I was trying to append the data to was, as you know, copied
over from the fully functional database. As such it did contain well over 100,
000 redundant records. So I deleted the lot, did a repair & compact and hey
presto everything appears to be OK. Only problem now is - trying to remember
what I was trying to do when the problem hit!!

Many thanks for all the input - have a great Xmas.

Allan

Gina Whipp wrote:
>AccessVandal,
>
>In the macro yes those settings are required and the other options are not
>an option. The subject line is kind of deciptive because those queries he
>is referring to are actually, make table and update queries. Oddly, enough
>the macro runs in one database FE/BE set-up but not the other. He sent me a
>copy of the database and I was looking for some reference to a table or
>query that existed in the one database but not the other and after reviewing
>MANY queries, found one. So now I am as stumped as he is.
>
>> Gina,
>>
>[quoted text clipped - 17 lines]
>>>There
>> snip...

--
Message posted via http://www.accessmonster.com