Conversion to MSDE

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!

"birdman" wrote in message
...
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

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

"Arvin Meyer" wrote:

"birdman" wrote in message
...
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

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

(david)

"birdman" wrote in message
...
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!

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


"david epsom dot com dot au" wrote:

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

(david)

"birdman" wrote in message
...
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!

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


"david epsom dot com dot au" wrote:

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

(david)

"birdman" wrote in message
...
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: 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.
-----Original Message-----
"birdman" wrote in
message
news:E1BF5B74-D8DB-4C11-9DFB-
...
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


.

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.
-----Original Message-----
"birdman" wrote in
message
news:E1BF5B74-D8DB-4C11-9DFB-
...
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


.

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.
-----Original Message-----
You need to have a primary key on every table. Have you
got that?

(david)

"birdman" wrote in
message
news:E1BF5B74-D8DB-4C11-9DFB-
...
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 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.
-----Original Message-----
You need to have a primary key on every table. Have you
got that?

(david)

"birdman" wrote in
message
news:E1BF5B74-D8DB-4C11-9DFB-
...
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!


.