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 Chriss Miller 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
Joined
Mar 12, 2002
Messages
1,352
Location
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
  • Locked
  • Question Question
Find unique rent amount and date this was first charged
Replies
4
Views
1K
dhookom
dhookom
M
  • Locked
  • Question Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
4K
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question Question
Filter vba problem
Replies
1
Views
932
Andrzejek
Andrzejek
Omarahmed22
  • Locked
  • Question Question
VBA Formating
Replies
1
Views
851
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question Question
Remove everything including the comma from the last comma of a string.
Replies
10
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top