Question Locked

Parameters for a data access page to a ms-access data base on a web site

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I ceated data access pages in a ms-database on my PC, then i have uploaded this data base on a host (webng.com) that supports ms-access.
It doesnt work : a message says the user information file is absent.
How can I define the connexion string (OLE DB, ODBC, ... and the value of parameters)

6 replies

by seanferd

Can't view it, can't connect, can't write to it? When does this failure occur?

You'll need to provide more info to the members if the following doesn't help.

(For anyone else reading, the site supports ASP 3.0 with MS Access databases.)
_________________________

What method can I use to connect to my MS Access database?

You must use a dsn-less connection when connecting to your database. Below is an example how to connect to your database using a dsn-less connection.

<%

DIM objConn

Set objConn = Server.CreateObject("ADODB.Connection")

objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _

Server.MapPath ("data/database.mdb") & ";"

objConn.Open
%>

*NOTE* --That left angle bracket at the end is a percent sign.-- I'm not messing with formatting right now, especially with the TR site being wonky.
_____________________________
How can I set write permissions to my databases?

The "data" directory has write permissions. Therefore, please place databases that require write permissions in that folder.

Why do I encounter "Cannot update database or object is read-only" error message?

You must give your database write permissions. To do this please place your databases in the "data" directory.

Why do I encounter "Selected collating sequence not supported by the operating system" error message?

This error message pertains to the different orders in the MS Access database. If you use a different language version of MS Access and the "New Database Sort Order" is "Non-English Character" by default. You must change it to "General" before you create the database. If you had already create it with a "Non-English Character" you should import the old data to a new database with the "General" set.

by jean.defrance

Thank you for your advices,
When reading your mail, I think that I don't use the correct tools :
I use directly a data access page under the ACCESS wizzard
I get the error : The workgroup Information file is missing or opened exclusively by another user

Peharps, I will be obliged to use ASP ...
Don't you think so ?
Best regards.

by seanferd

"This error message occurs when a your code cannot find the workgroup
information file (.mdw). Make sure that you put the workgroup file in a
shared folder along with the database."

It seems like you need to upload the MDW file for the database (your system.mdw if there is no other mdw file). This file, and any password for the file, needs to be added to the connection string.

Perhaps have a look at this:
http://support.microsoft.com/kb/300699

and this
http://www.microsoft.com/technet/prodtechnol/windows2000serv/reskit/iisbook/c07_dsn-less_connections.mspx?mfr=true

http://www.powerasp.com/content/database/dsn_vs_dnsless.asp

I can't go much further with this, perhaps someone else will offer suggestions.

Otherwise, perhaps do an internet search for your error message, including the error number, since you know which version of Access and which providers you are using.
A search on "DSN less connection" yields many results, you may be able to find something specific to your case.

Best of luck to you
- Sean

by jean.defrance

Thank you for your advises, I uploaded my system mdw file, an I used a UNC path : the reply come within twenty seconds, but I get the same message "cannot find MDW file, or file is locked".
I don't know what to do ...

by jean.defrance

I'm now trying to install a VPN between my laptop and the web site hosting my ms-access data-base. As it a chance to work ?

This discussion is closed to new replies.