Yes, I'm currently working with Access. And boy thats fun. Is there a way to generate the SQL create script for a group of tables in Access and then run that against another Access database? The ...

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It’s not, as Mary Ann Richardson shows us. SQL ...

What are the advantages of using Access as the front end to a SQL Server database? For starters, it’s likely that your client’s users will be more familiar with it, and it’s relatively easy to put in ...

If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL, but ...

How to create a Form for a Query or Table, using Form How to Edit and Delete Data in a Form How to Navigate through Records. How to add and delete rows and Records in a Form Shantel has studied Data ...

Sometimes I'm just plain lazy. Other times I don't want to have to spend hours debugging ASP code because of typos so I've found a way to help short cut some repetitive ASP coding tasks. The idea is ...