This is a batch process to create credit card and ACH transactions. The transactions are derived from an account table and inserted into a temporary transaction table (tblTempTranactions, not a...

Jeff,

I agree. It appears that when you use a pass-through query in Access it uses transactions. The reason I believe that is the case is because when the timeout occurs,...

Greg,

We have several issues compounding the timeouts. The timeout in Access is set to 480 seconds but heavy processor usage, an intermittent memory error that we believe is the memory...

Steven,

As to why you didn't receive an error message...

We have one installation of Access 2003 that will not return error messages unless that user compiles the MDB on their own...

Matthew,

Good point. I figured out the reason it wasn't working. The test team had not set a fee value in the test environment and I set the query to bypass...

John,

Check out this blog. http://blogs.msdn.com/access/ Read the threads in October and November and you'll find the discussion interesting and hopeful.

I had/have a bit of concern over Microsoft's committment to the...

One disadvantage to Microsoft's approach is the inability to force a password policy. We want passwords to expire every 30 days and not allow reuse. I am unaware of anyway...

Not sure if this "bug" in Access has been fixed or not because I still work around it - always!

It used to be that if you had a Bit...

Start writing your reports in Crystal and you'll be back to Access pretty quickly. The limitations of Access related to the number of users also goes away when you use...

Assuming you are storing the data from the website in SQL Server, why not just attach the SQL tables to the Access database. All that is then necessary is a...

Sorry folks. I prepared a response earlier today with several examples and somehow it didn't post. Probably because I worked on it off and on over several hours (between tasks...

Okay. I'll have to do that once I get to the office tomorrow morning.

What I'm saying is that searching the datetime column with a hardcoded varchar value is faster than searching with a parameter being passed in as datetime. It doesn't make much...

I realize that realtime comparisions can vary but these were consistent times in each of about 5 compares.

Sergiv, you are correct about the two datatypes. The column is datetime which...

Make certain that any logical fields (Yes/No in Access) that convert to Bit fields in SQL have a default value of (0). Otherwise you may run into updating issues where...