Linking Access to a SQL File (MDF) ideally not local with Asp2.0

[brandonjelinek]

I have a SQL file running my web page. It is a MDF file running with SQL
2005 express edition. The Web Pages are Running Asp2.0. My dream in life
is to build a MS Access front end to that data file where i can read, modify
and add rows to all the tables in that SQl file. Even when i am not local.

For the short term.. i just want to link Access to that SQl file without
locking up the database so the web pages can keep working while i make
changes on the access side.

Any ideas on a good way to accomplish this... First just connecting locally
with access and second.. connecting through asp2.0?

Brandon

 

[Joe]

Hi Dirk,

This should be fairly straightforward, if I understand your problem
correctly. Simply create a new Access project file (adp) and chose the
"Project using existing data" option. Fill out the data link properties and
you are all set.
Jope this helps,
Joe

 

[Norman Yuan]

YOu do not link anything to *.mdf file, which is exclusively used by SQL
Server/Express. You link Access (*.mdb) or connect Access (*.adp) to a
database in SQL Server/Express, locally, or remotely (as long as the network
setup allows you to). It is rare someone let their SQL Server open on the
Internet to allow remote connection. Here is where web applications come:
user access data in database indirectly through the web applications.

 

[brandonjelinek]

ya looks like project will connect me locally just fine. I think in order
to gain remote access to the sql file, i will need to program access to send
data through the aspx 2.0 page.

thanks guys

 

[dbahooker]

I run Access Data Projects 'across the wire' all the time.

Whether it is VPN or the public friggin internet... it is a great
platform

 

[brandonjelinek]

ok i tried that project thing and here is my problem. I attempt to have it
attach to the database file and i get the same old error

---------------------------
Microsoft Data Link Error
---------------------------
Test connection failed because of an error in initializing provider. Unable
to open the physical file "C:\Inetpub\synod434\App_Data\Database.mdf".
Operating system error 32: "32(The process cannot access the file because it
is being used by another process.)".
---------------------------
OK
---------------------------

This is because web services seems to lock that file to a single user. Is
there a way to allow multiple users of the file using SQL server 2005 express?

brandon

 

[Brendan Reynolds]

By default, SQL Server 2005 Express Edition allows only local connections.
It has to be configured to allow remote connections. See the following KB
article ...

http://support.microsoft.com/kb/914277/en-us

 

[brandonjelinek]

ya i have run the service area config.. remote connections seem to work
fine.. with the whole asp thing working.. it is that the web service world
wide web publishing seems to lock the data file so i cant connect to the
database with MS access as a project and keep it live on the web side at the
same time.

 

[dbahooker]

then you should legitimately REGISTER it with the database server;
instead of trying to do a User Connection