yourfirstserver.comFriday, 25 May 2012
Find Us on : RSS/Feed Facebook Twitter

Importing External Access Database Tables Using Visual Basic by Nicholas Brown

Sometimes a Microsoft Access database user may find it desirable to automate the process of importing tables from an external Access database file into their current database. Below is a segment of code that provides an example of how to accomplish this.

 

‘*******CODE*******

Dim root As String

Dim srcDB As database

Dim tdf As TableDef

Dim x As Integer

 

Root = “C:”

Set srcDB =

...

Dot Net Questions: System Tables and Sql Server 2000 Query

System tables are the groups of table that helps sql server to track the information regarding users, databases, tables, replications tasks and so many task and also helps in sql query just like insert query, delete sql query, update sql query,. All information regarding database that is knows by sql server are in system tables. These system tables are break down into server groups.

1) The master databases contain information regarding databases, logins, server and some system wide information.

2) Each data base contains some table which

...