By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,827 Members | 2,267 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,827 IT Pros & Developers. It's quick & easy.

Query Prompt acting crazy...

P: n/a
I have a query that has a prompt for date as

Between [Enter Start Date - Format "MM/DD/YYYY:] And [Enter End Date -
Format "MM/DD/YYYY:]

This database is hosted on a share drive. About half of my user's are
ok with the report that has this query the other half when the prompt
comes up for the first sections the box displays

Enter Start Date - Format "MM/DD/YYYY:,2

its putting a ",2" in for some reason. How can some Access Installs
understand this and the report shows fine and retrieves records and
others it bombs on?

Thanks,

Dave

Dec 22 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
If, as I read this, you have multiple users concurrently logged in to your
front-end or monolithic database, you significantly increase the risk of
database corruption. I can't say if the effect you are seeing is a result of
having multiple users concurrently logged in.

You should, in any case, split the database into front end (queries, forms,
reports, macros, and modules) with a copy on each user's machine, with
tables linked to tables in a shared back end (tables, relationships, and
data) in a shared folder.

That _may_ also clear up the problem.

Larry Linson
Microsoft Access MVP
<st********@hotmail.comwrote in message
news:11**********************@80g2000cwy.googlegro ups.com...
>I have a query that has a prompt for date as

Between [Enter Start Date - Format "MM/DD/YYYY:] And [Enter End Date -
Format "MM/DD/YYYY:]

This database is hosted on a share drive. About half of my user's are
ok with the report that has this query the other half when the prompt
comes up for the first sections the box displays

Enter Start Date - Format "MM/DD/YYYY:,2

its putting a ",2" in for some reason. How can some Access Installs
understand this and the report shows fine and retrieves records and
others it bombs on?

Thanks,

Dave

Dec 23 '06 #2

P: n/a

I found that the machines having the issues are running Access 2000 and
the machines that are fine are running 2003. I didnt think that this
issue would be version related. But once I upgraded the Access 2000
machines to Access 2003, all is well.

I'm still going to split it as you suggested..

Thanks,

Dave

Larry Linson wrote:
If, as I read this, you have multiple users concurrently logged in to your
front-end or monolithic database, you significantly increase the risk of
database corruption. I can't say if the effect you are seeing is a result of
having multiple users concurrently logged in.

You should, in any case, split the database into front end (queries, forms,
reports, macros, and modules) with a copy on each user's machine, with
tables linked to tables in a shared back end (tables, relationships, and
data) in a shared folder.

That _may_ also clear up the problem.

Larry Linson
Microsoft Access MVP
<st********@hotmail.comwrote in message
news:11**********************@80g2000cwy.googlegro ups.com...
I have a query that has a prompt for date as

Between [Enter Start Date - Format "MM/DD/YYYY:] And [Enter End Date -
Format "MM/DD/YYYY:]

This database is hosted on a share drive. About half of my user's are
ok with the report that has this query the other half when the prompt
comes up for the first sections the box displays

Enter Start Date - Format "MM/DD/YYYY:,2

its putting a ",2" in for some reason. How can some Access Installs
understand this and the report shows fine and retrieves records and
others it bombs on?

Thanks,

Dave
Dec 29 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.