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!

Deploy Access .mdb with VB app

Status
Not open for further replies.
genomon

genomon

Programmer
Aug 20, 2001
2,449
US
I've never developed and shipped a VB app with an Access .mdb for users that do not have Access installed (although it does work fine). Does anyone know if there will be compacting issues after repeated use of the database? I'm a bit concerned since I can't shell out the compact if the user PC doesn't own an Access installation...
Thanks!

I have great faith in fools; self-confidence my friends call it.
-Poe
 
Sort by date Sort by votes
If you reference DAO, you can write your own compacting utility in VB6:
Code: 
DBEngine.CompactDatabase mstrDBPath, strDBFolder & "\Temp.mdb"

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

HieuNguyen12
  • Locked
  • Question
Live Refresh Aloha with CMD
Replies
0
Views
120
HieuNguyen12
HieuNguyen12
emmanuel mathew
  • Locked
  • Question
Enhanced Visibility, Better Integrations with Cloud ERP Software Solutions
Replies
0
Views
114
emmanuel mathew
emmanuel mathew
Nyan Win
  • Locked
  • Question
Open multple Access reports by same(one) criteria with DoCmd
Replies
0
Views
89
Nyan Win
Nyan Win
Tranciscolabs9876
  • Locked
  • Question
#1 App Development Company in Gurgaon-TranciscoLabs
Replies
0
Views
109
Tranciscolabs9876
Tranciscolabs9876
Netsurfer802
  • Locked
  • Question
How To Fix a "Connection To Broadcast Server" Error with Touchstar Predictive Dialer
Replies
0
Views
119
Netsurfer802
Netsurfer802

Part and Inventory Search

Sponsor

Back
Top