Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Maximum number of records in a table
There is no specific maximum number of records - the limit is typically with the size of an MDB file, and that varies depending on the version of Access you are using. To determine the maximum size of an MDB file, do HELP on "specifications" and it will be listed. We see many cases...- WendellB
- Post #2
- Forum: Microsoft: Access Tables and Relationships
-
Linked Tables from Access to SQL
It depends on what technology you are using. If you have Access 97, then you are limited to an ODBC connection which you have to setup for each workstation using the database. The ODBC connection is made in Control Panel, and you specify a SQL Server and the database on that server. You then...- WendellB
- Post #2
- Forum: Microsoft: Access Tables and Relationships
-
Disappearing Triggers in SQL Server 2000
We just discovered that one of the insert triggers for a table has disappeared. A check of a backup from a few weeks ago shows it was there at that point, but none of the development staff believes they did anything to cause the disappearance. This is the second instance where this appears to...- WendellB
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
