Member Avatar for ricvik

Hello all,

I'm using MS Access as my DB for a very simple web site.
Everything was running nicely till all of a sudden I can't inset rows into any table in my MS Access database.
In my tests I even created a fresh and clean table1 with one number field and tried to insert into it but, as with all other tests for all tables, I get this error message (using a third party Query Analyzer):

There was an error while executing the query:
child list for field Table cannot be created

I use a simple:

INSERT INTO table1 (Test_field)
VALUES (5)

Again - all was working fine till an hour ago...
I'm baffled. Any help will be greatly appreciated.

Thanks,

Asaf

  • 2 Contributors
  • 2 Replies
  • 108 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by ricvik

Recommended Answers

All 2 Replies

Member Avatar for debasisdas

I suspect a relation is broken accidentally.

Member Avatar for ricvik

Thanks for the reply.
Truthfully, when it comes to DBs I go pretty basic - simple tables, no connections, no keys, etc.
The thing is that it used to work and then it didn't.
I have no idea what I did to trigge that.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.