RE: Shared MDB Performance with Access and ASPNET Clients

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Is this database a front end or a back end?
Back end Access 2003 database with only tables.

It is a split database? If so, where does the front end reside?
Yes. Front end resides on each client computer.

Are multiple users accessing the same front end?
No.

Can you describe how you are using OLE in this situation?
OLE used in the connection string of the ASP.NET web.config
(Provider=Microsoft.Jet.OLEDB.4.0).
Front-end Access client program file uses both OLE and ODBC. Front end is
linked to most tables in the back end database via DAO ODBC connection.
There are some tables that are not linked to the front end containing program
user names. Data from these tables is retrieved via ADO using the OLEDB
provider (Provider=Microsoft.Jet.OLEDB.4.0).

You say the users all have modify permissions where the mdb file is located,
does that mean read, write, create, delete? That is what is required.
Yes. I have given all users full permissions to make sure nothing is left out.


--
DavidT
Austin, TX

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200910/1

.

Relevant Pages

  • Re: Database request support from normal user in their VD
    ... how do I know whether my server supports "Ole Db connection string" ... some users request to use database ...
    (microsoft.public.inetserver.iis)
  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... database without knowing anything beforehand except the driver name. ... need a connection string and different data sources use different connection ... ODBC, ADO, and VB Script. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... Depending on the database you are using, ... you need to know the basics of the connection string and can populate ... no. the login box which you are talking about was provided to ODBC ... When the user exits the dialog box, the driver connects ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Word 2003 Closes upon update of sort order of table using Acce
    ... Yes the security thing is why I haven't used OLE DB as I wasn't seeing the ... database does bring up the user log in. ... "Peter Jamieson" wrote: ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Change Connection String at runtime.
    ... easily moved to another database, or have versions for each database. ... connection string to the connectionobject before the connection opens. ... *The Server IP number is different for every deployment. ... It appears that the generated code uses the application settings to ...
    (microsoft.public.dotnet.framework.adonet)