Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 How to use accdb & Compacting them?		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

sadra
Starting Member

Iran
30 Posts
Posted - 20 November 2007 :  05:53:56  Show Profile  Send sadra a Yahoo! Message
for switch to accdb file you can use below code:
strConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("./db/snitz.accdb") & "; Persist Security Info=False;"	'## MS Access 2007
strConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Inetpub\db\snitz.accdb;Jet OLEDB:Database Password=MyDbPassword;"	'## MS Access 2007 with Password


but how to Compacting accdb file?
please help me
[red]how soon is too late[/red]

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 20 November 2007 :  05:57:33  Show Profile  Send ruirib a Yahoo! Message
To tell you the truth, I don't see why you can't use a .mdb file. Why use the new one? What advantage comes from that?

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

sadra
Starting Member

Iran
30 Posts
Posted - 20 November 2007 :  06:35:07  Show Profile  Send sadra a Yahoo! Message
quote:
Originally posted by ruirib

To tell you the truth, I don't see why you can't use a .mdb file. Why use the new one? What advantage comes from that?


because the accdb file is low Size
[red]how soon is too late[/red]
Edited by - sadra on 20 November 2007 06:37:38
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 20 November 2007 :  07:25:29  Show Profile  Send ruirib a Yahoo! Message
Personally I think that when the DB size gets big enough to matter, it's time to consider migrating to MySQL or SQL Server. Actually, you're bound to have problems before that, so I really don't see the point in using an Access 2007 format. Anyway, that's just me and I don't know the if that format raises compacting issues or not.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts
Posted - 20 November 2007 :  15:09:35  Show Profile  Send pdrg a Yahoo! Message
Each version of Access comes with new flashes in the pan (Access Data Pages, anyone?), I'd be inclined to carry on with the well supported and loved .mdb for now, or migrate to MSSQL if you're really torturing the server.

.accdb may be great, never played with it, but I wouldn't be in a rush to use it in place of a trusted 'known good', no matter what the guys in MS Marketing tell you.
Go to Top of Page

sadra
Starting Member

Iran
30 Posts
Posted - 21 November 2007 :  05:42:23  Show Profile  Send sadra a Yahoo! Message
Thanks, I Resolvent my Question!

See:
For Connection;
strConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("./db/snitz.accdb") '## MS Access 2007
strConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Inetpub\db\snitz.accdb;Jet OLEDB:Database Password=MyDbPassword;" '## MS Access 2007 with Password

and for Compacting in "admin_compactdb.asp";
strTempConnString = "Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=" & strTempFile & ";Jet OLEDB:Engine Type=5"
[red]how soon is too late[/red]
Edited by - sadra on 21 November 2007 05:43:37
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07