Does an Access query negate the benefits of utilizing SQL

[Pat Hartman]

I think the 2.1 was a service pack. From this list, it looks like they didn't change the number. My mistake.

PS, I do have Access apps that have multiple BE's but not because of size. It is because the apps were developed at different times and have only a couple of tables in common. I would never consider creating multiple BE's due to size constraints. When you reach the limit of one BE, it's time to move on.

 

[isladogs]

Hi Pat
Please can you give me the source for the image in your last post. I would like to include it in one of my Web articles. Thanks

 

[The_Doc_Man]

Colin, I found an image like that under a web search for "Access Version History" and some side-wise finagling.

 

[Pat Hartman]

Hi Colin,
Sorry, I didn't keep the link. I just clipped the table. But I was searching for what Doc said.

 

[isladogs]

OK. A quick search led to Microsoft Access - Wikipedia

 

[Pat Hartman]

I didn't get it from Wikipedia. The mid-step is missing from that post.

 

[isladogs]

I realised it was different but its actually even better for what I wanted.