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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

find the size of this .mdb, using vba

Status
Not open for further replies.
OhioSteve

OhioSteve

MIS
Mar 12, 2002
1,352
US
How do determine the size of the current .mdb or .mde? I have tried "currentproject.properties...". That does not seem to work.
 
Sort by date Sort by votes
I figured it out!

Dim mySize As Long
mySize = FileLen(CurrentProject.FullName)

mySize is the size in bytes.
 
Upvote 0 Downvote
This is a way you could do it

Code: 
Dim fso As FileSystemObject
Dim fil As File
Dim strFileName As String
Dim lngFileSize As Long

strFileName = Me.Application.CodeProject.FullName

Set fso = New FileSystemObject
Set fil = fso.GetFile(strFileName)

lngFileSize = fil.Size
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Question
Find unique rent amount and date this was first charged
Replies
1
Views
67
dhookom
dhookom
M
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
413
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Filter vba problem
Replies
1
Views
282
Andrzejek
Andrzejek
Omarahmed22
  • Locked
  • Question
VBA Formating
Replies
1
Views
236
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
348
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top