access database.
Originally I had my asp page and access in the same server so i used the bottom code to get to the files
Connect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:\Inspector\BGSolutions_Data_M.mdb"
The FOlder Inspector is in that server roots
Now My boss wants me to put the asp/web files into a new server but get the database from the old place.
But I ran into a lot of problem trying to do so
at this moment if i try to access it directly like this
Connect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "\\skcaqts\Inspector\BGSolutions_Data_M.mdb"
I get this error
The Microsoft Jet database engine cannot open the file '\\skcaqts\Inspector\BGSolutions_Data_M.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
__________________
1. Shahadat Hossain: Mufambisi c Mashud; Chigumbura lbw; Utseya c Mashud
2. Abdur Razzak: P Utseya caught; RW Price lbw; CB Mpofu lbw
3. Rubel Hossain: Corey J A bowled; BB McCullum caught; JDS Neesham caught
4. Taijul Islam: T Panyangara bowled; J Nyumbu lbw; TL Chatara bowled
5. Taskin Ahmed: DAS Gunaratne c Soumya; Lakmal c fiz; Pradeep bowled
|