Conversion to MSDE

[Guest]

Hi: I want to convert from Access to MSDE to use on my website. The db is not too big, maybe 1000 records (but with photo files), 4 tables and about 50Mb total. It will be read only except by me. I installed MSDE today and converted my db from access to MSDE. However, there seems to be a "security" type issue. Two tables allow changes, but the other two will not allow any adds, changes, deletes. I have tried to work my way thru the security options (using Accesss as my interface), but I must be missing something (because I am absolutely clueless about the security features with MSDE).

Any help will be greatly appreciated!

 

[Arvin Meyer]

Hi: I want to convert from Access to MSDE to use on my website. The db is

not too big, maybe 1000 records (but with photo files), 4 tables and about
50Mb total. It will be read only except by me. I installed MSDE today and
converted my db from access to MSDE. However, there seems to be a "security"
type issue. Two tables allow changes, but the other two will not allow any
adds, changes, deletes. I have tried to work my way thru the security
options (using Accesss as my interface), but I must be missing something
(because I am absolutely clueless about the security features with MSDE).

Any help will be greatly appreciated!

I can't tell you what the problem may be, but you can use a JET database for
any website which doesn't get a lot of hits. I have a corporate intranet
running on Access that gets about 800 to 1000 hits a day along with 30 other
users without any problems. I also have a public website which often gets as
many as 5000 pageviews a day, about a third of which are driven by an Access
database.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Hi Arvin, Hi Birdman,

I am trying to set up an access DB on the internet and havent got a clueon how to do this.
Could you give me some guidelines, it seems you have done it with success.
I am the moment using a DB that has replications to sync.
But I am still syncing them manually for I havent found the way to do it over internet.
Tnx

Paula

 

[david epsom dot com dot au]

You need to have a primary key on every table. Have you got that?

(david)

Hi: I want to convert from Access to MSDE to use on my website. The db is

not too big, maybe 1000 records (but with photo files), 4 tables and about
50Mb total. It will be read only except by me. I installed MSDE today and
converted my db from access to MSDE. However, there seems to be a "security"
type issue. Two tables allow changes, but the other two will not allow any
adds, changes, deletes. I have tried to work my way thru the security
options (using Accesss as my interface), but I must be missing something
(because I am absolutely clueless about the security features with MSDE).

 

[Guest]

Yes .... So what should I do next ?

You need to have a primary key on every table. Have you got that?

(david)


not too big, maybe 1000 records (but with photo files), 4 tables and about
50Mb total. It will be read only except by me. I installed MSDE today and
converted my db from access to MSDE. However, there seems to be a "security"
type issue. Two tables allow changes, but the other two will not allow any
adds, changes, deletes. I have tried to work my way thru the security
options (using Accesss as my interface), but I must be missing something
(because I am absolutely clueless about the security features with MSDE).

 

[Guest]

Arvin: Thanks for the comments about Access working as a
web database. Now I am really confused. 5,000 hits a day
may work for me as well. My concern was number of users
hitting the database at the same time and the articles
said Jet could handle around 5 at a time (in my case they
are "read" only). I don't imagine I will ever see more
than 25 reading at the same time (and each for only a
split second). I will have an ASP.net page which accesses
the data for a split second for a user and that would be
it. Does this mean Access will work for me? I hope so
because I am very comfortable with Access.

When I finalize my site and am ready to publish, how do I
publish the database? Do I create an MDE file and upload
that?

Thanks for the help and knowledge.

 

[birdman]

I have 4 tables: 2 that I can edit and 2 I cannot. You
observation appears to be on track since the ones I
cannot edit lack a primary key. However, I added a
primary key to one of the tables but it would not let me
edit it - even to add in the id # for the primary key
field. Do I need to add the key into my Access database
and then convert it to MSDE?

Thanks for your time and help.

 

[Larry Linson]

There is no limitation of 5 users on Jet. There is a limitation that MSDE
addes delays to "batch processes" in excess of 5, but that is certainly not
the same as a limit to 5 users. Somewhere you got some bad information about
user limits.

Larry Linson
Microsoft Access MVP

 

[david epsom dot com dot au]

After making any changes in MSDE, you need to compact
and re-link the Access database. Have you done that?

Is the primary key field an identity field? what kind
of field is it?

(david)

 

[david epsom dot com dot au]

I don't know anything about replication. Perhaps you could ask in the
Microsoft.public.access.replication group.

(david)

 

[david epsom dot com dot au]

split second). I will have an ASP.net page which accesses

the data for a split second for a user and that would be

Presumably, you will have only 1 user (the IIS user), so
any mythical limitation on Access users will be irrelevant
anyway. You aren't expecting all your web users to log
into windows separately are you?

IIS has trouble with natively multi-threaded applications
like Jet, so unless you find and follow the instructions
for how to get a single threaded connection you may have
problems if you get a lot of hits. An alternative might be
to set the Jet engine to be single threaded. This whole
area is very badly documented.

You can't compact or replace a Jet database while it is
in use, and you can't mix exclusive and shared and
read-only connections. This makes maintenance of heavily
used sites difficult.

You don't have to make an mde file: that only affects the
VBA project, which you won't use anyway. The file needs
to be in a place that IIS can find it, from the information
in your ASP page. And the folder needs to have the
appropriate permissions for what you are trying to do to
the file.

(david)