I'm using SQL within Visual Basic in conjunction with Access
databases. Say I am about to insert a record with a long string for a
particlar field. It would be useful to prevent errors to first
interrogate the DB to learn the maximum permissible length of that

Due to 8 year old XP burning out a fan and mother board, I was forced
to move to Vista.
Dell 530 Desktop
After numerous blue screens and other hassles, I got Office XP

Interesting information found at PASGOM. Just click on;
http://www.pasgom.org/traffic.html
http://www.pasgom.org/Stores.html
You may look at this important INFO, view the short but interesting

I have experienced something in Access that is completely
inexplicable and gives me shivers.  I was creating a query inside the
query wizard that I knew should return several records.  I ran the
query and it returned no results.  I was staring at the design of the

I have been given a database with 2,944 tables in it.  Each table has
35 rows and columns labeled Dur, 20, 21, 22, 23, 24, 25, 26 ..... 64,
65.  They contain insurance rates by age and band.
Currently all the tables are the same length and width.  I need to go

I'm trying to merge several tables of simillar information.  I can't
do this to the table that I linked from as the information should
always be in flux.  I'm not getting the Make-table query right for
some reason.

What if you could recapture your ex lovers mind, heart and
soul?...Wipe the slate clean? Turn back time? Even if you feel right
now that your situation is too far gone…too screwed up …or just plain
too darn complicated?

I'm getting a problem with importing an Excel spreadsheet into a table
in a SQL Server 2000 back-end. I'm doing this in VBA in an onClick
event proc in an Access 2003 project.
The target table's owner is 'dbo', but the database connection is via

I realize that user level security is not available for Access
databases in the new AK27 format .accdb, and I know that I can still
utilize ULS by making my database an .mdb file.
But I'm wondering WHY Microsoft is scrapping a feature that I've

I have an app that will send out an email periodically.
My table has one row and three columns:  a primary key, an "EmailFrom"
Address and an Email template.
The template is the text of the email and will have varying amounts and

1. MS ACCESS COMBO LIST = JAN;FEB;MAR;APR;MAY;
-----------------------------------
2. DATA TABLE:
N1 | N2 | N3 | JAN | FEB | MAR | APR | MAY |

I am using the "Application.FollowHyperlink strFilePath, , True" line
of code from within access forms to launch any file type I want (e.g.,
xls, doc, pdf, etc.).  The files open up okay, but open up in the
background.  How do I make them open in front where they are visible?

It seems like the built-in compact function does not compact at all. A
mdb file made under 2003 has been grown to over 100Mb. Compacting in
access 2003 results in a file smaller then 5Mb. Campacting the same
file under 2007 does not become smaller at all.

I have an option group control with 2 choices:  
Sort ASC and Sort DESC
When this choice is made, I want to change the recordsource for the
current form and do a refresh so it sorts that data in the order

My computer is dual boot Vista and XP.  I have Access 2003 and 2007
installed on both partitions.  The problem that I am having is that
some of my Access 2003 databases crash when I try to do a compact and
repair or create an .mde when using Access 2003 under Vista.  I get