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
 question about database editing.....
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

kcomphlint
Starting Member

USA
25 Posts

Posted - 09 February 2001 :  10:22:35  Show Profile  Visit kcomphlint's Homepage  Send kcomphlint an AOL message  Send kcomphlint an ICQ Message
i have access 2000. whenever i have to edit the forum database, it tells me that i have to convert it first.

ok, so i do that and change the strConnString in config.asp to the Access 2000 line, but the forum will not open the database for some reason. even when i run the setup.asp file, all it says is that it cannot find the database.

any ideas?

j e r e m y | f l i n t
kiNETic communications

Doug G
Support Moderator

USA
6493 Posts

Posted - 09 February 2001 :  13:16:07  Show Profile
When you convert the db it makes a new .mdb file with a new name. You should only need to convert to Access 2000 format one time and then use the new .mdb file for future stuff. Make sure your connection string has the right .mdb filename in it.

======
Doug G
======
Go to Top of Page

kcomphlint
Starting Member

USA
25 Posts

Posted - 13 February 2001 :  10:23:00  Show Profile  Visit kcomphlint's Homepage  Send kcomphlint an AOL message  Send kcomphlint an ICQ Message
okay, when i convert the database, i renamed it to snitz_dbase.mdb.

then i went to my config.asp file and changed the name in the MSAccess2000 strConnString to read that file:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data; Source=c:\Inetpub\wwwroot\forum\tools\snitz_dbase.mdb;" '## MS Access 2000


but when i went back to my browser and tried to go to my forum, i got this error message:
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.


Code : -2147467259


so i don;t know what could be causing it not to read the database after the conversion.

j e r e m y | f l i n t
kiNETic communications
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20600 Posts

Posted - 13 February 2001 :  15:11:14  Show Profile  Visit HuwR's Homepage
check the acees permissions for the new db, they may be incorrect.

'Resistance is futile'
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.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07