Wow.. this is annoying me...

[Jewellissa]

I do not know why.. and needless to say to it is really annoying me...

Every Make-Table Query I make creates the table as Read-Only and I dont know why or how. I dont think Acess 2000 has done this the whole time i have been workign on my project.. but only remember this happening half-way thorugh.

Is there something I clicked in error?

Specifically.. I am creatign tables and then running a Delete Query on them and 2000 wont let me because the table is read-only.

Any help is totally appreciated!!!!

Jewelz

 

[dcx693]

Are you creating tables within an Access database, or in an external database?

 

[Jewellissa]

Internal...

No I am creating it from a macro in that database.

J

 

[dcx693]

Strange, and these tables are normal Access tables, not linked right? (Sorry to beat a dead horse, but wanted to make abs certain.) If you make a copy of the table, can you even open the open to add a new record or make edits?

 

[Jewellissa]

No problem...

Yeah they aren't linked or anything.

It might not be that they are write-protected just when it wont execute the delete query the only thing the computer animated help thingy (Mine is the cute robot.. ) tells me is it mgiht be Read Only.. soo....

 

[roelandkim]

Do you have security setup on the database?

 

[Jewellissa]

No I haven't touched that yet.. except maybe accidentally..

Personally.. I think I have hit some option accidentally and messed it up.. so if oyu can think of an option that controls this...